Tuesday, 11 July 2017

How to check the Purchase order link with Purchase requisition in Oracle ebs (front end)

We can identify two different way:

1.SQL query to find.
2.Oracle EBS --> (front end)

SQL:

/* Formatted on 7/11/2017 3:07:26 PM (QP5 v5.114.809.3010) */
SELECT   r.segment1 "Req Num",
         p.segment1 "PO Num",
         r.CREATION_DATE po_req_date,
         p.CREATION_DATE po_creation_date,
         (rl.UNIT_PRICE * rl.QUANTITY) REQ_AMOUNT,
         (pl.UNIT_PRICE * pl.QUANTITY) PO_AMOUNT,
         p.TYPE_LOOKUP_CODE PO_Type
  FROM   po_headers_all p,
         po_lines_all pl,
         po_distributions_all d,
         po_req_distributions_all rd,
         po_requisition_lines_all rl,
         po_requisition_headers_all r
 WHERE       pl.po_line_id = d.po_line_id
         AND p.po_header_id = pl.po_header_id
         AND d.req_distribution_id = rd.distribution_id
         AND rd.requisition_line_id = rl.requisition_line_id
         AND rl.requisition_header_id = r.requisition_header_id
 
Oracle EBS --> (front end)  

 Query the Requisition # and find

 

 Select line tab








Go to Tools and find PO

 

 We can find the PO #



No comments:

Post a Comment