SELECT ooha.ORDER_NUMBER "SALES ORDER"
,ooha.ORDER_CATEGORY_CODE
,oola.ORDERED_ITEM
,oola.SUBINVENTORY
,rsh.SHIPMENT_NUM
,rsh.RECEIPT_NUM
,rsh.CUSTOMER_ID
,rsl.UNIT_OF_MEASURE
,rsl.ITEM_DESCRIPTION
,rsl.SHIPMENT_LINE_STATUS_CODE
,rsl.SOURCE_DOCUMENT_CODE
FROM OE_ORDER_HEADERS_ALL ooha
,OE_ORDER_LINES_ALL oola
,RCV_SHIPMENT_HEADERS rsh
,RCV_SHIPMENT_LINES rsl
WHERE 1=1
AND ooha.header_id = oola.header_id
AND ooha.header_id = rsl.OE_ORDER_HEADER_ID
AND rsh.shipment_header_id = rsl.shipment_header_id
AND rsl.OE_ORDER_LINE_ID = o ola.line_id
AND ooha.ORDER_NUMBER = '56'
AND rsl.SOURCE_DOCUMENT_CODE = 'RMA';
No comments:
Post a Comment