[Home] [Help]
View: XTR_ACCEPTED_BIDS_V
Product: | XTR - Treasury |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
WHERE NVL(MASS_RATE_UPDATE
, 'N') = 'N' UNION ALL SELECT DISTINCT EFFECTIVE_FROM_DATE EFFECTIVE_DATE
, CREATED_ON
, PAYMENT_SCHEDULE_CODE
, 0 DEAL_NO
, 0 PRINCIPAL_ADJUST
, NEW_INTEREST_RATE
, 'RATE' CALL_FROM
FROM XTR_TERM_ACTIONS
WHERE NVL(MASS_RATE_UPDATE
, 'N') = 'Y'
AND NEW_INTEREST_RATE IS NOT NULL
Columns
Name |
EFFECTIVE_DATE |
PAYMENT_SCHEDULE_CODE |
CREATED_ON |
DEAL_NO |
PRINCIPAL_ADJUST |
NEW_INTEREST_RATE |
CALL_FROM |