Requisition tables in oracle apps r12.link between po_requisition_headers_all and po_headers_all

Requisition tables in oracle apps r12.link between po_requisition_headers_all and po_headers_all

po_requisition_headers_all table

 

This is the Requisition Headers Table. In this table we got PREPARER_ID, SEGMENT1 Requisition No , AUTHORIZATION_STATUS,TYPE_LOOKUP_CODE Requisition Type , Approved Date , Source

 

 

 

po_requisition_lines_all table

 

This is the Requisiion Lines Table.In this table we got Item Id , Qty , Unit Price , Vendor ID ,

 

 

po_req_distributions_all table

 

This is the Purchase Requisition Distributions Table. In this table we get the Accounting GL code for Requisition Lines.

 

 

link between po and requisition in oracle apps and how to get requisition number from po number

 

link between po_requisition_headers_all and po_headers_all

 

join between po_requisition_headers_all and po_headers_all

 

 

SELECT r.segment1 "Req Num", ph.segment1 "PO Num"

FROM po_headers_all ph,

po_distributions_all d,

po_req_distributions_all rd,

po_requisition_lines_all rl,

po_requisition_headers_all r

WHERE ph.po_header_id = d.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

 

link between po_lines_all and po_requisition_lines_all

 

SELECT r.segment1 "Req Num", ph.segment1 "PO Num",pll.*

FROM po_headers_all ph,

po_distributions_all d,

po_lines_all pll,

po_req_distributions_all rd,

po_requisition_lines_all rl,

po_requisition_headers_all r

WHERE ph.po_header_id = d.po_header_id

AND d.req_distribution_id = rd.distribution_id

 

Requisition tables in oracle apps r12.link between po_requisition_headers_all and po_headers_all