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