Procurement - EBS (MOSC)

MOSC Banner

I need help getting BPA line item information together with PO and Invoice information

in Procurement - EBS (MOSC) 3 commentsAnswered ✓

I started working on writing query to fetch the data for invoice holds. But I need help adding BPA data such as

Here is my script:

Select


AP_INVOICES_ALL.CREATION_DATE as "Creation_Date",

AP_INVOICES_ALL.INVOICE_NUM as "Invoice_Number",

AP_INVOICES_ALL.ATTRIBUTE1 as "Hold_Assigned_To",

AP_INVOICES_ALL.ATTRIBUTE2 as "Hold_Action_Needed",

AP_INVOICES_ALL.VENDOR_ID,

AP_INVOICES_ALL.VENDOR_SITE_ID,

AP_INVOICE_LINES_ALL.LINE_NUMBER as "Invoice_Line_Number",

AP_INVOICE_LINES_ALL.DESCRIPTION as "Description",

AP_INVOICE_LINES_ALL.QUANTITY_INVOICED as "Invoice_Quantity",

AP_INVOICE_LINES_ALL.UNIT_PRICE as "Invoice_Unit_Price",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center