Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Stores transaction-level request information. Records in this table either represent Contract-level requests or Asset-level requests. |
Implementation/DBA Data: | Not implemented in this database |
SELECT TRQ.ROWID ROW_ID
, TRQ.ID ID
, TRQ.OBJECT1_ID1 OBJECT1_ID1
, TRQ.OBJECT1_ID2 OBJECT1_ID2
, TRQ.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, TRQ.DNZ_KHR_ID DNZ_KHR_ID
, TRQ.REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, TRQ.APPLY_TO_CODE APPLY_TO_CODE
, TRQ.START_DATE START_DATE
, TRQ.END_DATE END_DATE
, TRQ.TERM_DURATION TERM_DURATION
, TRQ.AMOUNT AMOUNT
, TRQ.PAYMENT_AMOUNT
, TRQ.PAYMENT_DATE
, TRQ.PAYDOWN_TYPE
, TRQ.CURRENCY_CODE CURRENCY_CODE
, TRQ.CURRENCY_CONVERSION_RATE
, TRQ.CURRENCY_CONVERSION_TYPE
, TRQ.CURRENCY_CONVERSION_DATE
, TRQ.SUBSIDY_YN SUBSIDY_YN
, TRQ.CASH_APPLIED_YN CASH_APPLIED_YN
, TRQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRQ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TRQ.ATTRIBUTE1 ATTRIBUTE1
, TRQ.ATTRIBUTE2 ATTRIBUTE2
, TRQ.ATTRIBUTE3 ATTRIBUTE3
, TRQ.ATTRIBUTE4 ATTRIBUTE4
, TRQ.ATTRIBUTE5 ATTRIBUTE5
, TRQ.ATTRIBUTE6 ATTRIBUTE6
, TRQ.ATTRIBUTE7 ATTRIBUTE7
, TRQ.ATTRIBUTE8 ATTRIBUTE8
, TRQ.ATTRIBUTE9 ATTRIBUTE9
, TRQ.ATTRIBUTE10 ATTRIBUTE10
, TRQ.ATTRIBUTE11 ATTRIBUTE11
, TRQ.ATTRIBUTE12 ATTRIBUTE12
, TRQ.ATTRIBUTE13 ATTRIBUTE13
, TRQ.ATTRIBUTE14 ATTRIBUTE14
, TRQ.ATTRIBUTE15 ATTRIBUTE15
, TRQ.ORG_ID ORG_ID
, TRQ.REQUEST_ID REQUEST_ID
, TRQ.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TRQ.PROGRAM_ID PROGRAM_ID
, TRQ.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TRQ.CREATED_BY CREATED_BY
, TRQ.CREATION_DATE CREATION_DATE
, TRQ.LAST_UPDATED_BY LAST_UPDATED_BY
, TRQ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRQ.MINIMUM_RATE MINIMUM_RATE
, TRQ.MAXIMUM_RATE MAXIMUM_RATE
, TRQ.TOLERANCE TOLERANCE
, TRQ.ADJUSTMENT_FREQUENCY_CODE ADJUSTMENT_FREQUENCY_CODE
, TRQ.BASE_RATE BASE_RATE
, TRQ.INDEX_NAME INDEX_NAME
, TRQ.VARIABLE_METHOD_CODE VARIABLE_METHOD_CODE
, TRQ.ADDER ADDER
, TRQ.DAYS_IN_YEAR DAYS_IN_YEAR
, TRQ.DAYS_IN_MONTH DAYS_IN_MONTH
, TRQ.INTEREST_METHOD_CODE INTEREST_METHOD_CODE
, TRQ.INTEREST_START_DATE INTEREST_START_DATE
, TRQ.METHOD_OF_CALCULATION_CODE METHOD_OF_CALCULATION_CODE
, TRQ.REQUEST_NUMBER REQUEST_NUMBER
, TRQ.DATE_OF_CONVERSION DATE_OF_CONVERSION
, TRQ.VARIABLE_RATE_YN VARIABLE_RATE_YN
, TRQ.REQUEST_STATUS_CODE REQUEST_STATUS_CODE
, TRQ.YIELD YIELD
, TRQ.RESIDUAL RESIDUAL
, TRQ.COMMENTS COMMENTS
, TRQ.PAYMENT_FREQUENCY_CODE PAYMENT_FREQUENCY_CODE
, TRQ.RESTRUCTURE_DATE RESTRUCTURE_DATE
, TRQ.PAST_DUE_YN PAST_DUE_YN
, TRQ.REQUEST_REASON_CODE REQUEST_REASON_CODE
, TRQ.PARENT_KHR_ID PARENT_KHR_ID
, TRQ.YIELD_TYPE YIELD_TYPE
FROM OKL_TRX_REQUESTS TRQ