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: OKL.OKL_CONVERT_INT_RATE_REQUEST#

Source

View Text - Preformatted


select TRQ_ID TRQ_ID, KHR_ID KHR_ID, PARAMETER_TYPE_CODE PARAMETER_TYPE_CODE, EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE, EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE, MINIMUM_RATE MINIMUM_RATE, MAXIMUM_RATE MAXIMUM_RATE, BASE_RATE BASE_RATE, INTEREST_INDEX_ID INTEREST_INDEX_ID, ADDER_RATE ADDER_RATE, DAYS_IN_A_YEAR_CODE DAYS_IN_A_YEAR_CODE, DAYS_IN_A_MONTH_CODE DAYS_IN_A_MONTH_CODE, PROPOSED_EFFECTIVE_DATE PROPOSED_EFFECTIVE_DATE, CONVERSION_DATE CONVERSION_DATE, VARIABLE_RATE_YN VARIABLE_RATE_YN, PRINCIPAL_BASIS_CODE PRINCIPAL_BASIS_CODE, INTEREST_BASIS_CODE INTEREST_BASIS_CODE, RATE_DELAY_CODE RATE_DELAY_CODE, RATE_DELAY_FREQUENCY RATE_DELAY_FREQUENCY, COMPOUND_FREQUENCY_CODE COMPOUND_FREQUENCY_CODE, CALCULATION_FORMULA_NAME CALCULATION_FORMULA_NAME, CATCHUP_START_DATE CATCHUP_START_DATE, CATCHUP_SETTLEMENT_CODE CATCHUP_SETTLEMENT_CODE, CATCHUP_BASIS_CODE CATCHUP_BASIS_CODE, RATE_CHANGE_START_DATE RATE_CHANGE_START_DATE, RATE_CHANGE_FREQUENCY_CODE RATE_CHANGE_FREQUENCY_CODE, RATE_CHANGE_VALUE RATE_CHANGE_VALUE, CONVERSION_OPTION_CODE CONVERSION_OPTION_CODE, NEXT_CONVERSION_DATE NEXT_CONVERSION_DATE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "OKL"."OKL_CONVERT_INT_RATE_REQUEST"

View Text - HTML Formatted

SELECT TRQ_ID TRQ_ID
, KHR_ID KHR_ID
, PARAMETER_TYPE_CODE PARAMETER_TYPE_CODE
, EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, MINIMUM_RATE MINIMUM_RATE
, MAXIMUM_RATE MAXIMUM_RATE
, BASE_RATE BASE_RATE
, INTEREST_INDEX_ID INTEREST_INDEX_ID
, ADDER_RATE ADDER_RATE
, DAYS_IN_A_YEAR_CODE DAYS_IN_A_YEAR_CODE
, DAYS_IN_A_MONTH_CODE DAYS_IN_A_MONTH_CODE
, PROPOSED_EFFECTIVE_DATE PROPOSED_EFFECTIVE_DATE
, CONVERSION_DATE CONVERSION_DATE
, VARIABLE_RATE_YN VARIABLE_RATE_YN
, PRINCIPAL_BASIS_CODE PRINCIPAL_BASIS_CODE
, INTEREST_BASIS_CODE INTEREST_BASIS_CODE
, RATE_DELAY_CODE RATE_DELAY_CODE
, RATE_DELAY_FREQUENCY RATE_DELAY_FREQUENCY
, COMPOUND_FREQUENCY_CODE COMPOUND_FREQUENCY_CODE
, CALCULATION_FORMULA_NAME CALCULATION_FORMULA_NAME
, CATCHUP_START_DATE CATCHUP_START_DATE
, CATCHUP_SETTLEMENT_CODE CATCHUP_SETTLEMENT_CODE
, CATCHUP_BASIS_CODE CATCHUP_BASIS_CODE
, RATE_CHANGE_START_DATE RATE_CHANGE_START_DATE
, RATE_CHANGE_FREQUENCY_CODE RATE_CHANGE_FREQUENCY_CODE
, RATE_CHANGE_VALUE RATE_CHANGE_VALUE
, CONVERSION_OPTION_CODE CONVERSION_OPTION_CODE
, NEXT_CONVERSION_DATE NEXT_CONVERSION_DATE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "OKL"."OKL_CONVERT_INT_RATE_REQUEST"