-
-

Supply Order and supply lines

SUPPLY CHAIN

Query the Supply Order and supply lines created for a Sales Order

SELECT dsh.SUPPLY_ORDER_NUMBER , dsl.LINE_NUMBER , dsh.SUPPLY_ORDER_REFERENCE_NUMBER , dsl.SUPPLY_ORDER_REF_LINE_NUMBER, dsh.HEADER_ID , dsh.INTERFACE_SOURCE_CODE , dsh.INTERFACE_BATCH_NUMBER , dsh.SUPPLY_ORDER_NUMBER , dsh.SUPPLY_ORDER_SOURCE , dsh.SUPPLY_REQUEST_DATE , dsh.SUPPLY_ORDER_REFERENCE_NUMBER , dsh.SUPPLY_ORDER_REFERENCE_ID , dsh.STATUS_CODE , dsh.SUPPLY_ORDER_SOURCE , dsl.CUSTOMER_ORDER_SOURCE_SYSTEM , dsl.ITEM_TYPE , dsl.OBJECT_VERSION_NUMBER , dsl.PARENT_LINE_ID , dsl.LINE_NUMBER , dsl.SUPPLY_OPERATION , dsl.STATUS_CODE , dsl.SUPPLY_TYPE , dsl.SUPPLY_SOURCE_SYSTEM , dsl.SOURCE_SYSTEM_ID , dsl.INVENTORY_ITEM_ID , dsl.EXEC_SYSTEM_ITEM_NUMBER , dsl.QUANTITY , dsl.SUPPLY_ORDER_REFERENCE_LINE_ID , dsl.SECONDARY_QUANTITY , dsl.SECONDARY_UOM_CODE , dsl.NEED_BY_DATE , dsl.DESTINATION_ORGANIZATION_ID , dsl.DESTINATION_ORGANIZATION_CODE , dsl.DESTINATION_BU_ID , dsl.CHANGE_PENDING_FLAG , dsl.BACK_TO_BACK_FLAG , dsl.CONTRACT_MANUFACTURING_FLAG , dsl.CONFIG_ITEM_FLAG , dsl.CUSTOMER_ORDER_NUMBER , dsl.CUSTOMER_ORDER_LINE_NUMBER , dsl.CUSTOMER_ORDER_SCHEDULE_NUMBER , dsl.CUSTOMER_ID , dsl.CUSTOMER_SHIP_TO_ID , dsl.CUSTOMER_CONTACT_ID , dsl.SPLIT_LINE_REFERENCE_ID , dsl.PREPARER_ID , dsl.OUTSIDE_PROCESSING_FLAG , dsl.MOVEMENT_REQUEST_FLAG FROM fusion.dos_supply_headers dsh , fusion.dos_supply_lines dsl WHERE dsl.header_id = dsh.header_id AND SUPPLY_ORDER_REFERENCE_NUMBER IN ('&SOURCE_ORDER') ORDER BY dsh.header_id DESC , dsl.line_number