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
