VIEW: APPS.CE_DISC_INVOICES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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