[Home] [Help]
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
Name |
INVOICE_ID |
PAYMENT_NUM |
AMOUNT |
BASE_AMOUNT |
CURRENCY_CODE |
PAYMENT_PRIORITY |
VENDOR_TYPE |
PAYGROUP |
TRX_DATE |
ORG_ID |
PROJECT_ID |
ON_HOLD |
INVOICE_NUM |
REFERENCE_ID |