View: AR_XML_PAYMENT_TERMS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_PAYMENT_TERMS_V

View Text

SELECT T.NAME TERM_NAME
, T.DESCRIPTION TERM_DESCRIPTION
, T.START_DATE_ACTIVE TERM_START_DATE_EFFECTIVE
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.DUE_DATE DUE_DATE
, PS.AMOUNT_DUE_REMAINING DUE_AMOUNT
, DISC.DISCOUNT_DATE DISCOUNT_DATE
, ARPCURR.CURRROUND( DISC.DISCOUNT_PERCENT/100* PS.AMOUNT_DUE_REMAINING
, DISC.CURRENCY) DISCOUNT_AMOUNT
, AR_XML_VIEW_FUNCTIONS.PT_FUNCTION1(PS.CUSTOMER_TRX_ID
, T.TERM_ID
, PS.PAYMENT_SCHEDULE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.PT_FUNCTION2(PS.CUSTOMER_TRX_ID
, T.TERM_ID
, PS.PAYMENT_SCHEDULE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.PT_FUNCTION3(PS.CUSTOMER_TRX_ID
, T.TERM_ID
, PS.PAYMENT_SCHEDULE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.PT_FUNCTION4(PS.CUSTOMER_TRX_ID
, T.TERM_ID
, PS.PAYMENT_SCHEDULE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.PT_FUNCTION5(PS.CUSTOMER_TRX_ID
, T.TERM_ID
, PS.PAYMENT_SCHEDULE_ID) USER5 FROM AR_PAYMENT_SCHEDULES PS
, RA_TERMS T
, AR_TRX_DISCOUNTS_V DISC
WHERE T.TERM_ID = PS.TERM_ID
AND PS.PAYMENT_SCHEDULE_ID = DISC.PAYMENT_SCHEDULE_ID(+)

Columns