VIEW: OKL.OKL_TRX_REQUESTS#

Source

View Text - Preformatted

select ID ID, OBJECT1_ID1 OBJECT1_ID1, OBJECT1_ID2 OBJECT1_ID2, JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE, DNZ_KHR_ID DNZ_KHR_ID, REQUEST_TYPE_CODE REQUEST_TYPE_CODE, APPLY_TO_CODE APPLY_TO_CODE, START_DATE START_DATE, END_DATE END_DATE, TERM_DURATION TERM_DURATION, AMOUNT AMOUNT, CURRENCY_CODE CURRENCY_CODE, SUBSIDY_YN SUBSIDY_YN, CASH_APPLIED_YN CASH_APPLIED_YN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, ORG_ID ORG_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, MINIMUM_RATE MINIMUM_RATE, MAXIMUM_RATE MAXIMUM_RATE, TOLERANCE TOLERANCE, ADJUSTMENT_FREQUENCY_CODE ADJUSTMENT_FREQUENCY_CODE, BASE_RATE BASE_RATE, INDEX_NAME INDEX_NAME, VARIABLE_METHOD_CODE VARIABLE_METHOD_CODE, ADDER ADDER, DAYS_IN_YEAR DAYS_IN_YEAR, DAYS_IN_MONTH DAYS_IN_MONTH, INTEREST_METHOD_CODE INTEREST_METHOD_CODE, INTEREST_START_DATE INTEREST_START_DATE, METHOD_OF_CALCULATION_CODE METHOD_OF_CALCULATION_CODE, REQUEST_NUMBER REQUEST_NUMBER, DATE_OF_CONVERSION DATE_OF_CONVERSION, VARIABLE_RATE_YN VARIABLE_RATE_YN, REQUEST_STATUS_CODE REQUEST_STATUS_CODE, YIELD YIELD, RESIDUAL RESIDUAL, COMMENTS COMMENTS, PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE, RESTRUCTURE_DATE RESTRUCTURE_DATE, PAST_DUE_YN PAST_DUE_YN, REQUEST_REASON_CODE REQUEST_REASON_CODE, PARENT_KHR_ID PARENT_KHR_ID, YIELD_TYPE YIELD_TYPE, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYMENT_DATE PAYMENT_DATE, PAYDOWN_TYPE PAYDOWN_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CHR_ID CHR_ID, LSM_ID LSM_ID, RECEIPT_ID RECEIPT_ID, TCN_ID TCN_ID, TRY_ID TRY_ID, CUR_PRINCIPAL_BALANCE CUR_PRINCIPAL_BALANCE, CUR_ACCUM_INTEREST CUR_ACCUM_INTEREST, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "OKL"."OKL_TRX_REQUESTS"

View Text - HTML Formatted

SELECT ID ID
, OBJECT1_ID1 OBJECT1_ID1
, OBJECT1_ID2 OBJECT1_ID2
, JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, DNZ_KHR_ID DNZ_KHR_ID
, REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, APPLY_TO_CODE APPLY_TO_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, TERM_DURATION TERM_DURATION
, AMOUNT AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, SUBSIDY_YN SUBSIDY_YN
, CASH_APPLIED_YN CASH_APPLIED_YN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, ORG_ID ORG_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, MINIMUM_RATE MINIMUM_RATE
, MAXIMUM_RATE MAXIMUM_RATE
, TOLERANCE TOLERANCE
, ADJUSTMENT_FREQUENCY_CODE ADJUSTMENT_FREQUENCY_CODE
, BASE_RATE BASE_RATE
, INDEX_NAME INDEX_NAME
, VARIABLE_METHOD_CODE VARIABLE_METHOD_CODE
, ADDER ADDER
, DAYS_IN_YEAR DAYS_IN_YEAR
, DAYS_IN_MONTH DAYS_IN_MONTH
, INTEREST_METHOD_CODE INTEREST_METHOD_CODE
, INTEREST_START_DATE INTEREST_START_DATE
, METHOD_OF_CALCULATION_CODE METHOD_OF_CALCULATION_CODE
, REQUEST_NUMBER REQUEST_NUMBER
, DATE_OF_CONVERSION DATE_OF_CONVERSION
, VARIABLE_RATE_YN VARIABLE_RATE_YN
, REQUEST_STATUS_CODE REQUEST_STATUS_CODE
, YIELD YIELD
, RESIDUAL RESIDUAL
, COMMENTS COMMENTS
, PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE
, RESTRUCTURE_DATE RESTRUCTURE_DATE
, PAST_DUE_YN PAST_DUE_YN
, REQUEST_REASON_CODE REQUEST_REASON_CODE
, PARENT_KHR_ID PARENT_KHR_ID
, YIELD_TYPE YIELD_TYPE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_DATE PAYMENT_DATE
, PAYDOWN_TYPE PAYDOWN_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CHR_ID CHR_ID
, LSM_ID LSM_ID
, RECEIPT_ID RECEIPT_ID
, TCN_ID TCN_ID
, TRY_ID TRY_ID
, CUR_PRINCIPAL_BALANCE CUR_PRINCIPAL_BALANCE
, CUR_ACCUM_INTEREST CUR_ACCUM_INTEREST
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "OKL"."OKL_TRX_REQUESTS"