DOO_ORDER_LINES_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name

HEADER_ID LINE_ID LINE_NUMBER STATUS_CODE OWNER_ID SOURCE_LINE_ID SOURCE_LINE_NUMBER SOURCE_ORDER_ID SOURCE_ORDER_NUMBER SOURCE_ORDER_SYSTEM SOURCE_SCHEDULE_ID SOURCE_SCHEDULE_NUMBER ITEM_TYPE_CODE ORDERED_QTY CANCELED_QTY ORDERED_UOM SOURCE_ORG_ID ORG_ID ACTUAL_SHIP_DATE SCHEDULE_SHIP_DATE RMA_DELIVERED_QTY EXTENDED_AMOUNT FULFILLED_QTY FULFILLMENT_DATE LINE_TYPE_CODE OBJECT_VERSION_NUMBER OPEN_FLAG CANCELED_FLAG INVENTORY_ITEM_ID PARENT_LINE_ID ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_LINE_REF ROOT_PARENT_LINE_ID SHIPPED_QTY UNIT_LIST_PRICE UNIT_SELLING_PRICE DELTA_TYPE REFERENCE_LINE_ID COMP_SEQ_PATH TRANSFORM_FROM_LINE_ID CATEGORY_CODE INVENTORY_ORGANIZATION_ID ON_HOLD ITEM_SUB_TYPE_CODE QUANTITY_PER_MODEL

Query

SQL_Statement

SELECT HEADER_ID, LINE_ID, LINE_NUMBER, STATUS_CODE, OWNER_ID, SOURCE_LINE_ID, SOURCE_LINE_NUMBER, SOURCE_ORDER_ID, SOURCE_ORDER_NUMBER, SOURCE_ORDER_SYSTEM, SOURCE_SCHEDULE_ID, SOURCE_SCHEDULE_NUMBER, ITEM_TYPE_CODE, ORDERED_QTY, CANCELED_QTY, ORDERED_UOM, SOURCE_ORG_ID, ORG_ID, ACTUAL_SHIP_DATE, SCHEDULE_SHIP_DATE, RMA_DELIVERED_QTY, EXTENDED_AMOUNT, FULFILLED_QTY, FULFILLMENT_DATE, LINE_TYPE_CODE, OBJECT_VERSION_NUMBER, OPEN_FLAG, CANCELED_FLAG, INVENTORY_ITEM_ID, PARENT_LINE_ID, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_DOCUMENT_LINE_REF, ROOT_PARENT_LINE_ID, SHIPPED_QTY, UNIT_LIST_PRICE, UNIT_SELLING_PRICE, DELTA_TYPE, REFERENCE_LINE_ID, COMP_SEQ_PATH, TRANSFORM_FROM_LINE_ID, CATEGORY_CODE, INVENTORY_ORGANIZATION_ID, ON_HOLD, ITEM_SUB_TYPE_CODE, QUANTITY_PER_MODEL FROM DOO_LINES_ALL