View: CE_DUE_PROJECT_INV_V

Product:	CE - Cash Management
Description:	Forecasting source - AP invoices based on due dates and projects
Implementation/DBA Data:	APPS.CE_DUE_PROJECT_INV_V

View Text

SELECT AID.INVOICE_ID
, CE.PAYMENT_NUM
, (AID.AMOUNT)
, AID.BASE_AMOUNT
, CE.CURRENCY_CODE
, CE.PAYMENT_PRIORITY
, CE.VENDOR_TYPE
, CE.PAYGROUP
, CE.TRX_DATE
, CE.ORG_ID
, AID.PROJECT_ID
, CE.ON_HOLD
, CE.INVOICE_NUM
, CE.REFERENCE_ID FROM CE_AP_FC_DUE_INVOICES_V CE
, AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AID.INVOICE_ID = CE.INVOICE_ID AND AID.PROJECT_ID IS NOT NULL

Columns