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