I need help getting BPA line item information together with PO and Invoice information
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",