Find the Script for Receipt Number with PO(Purchase Order NO) using SQL Query in Oracle Apps EBS R12

--- Find the Script for Receipt Number with PO(Purchase Order NO) using SQL Query in Oracle Apps EBS R12 ---

SELECT  pha.segment1 po_number,  rsh.receipt_num receipt_number
           FROM po_headers_all pha,
                rcv_shipment_lines rsl,
                rcv_shipment_headers rsh
          WHERE rsl.po_header_id = pha.po_header_id
            AND rsl.shipment_header_id = rsh.shipment_header_id
            AND pha.segment1 = NVL (:p_po_num, pha.segment1)
            AND rsh.receipt_num = NVL (:p_receipt_num, rsh.receipt_num)