--- 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)
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)
No comments:
Post a Comment