-
-

errors on creation of Supply order Documents

SUPPLY CHAIN

Query errors on creation of Supply order Documents - Requisition, Invoice, etc.

SELECT h.SUPPLY_ORDER_REFERENCE_NUMBER, h.header_id SupplyOrderNumber , h.SUPPLY_ORDER_SOURCE , l.Line_number || '.' || tl.TRACKING_LINE_NUMBER tLine, 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_tracking_lines tl, fusion.dos_messages_v m , fusion.dos_supply_headers h , fusion.dos_supply_lines l WHERE m.processing_entity_type (+) = 'TLINE' AND m.processing_entity_id (+) = tl.tracking_line_id AND l.header_id = h.header_id AND tl.header_id = h.header_id AND TL.LINE_ID = L.LINE_ID AND h.SUPPLY_ORDER_REFERENCE_NUMBER IN ('&SOURCE_ORDER') ORDER BY h.SUPPLY_ORDER_REFERENCE_NUMBER, l.Line_number