DOO_LINES_ALL_V
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
ACTUAL_SHIP_DATE CANCELED_FLAG CANCELED_QTY CATEGORY_CODE COMP_SEQ_PATH CREATED_BY CREATED_IN_RELEASE CREATION_DATE DISPLAY_LINE_NUMBER EXTENDED_AMOUNT FULFILLED_QTY FULFILLMENT_DATE HEADER_ID INVENTORY_ITEM_ID INVENTORY_ORGANIZATION_ID ITEM_SUB_TYPE_CODE ITEM_TYPE_CODE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LINE_ID LINE_NUMBER LINE_TYPE_CODE ON_HOLD OPEN_FLAG ORDERED_QTY ORDERED_UOM ORG_ID ORIG_SYS_DOCUMENT_LINE_REF ORIG_SYS_DOCUMENT_REF OWNER_ID PARENT_LINE_ID QUANTITY_PER_MODEL RMA_DELIVERED_QTY ROOT_PARENT_LINE_ID SCHEDULE_SHIP_DATE SHIPPED_QTY SOURCE_LINE_ID SOURCE_LINE_NUMBER SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_ORG_ID SOURCE_REVISION_NUMBER SOURCE_SCHEDULE_ID SOURCE_SCHEDULE_NUMBER STATUS_CODE TRANSFORM_FROM_LINE_ID UNIT_LIST_PRICE UNIT_SELLING_PRICE |
Query
SQL_Statement |
---|
SELECT DLA.ACTUAL_SHIP_DATE, DLA.CANCELED_FLAG, DLA.CANCELED_QTY, DLA.CATEGORY_CODE, DLA.COMP_SEQ_PATH, DLA.CREATED_BY, DLA.CREATED_IN_RELEASE, DLA.CREATION_DATE, DLA.DISPLAY_LINE_NUMBER, DLA.EXTENDED_AMOUNT, DLA.FULFILLED_QTY, DLA.FULFILLMENT_DATE, DLA.HEADER_ID, DLA.INVENTORY_ITEM_ID, DLA.INVENTORY_ORGANIZATION_ID, DLA.ITEM_SUB_TYPE_CODE, DLA.ITEM_TYPE_CODE, DLA.LAST_UPDATED_BY, DLA.LAST_UPDATE_DATE, DLA.LAST_UPDATE_LOGIN, DLA.LINE_ID, DLA.LINE_NUMBER, DLA.LINE_TYPE_CODE, DLA.ON_HOLD, DLA.OPEN_FLAG, DLA.ORDERED_QTY, DLA.ORDERED_UOM, DLA.ORG_ID, DLA.ORIG_SYS_DOCUMENT_LINE_REF, DLA.ORIG_SYS_DOCUMENT_REF, DLA.OWNER_ID, DLA.PARENT_LINE_ID, DLA.QUANTITY_PER_MODEL, DLA.RMA_DELIVERED_QTY, DLA.ROOT_PARENT_LINE_ID, DLA.SCHEDULE_SHIP_DATE, DLA.SHIPPED_QTY, DLA.SOURCE_LINE_ID, DLA.SOURCE_LINE_NUMBER, DLA.SOURCE_ORDER_ID, DLA.SOURCE_ORDER_NUMBER, DLA.SOURCE_ORDER_SYSTEM, DLA.SOURCE_ORG_ID, DLA.SOURCE_REVISION_NUMBER, DLA.SOURCE_SCHEDULE_ID, DLA.SOURCE_SCHEDULE_NUMBER, DLA.STATUS_CODE, DLA.TRANSFORM_FROM_LINE_ID, DLA.UNIT_LIST_PRICE, DLA.UNIT_SELLING_PRICE FROM DOO_LINES_ALL DLA |