View: XTR_TERM_ACTION_REQUESTS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_TERM_ACTION_REQUESTS_V

View Text

SELECT NVL(INCREASE_EFFECTIVE_FROM_DATE
, NVL(FROM_START_DATE
, EFFECTIVE_FROM_DATE))
, CREATED_ON
, PAYMENT_SCHEDULE_CODE
, DEAL_NO
, PRINCIPAL_ADJUST
, NEW_INTEREST_RATE
, 'RETAIL'
FROM XTR_TERM_ACTIONS UNION ALL SELECT DISTINCT EFFECTIVE_FROM_DATE
, CREATED_ON
, PAYMENT_SCHEDULE_CODE
, 0
, 0
, NEW_INTEREST_RATE
, 'RATE'
FROM XTR_TERM_ACTIONS
WHERE NVL(MASS_RATE_UPDATE
, 'N') = 'Y'
AND NEW_INTEREST_RATE IS NOT NULL

Columns