Sunday 19 February 2017

How to find the requisition with PO details (Relation with Requisition and PO (Purchase Order ) in Oracle apps EBS R12 )

How to find the  requisition with PO details (Relation with Requisition and PO (Purchase Order ) in Oracle apps EBS R12 )

    ---- Requistion wise PO (Purchase Order) Details ---
SELECT porh.segment1 "Req Num", poh.segment1 "PO Num", porl.QUANTITY "Req Quantity",porl.UNIT_PRICE "Req Price",porl.UNIT_MEAS_LOOKUP_CODE "Req UOM"
  FROM po_headers_all poh,
       po_distributions_all pod,
       po_req_distributions_all pord,
       po_requisition_lines_all porl,
       po_requisition_headers_all porh
 WHERE poh.po_header_id = pod.po_header_id
   AND pod.req_distribution_id = pord.distribution_id  
   AND pord.requisition_line_id = porl.requisition_line_id
   AND porl.requisition_header_id = porh.requisition_header_id
   AND porh.SEGMENT1 = NVL(:Req_Num,porh.segment1)

--------------------------END ----------------------------------------

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...