Thursday 19 January 2017

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)  

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...