Friday, 8 June 2018

How to find the RMA order receipt details in Oracle Apps R12 ?


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

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...