In this post we’ll see query to get GRN details of PO in Oracle Fusion Cloud, this is a basic requirement usually comes to display GRN receipt details which are raised against PO purchase order during report development on Purchasing.
select RSH.RECEIPT_NUM
from RCV_SHIPMENT_HEADERS rsh
,RCV_SHIPMENT_LINES rsl
,RCV_TRANSACTIONS rct
where RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND rct.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND rsl.SHIPMENT_LINE_ID = rct.SHIPMENT_LINE_ID
AND RSL.po_header_id = :p_po_header_id