eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: XTR.XTR_TERM_ACTIONS#

Source

View Text - Preformatted


select AUDIT_INDICATOR AUDIT_INDICATOR, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, DEAL_NO DEAL_NO, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON, EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE, FIXED_UNTIL FIXED_UNTIL, FROM_START_DATE FROM_START_DATE, INCREASE_EFFECTIVE_FROM_DATE INCREASE_EFFECTIVE_FROM_DATE, MATURITY_DATE MATURITY_DATE, NEW_INTEREST_RATE NEW_INTEREST_RATE, NEW_PI_AMOUNT_DUE NEW_PI_AMOUNT_DUE, NEXT_COUPON_DATE NEXT_COUPON_DATE, PAYMENT_FREQ PAYMENT_FREQ, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE, PRINCIPAL_ACTION PRINCIPAL_ACTION, PRINCIPAL_ADJUST PRINCIPAL_ADJUST, PRINCIPAL_AMOUNT_TYPE PRINCIPAL_AMOUNT_TYPE, MASS_RATE_UPDATE MASS_RATE_UPDATE from "XTR"."XTR_TERM_ACTIONS"

View Text - HTML Formatted

SELECT AUDIT_INDICATOR AUDIT_INDICATOR
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, DEAL_NO DEAL_NO
, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON
, EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, FIXED_UNTIL FIXED_UNTIL
, FROM_START_DATE FROM_START_DATE
, INCREASE_EFFECTIVE_FROM_DATE INCREASE_EFFECTIVE_FROM_DATE
, MATURITY_DATE MATURITY_DATE
, NEW_INTEREST_RATE NEW_INTEREST_RATE
, NEW_PI_AMOUNT_DUE NEW_PI_AMOUNT_DUE
, NEXT_COUPON_DATE NEXT_COUPON_DATE
, PAYMENT_FREQ PAYMENT_FREQ
, PAYMENT_SCHEDULE_CODE PAYMENT_SCHEDULE_CODE
, PRINCIPAL_ACTION PRINCIPAL_ACTION
, PRINCIPAL_ADJUST PRINCIPAL_ADJUST
, PRINCIPAL_AMOUNT_TYPE PRINCIPAL_AMOUNT_TYPE
, MASS_RATE_UPDATE MASS_RATE_UPDATE
FROM "XTR"."XTR_TERM_ACTIONS"