-
-

Supply Order Interface data

SUPPLY CHAIN

Query the Supply Order Interface data for the Sales Order - This informs SCO that a SCO order is to be created.

SELECT I.INTERFACE_BATCH_NUMBER , I.LINE_INTERFACE_ID , i.interface_source_code intf , i.supply_order_source src , h.supply_order_reference_number , H.SUPPLY_ORDER_REFERENCE_ID , i.supply_order_reference_line_id reflineid, i.process_status sts , i.supply_type supply , i.inventory_item_id item , i.quantity qty , i.supply_operation oprn , i.supply_order_header_id supplyheader , i.creation_date , i.process_status , m.message_text , m.MESSAGE_NAME , m.TOKEN_NAME_A , m.TOKEN_VALUE_A , m.TOKEN_NAME_B , m.TOKEN_VALUE_B , m.TOKEN_NAME_C , m.TOKEN_VALUE_C FROM fusion.dos_supply_lines_int i, fusion.dos_messages m , fusion.dos_supply_headers_int h WHERE m.processing_entity_type(+) = 'INTERFACE_LINE' AND m.processing_entity_id(+) = i.line_interface_id AND i.header_interface_id = h.header_interface_id AND h.supply_order_reference_number IN ('&SOURCE_ORDER') ORDER BY h.SUPPLY_ORDER_REFERENCE_NUMBER, I.LINE_INTERFACE_ID , i.creation_date ASC;