[Home] [Help]
View: CE_DISC_INVOICES_V
Product: | CE - Cash Management |
Description: | Cash forecasting source - AP invoices based on discounts |
Implementation/DBA Data: |
APPS.CE_DISC_INVOICES_V
|
View Text
SELECT (DECODE(NVL(CFR.DISCOUNT_OPTION
, 'X')
, 'X'
, LEAST(SRC.FIRST_DISCOUNTED_AMT
, /* 1 */ SRC.SECOND_DISCOUNTED_AMT
, SRC.THIRD_DISCOUNTED_AMT)
, GREATEST(SRC.FIRST_DISCOUNTED_AMT
, SRC.SECOND_DISCOUNTED_AMT
, SRC.THIRD_DISCOUNTED_AMT)))
, DECODE(NVL(CFR.DISCOUNT_OPTION
, 'X')
, 'X'
, LEAST(SRC.FIRST_DISC_BASE_AMT
, /* 2 */ SRC.SECOND_DISC_BASE_AMT
, SRC.THIRD_DISC_BASE_AMT)
, GREATEST(SRC.FIRST_DISC_BASE_AMT
, SRC.SECOND_DISC_BASE_AMT
, SRC.THIRD_DISC_BASE_AMT))
, DECODE(NVL(CFR.DISCOUNT_OPTION
, 'X')
, 'X'
, /* 3 */ DECODE(LEAST(SRC.FIRST_DISCOUNTED_AMT
, SRC.SECOND_DISCOUNTED_AMT
, SRC.THIRD_DISCOUNTED_AMT)
, FIRST_DISCOUNTED_AMT
, SRC.FIRST_DISCOUNT_DATE
, SECOND_DISCOUNTED_AMT
, SRC.SECOND_DISCOUNT_DATE
, THIRD_DISCOUNTED_AMT
, SRC.THIRD_DISCOUNT_DATE
, SRC.DUE_DATE)
, DECODE(GREATEST(SRC.FIRST_DISC_BASE_AMT
, SRC.SECOND_DISC_BASE_AMT
, SRC.THIRD_DISC_BASE_AMT)
, FIRST_DISC_BASE_AMT
, SRC.FIRST_DISCOUNT_DATE
, SECOND_DISC_BASE_AMT
, SRC.SECOND_DISCOUNT_DATE
, THIRD_DISC_BASE_AMT
, SRC.THIRD_DISCOUNT_DATE
, SRC.DUE_DATE))
, SRC.CURRENCY_CODE
, /* 4 */ SRC.PAYMENT_PRIORITY
, /* 5 */ SRC.VENDOR_TYPE
, /* 6 */ SRC.PAYGROUP
, /* 7 */ SRC.ORG_ID
, /* 8 */ SRC.PROJECT_ID
, /* 9 */ SRC.ON_HOLD
, /* 10 */ SRC.INVOICE_ID
, /* 11 */ SRC.INVOICE_NUM
, /* 12 */ SRC.PAYMENT_NUM
, /* 13 */ (SRC.INVOICE_ID || 'X' || SRC.PAYMENT_NUM) /* 14 */ FROM CE_AP_FC_DISC_INVOICES_V SRC
, CE_FORECAST_ROWS CFR WHERE CFR.ROWID = CEFC_VIEW_CONST.GET_ROWID
Columns
Name |
AMOUNT |
BASE_AMOUNT |
TRX_DATE |
CURRENCY_CODE |
PAYMENT_PRIORITY |
VENDOR_TYPE |
PAYGROUP |
ORG_ID |
PROJECT_ID |
ON_HOLD |
INVOICE_ID |
INVOICE_NUM |
PAYMENT_NUM |
REFERENCE_ID |