Query - Oracle Fusion Procurement – PO & Requisition Extraction for Standard, BPA, CPA

Summary:

Hi

I need to extract Purchase Order (PO) and related Requisition information from Oracle Fusion for the following document types:

• Standard Purchase Orders (Standard PO)
• Blanket Purchase Agreements (BPA)
• Contract Purchase Agreements (CPA)

Header-Level

• PO Number
• Type Lookup Code (Standard / BPA / CPA)
• Req BU ID
• PR Requisition Number
• Currency Code
• Created By (Username)
• Payment Term ID
• Agreement Number (for BPA/CPA)
• Note to Buyer

🔸 Line-Level

• PO Line ID
• Line Type
• Quantity
• Unit Price
• Line Status

🔸 Distribution-Level

• POET / Charge Account
• % Split

If any sample sql then please provide.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):