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'