PO Base Tables In Oracle Apps. Purchase Order Tables Information's in Oracle r12.

PO Base Tables In Oracle Apps. Purchase Order Tables Informations in Oracle r12.

po_headers_all

 

This is the Purchase Order Headers Table in Oracle Apps. po_headers_all table columns information's.

 

This table have information's like PO Number, PO Type , Vendor Id ,Vendor Site ID, Currency ,PO Status.

 

 

PO_LINES_ALL. po_lines_all table description information

 

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.

 

 

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

 

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. Purchase Order Tables Information's in Oracle r12.