VIEW: APPS.AR_TRX_DISCOUNTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'