Purchase order query in oracle fusion

Purchase order query in oracle fusion

In this post , We will be discuss about Purchase order query in oracle fusion. This query will help to extract the purchase order details. We will get the complete informations about purchase order using this sql query in oracle fusion. I will share the important tables too used by this purchase order query in oracle fusion. Please find below the detail about Purchase order query in oracle fusion.

 Purchase order query in oracle fusion

4 Important tables used by Purchase order query in oracle fusion

1.PO_HEADERS_ALL
2.PO_LINES_ALL
3. POZ_ALL_CONTACTS_V4. POZ_SUPPLIERS_V5. POZ_SUPPLIER_SITES_ALL_M

Detail Purchase order query in oracle fusion

SELECT PS.VENDOR_NAME,
PS.SEGMENT1 SUPPLIER_NUMBER,
NVL2(PS.TAX_REPORTING_NAME, 'Secure', NULL) TAX_REPORTING_NAME,
pvs.vendor_site_code,
pha.PO_HEADER_ID,
pha.MODE_OF_TRANSPORT,
pha.SERVICE_LEVEL,
pha.DOCUMENT_STATUS,
pha.PRC_BU_ID,
pha.REQ_BU_ID,
pha.AGENT_ID,
pha.TYPE_LOOKUP_CODE,
pha.REVISION_NUM,
pha.REVISED_DATE,
pha.APPROVED_FLAG,
pha.APPROVED_DATE,
pha.AMOUNT_LIMIT,
pha.MIN_RELEASE_AMOUNT,
NVL2(pha.NOTE_TO_AUTHORIZER,'Secure',NULL)NOTE_TO_AUTHORIZER,
NVL2(pha.NOTE_TO_VENDOR,'Secure',NULL)NOTE_TO_VENDOR,
NVL2(pha.NOTE_TO_RECEIVER,'Secure',NULL)NOTE_TO_RECEIVER,
pla.PARENT_ITEM_ID,
pla.SUPPLIER_PARENT_ITEM,
pla.BASE_MODEL_PRICE,
pla.OPTIONS_PRICE,
pla.ITEM_ID,
pla.ITEM_REVISION,
pla.CATEGORY_ID,
pla.ITEM_DESCRIPTION,
pla.UOM_CODE,
pla.QUANTITY_COMMITTED,
pla.COMMITTED_AMOUNT,
pla.LIST_PRICE_PER_UNIT,
pla.UNIT_PRICE,
pla.QUANTITY
FROM PO_HEADERS_ALL pha ,POZ_SUPPLIERS_V PS , poz_supplier_sites_all_m pvs ,PO_LINES_ALL pla
where pha.vendor_id=ps.vendor_id
AND pvs.vendor_id=PS.VENDOR_ID
and pha.po_header_id=pla.po_header_id