VIEW: APPS.OKL_K_RATE_PARAMS_V

Source

View Text - Preformatted

SELECT ROWID ROW_ID ,khr_id khr_id ,parameter_type_code parameter_type_code ,effective_from_date effective_from_date ,effective_to_date effective_to_date ,interest_index_id interest_index_id ,base_rate base_rate ,interest_start_date interest_start_date ,adder_rate adder_rate ,maximum_rate maximum_rate ,minimum_rate minimum_rate ,principal_basis_code principal_basis_code ,days_in_a_month_code days_in_a_month_code ,days_in_a_year_code days_in_a_year_code ,interest_basis_code interest_basis_code ,rate_delay_code rate_delay_code ,rate_delay_frequency rate_delay_frequency ,compounding_frequency_code compounding_frequency_code ,calculation_formula_id calculation_formula_id ,catchup_basis_code catchup_basis_code ,catchup_start_date catchup_start_date ,catchup_settlement_code catchup_settlement_code ,catchup_frequency_code catchup_frequency_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 ,attribute_category attribute_category ,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_K_RATE_PARAMS KRP

View Text - HTML Formatted

SELECT ROWID ROW_ID
, KHR_ID KHR_ID
, PARAMETER_TYPE_CODE PARAMETER_TYPE_CODE
, EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, INTEREST_INDEX_ID INTEREST_INDEX_ID
, BASE_RATE BASE_RATE
, INTEREST_START_DATE INTEREST_START_DATE
, ADDER_RATE ADDER_RATE
, MAXIMUM_RATE MAXIMUM_RATE
, MINIMUM_RATE MINIMUM_RATE
, PRINCIPAL_BASIS_CODE PRINCIPAL_BASIS_CODE
, DAYS_IN_A_MONTH_CODE DAYS_IN_A_MONTH_CODE
, DAYS_IN_A_YEAR_CODE DAYS_IN_A_YEAR_CODE
, INTEREST_BASIS_CODE INTEREST_BASIS_CODE
, RATE_DELAY_CODE RATE_DELAY_CODE
, RATE_DELAY_FREQUENCY RATE_DELAY_FREQUENCY
, COMPOUNDING_FREQUENCY_CODE COMPOUNDING_FREQUENCY_CODE
, CALCULATION_FORMULA_ID CALCULATION_FORMULA_ID
, CATCHUP_BASIS_CODE CATCHUP_BASIS_CODE
, CATCHUP_START_DATE CATCHUP_START_DATE
, CATCHUP_SETTLEMENT_CODE CATCHUP_SETTLEMENT_CODE
, CATCHUP_FREQUENCY_CODE CATCHUP_FREQUENCY_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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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_K_RATE_PARAMS KRP