View: CE_DISC_PROJECT_INV_V

Product:	CE - Cash Management
Description:	Cash forecasting source - AP invoices based on discounts and projects
Implementation/DBA Data:	APPS.CE_DISC_PROJECT_INV_V

View Text

SELECT -(CE.AMOUNT * (AID.AMOUNT / AI.INVOICE_AMOUNT))
, CE.BASE_AMOUNT * (AID.AMOUNT / AI.INVOICE_AMOUNT)
, CE.TRX_DATE
, CE.CURRENCY_CODE
, CE.PAYMENT_PRIORITY
, CE.VENDOR_TYPE
, CE.PAYGROUP
, CE.ORG_ID
, AID.PROJECT_ID
, CE.ON_HOLD
, CE.INVOICE_NUM
, CE.PAYMENT_NUM
, CE.REFERENCE_ID
FROM CE_DISC_INVOICES_V CE
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_INVOICES_ALL AI
WHERE AID.INVOICE_ID = CE.INVOICE_ID
AND AI.INVOICE_ID = CE.INVOICE_ID
AND AID.PROJECT_ID IS NOT NULL

Columns