AR_TRX_DISCOUNTS_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

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

Query

SQL_Statement

SELECT 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_ALL 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'