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 make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...