PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow

po base tables in oracle apps r12 Complete Information's

 

po_headers_all

 

This is the Purchase Order Headers Table in Oracle Apps. Here below you will find po_headers_all table columns details.

We can find the po number in po_headers_all in Segment1 Column of PO_HEADERS_ALL table.

 

 

This table have informations like PO Number, PO Type , Vendor Id ,Vendor Site Id,Currency ,PO Status.

 

 

PO_LINES_ALL

Here's Below we can find po_lines_all table description

 

This is the PO Lines Tables in Oracle Apps. In This Table We have ITem_Id , Qty , ITem Description ,UOM , UNIT_PRICE and many other important Columns.

 

 

PO_DISTRIBUTIONS_ALL

 

This Contains PO distributions Data. It handles the GL Account for the Line and Ship to locations too.

 

po_line_locations_all

This is the PO Lines Tables in Oracle Apps. In This Table We have ITem_Id , Qty , ITem Description ,UOM , UNIT_PRICE and many other important Columns. This table also provide information about total received qty against PO line and Total Invoiced Quantity too.

 

SQL Query To find the PO Lines from the Purchase Order

 

select A2.* from PO_HEADERS_ALL A1,PO_LINES_ALL A2

WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

SQL Query To find the PO Distributions Data from the Purchase Order

 

select A2.* from PO_HEADERS_ALL A1,PO_DISTRIBUTIONS_ALL A2

WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

SQL Query To find the PO Vendor Name from the Purchase Order

 

select A2.* from PO_HEADERS_ALL A1,AP_SUPPLIERS A2

WHERE A1.VENDOR_ID=A2.VENDOR_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

SQL Query To find the PO Vendor SITE from the Purchase Order

 

select A2.* from PO_HEADERS_ALL A1,AP_SUPPLIER_SITES_ALL A2

WHERE A1.VENDOR_SITE_ID=A2.VENDOR_SITE_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

 

SQL Query To find the PO Lines Inventory Items from the Purchase Order

 

select A2.* from PO_HEADERS_ALL A1,PO_LINES_ALL A2,MTL_SYSTEM_ITEMS_B A3 ,PO_DISTRIBUTIONS_ALL A4

WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID

AND A1.PO_HEADER_ID=A4.PO_HEADER_ID

AND A2.PO_LINE_ID=A4.PO_LINE_ID

AND A2.ITEM_ID=A3.INVENTORY_ITEM_ID

AND A3.ORGANIZATION_ID=A4.DESTINATION_ORGANIZATION_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

 

SQL Query To find the PO Buyers from the Purchase Order

 

 

SELECT A2.* FROM  PO_HEADERS_ALL A1,PER_ALL_PEOPLE_F A2

WHERE A1.AGMENT_ID=A2.PERSON_ID

AND A1.SEGMENT1=:PO_NUMBER

AND A1.ORG_ID=:ORG_ID

 

SQL Query To find the PO Receipts from the Purchase Order

 

po receipt tables in oracle apps r12

select a2.* from rcv_shipment_lines a1,rcv_shipment_headers a2 ,PO_HEADERS_ALL A3

where 1=1

and a1.SHIPMENT_HEADER_ID=a2.SHIPMENT_HEADER_ID

and a1.po_header_id=a3.po_header_id

and a3.SEGMENT1=:PO_NUMBER

 

SQL Query To find the PO Matching AP Invoice Numbers from the Purchase Order

 

select a3.* from ap_invoice_lines_all a1,ap_invoices_all a2,PO_HEADERS_ALL A3

where a1.po_header_id=a1.po_header_id

and a1.invoice_id=a2.invoice_id

and a3.SEGMENT1=:PO_NUMBER

 

 PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow