[Home] [Help]
View: AR_TRX_DISCOUNTS_V
View Text
SELECT /* PURPOSE: THIS VIEW IS USED TO GET DISCOUNT INFORMATION FOR LOV */ /* IN APPLICATIONS WINDOW */ PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.TRX_NUMBER TRX_NUMBER
, TLD.DISCOUNT_PERCENT DISCOUNT_PERCENT
, TRUNC(DECODE(TLD.DISCOUNT_DAYS
, NULL
, NVL(TLD.DISCOUNT_DATE
, DECODE ( LEAST(TO_NUMBER(TO_CHAR(PS.TRX_DATE
, 'DD'))
, NVL(T.DUE_CUTOFF_DAY
, 32))
, T.DUE_CUTOFF_DAY
, LAST_DAY( ADD_MONTHS(PS.TRX_DATE
, TLD.DISCOUNT_MONTHS_FORWARD) ) + LEAST(TLD.DISCOUNT_DAY_OF_MONTH
, TO_NUMBER(TO_CHAR(LAST_DAY(ADD_MONTHS(PS.TRX_DATE
, TLD.DISCOUNT_MONTHS_FORWARD+1))
, 'DD')))
, LAST_DAY(ADD_MONTHS(PS.TRX_DATE
, TLD.DISCOUNT_MONTHS_FORWARD-1)) + LEAST(TLD.DISCOUNT_DAY_OF_MONTH
, TO_NUMBER(TO_CHAR(LAST_DAY( ADD_MONTHS(PS.TRX_DATE
, TLD.DISCOUNT_MONTHS_FORWARD))
, 'DD'))) ) )
, PS.TRX_DATE + TLD.DISCOUNT_DAYS)) DISCOUNT_DATE
, T.CALC_DISCOUNT_ON_LINES_FLAG CALC_DISCOUNT_ON_LINES_FLAG
, T.PARTIAL_DISCOUNT_FLAG PARTIAL_DISCOUNT_FLAG
, PS.AMOUNT_DUE_REMAINING
, PS.INVOICE_CURRENCY_CODE
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
FROM RA_TERMS_LINES_DISCOUNTS TLD
, RA_TERMS T
, AR_PAYMENT_SCHEDULES PS
WHERE T.TERM_ID = TLD.TERM_ID
AND PS.TERM_ID = T.TERM_ID
AND PS.TERMS_SEQUENCE_NUMBER = TLD.SEQUENCE_NUM
AND PS.CLASS <> 'PMT'
AND PS.CLASS <> 'GUAR'
Columns
Name |
PAYMENT_SCHEDULE_ID |
CUSTOMER_TRX_ID |
TRX_NUMBER |
DISCOUNT_PERCENT |
DISCOUNT_DATE |
CALC_DISCOUNT_ON_LINES_FLAG |
PARTIAL_DISCOUNT_FLAG |
AMOUNT_DUE_REMAINING |
CURRENCY |
CUSTOMER_ID |
CUSTOMER_SITE_USE_ID |