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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_TRX_REQUESTS

Object Details

Object Name:	OKL_TRX_REQUESTS
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TRX_REQUESTS
Subobject Name:
Status:	VALID

Stores transaction-level request information. Records in this table either represent Contract-level requests or Asset-level requests.
In the case of Contract-level requests, this table acts as an extension to the OKL_TRX_CONTRACTS table. In the case of Asset-level requests this table acts as an extension to the OKL_TXR_ASSETS table.
The parent table of a record is indicated by value in the JTOT_OBJECT1_CODE column.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRQ_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_NUMBER
OKL_TRX_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TRQ_REQUEST_TYPE_IDX	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_TYPE_CODE
OKL_TRQ_REQ_STATUS_IDX	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
OBJECT1_ID1	VARCHAR2	(40)		Object1_id1
OBJECT1_ID2	VARCHAR2	(200)		Object1_id2
JTOT_OBJECT1_CODE	VARCHAR2	(30)		jtot object code
DNZ_KHR_ID	NUMBER			Denormalized contract id for performance reason
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Request type code
APPLY_TO_CODE	VARCHAR2	(30)		Apply to code
START_DATE	DATE			Start date
END_DATE	DATE			End date
TERM_DURATION	NUMBER	(10)		Term Duration
AMOUNT	NUMBER	(14)		Amount
CURRENCY_CODE	VARCHAR2	(15)		Currency code
SUBSIDY_YN	VARCHAR2	(3)		Subsidy Y/N
CASH_APPLIED_YN	VARCHAR2	(3)		Cash Applied Y/N
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column
ORG_ID	NUMBER	(15)		Operating unit identifier
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
MINIMUM_RATE	NUMBER			Minimum rate
MAXIMUM_RATE	NUMBER			Maximum rate
TOLERANCE	NUMBER			Tolerance
ADJUSTMENT_FREQUENCY_CODE	VARCHAR2	(30)		Adjustment frequency code
BASE_RATE	NUMBER			Base rate
INDEX_NAME	VARCHAR2	(30)		Index name
VARIABLE_METHOD_CODE	VARCHAR2	(30)		Variable method
ADDER	NUMBER			Adder
DAYS_IN_YEAR	VARCHAR2	(30)		Days in year
DAYS_IN_MONTH	VARCHAR2	(30)		Days in month
INTEREST_METHOD_CODE	VARCHAR2	(30)		Interest method
INTEREST_START_DATE	DATE			Interest start date
METHOD_OF_CALCULATION_CODE	VARCHAR2	(30)		Method of calculation
REQUEST_NUMBER	VARCHAR2	(30)		Request number
DATE_OF_CONVERSION	DATE			Date of conversion
VARIABLE_RATE_YN	VARCHAR2	(3)		Variable rate y/n
REQUEST_STATUS_CODE	VARCHAR2	(30)	Yes	Request status
YIELD	NUMBER			Yield
RESIDUAL	NUMBER	(14)		Residual
COMMENTS	VARCHAR2	(1995)		User entered comments
PAYMENT_FREQUENCY_CODE	VARCHAR2	(30)		Used by Collections when restructuring deliquent contracts
RESTRUCTURE_DATE	DATE			Used by Collections when restructuring deliquent contracts
PAST_DUE_YN	VARCHAR2	(3)		Past due y/n
REQUEST_REASON_CODE	VARCHAR2	(30)		Request reason
PARENT_KHR_ID	NUMBER			Parent Contract Identifier
YIELD_TYPE	VARCHAR2	(30)		Yield Type
PAYMENT_AMOUNT	NUMBER	(17)		Payment Amount
PAYMENT_DATE	DATE			Payment Date
PAYDOWN_TYPE	VARCHAR2	(30)		Paydown Type
CURRENCY_CONVERSION_RATE	NUMBER			Column for multicurrency
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Column for multicurrency
CURRENCY_CONVERSION_DATE	DATE			Column for multicurrency
CHR_ID	NUMBER			Contract identifier
LSM_ID	NUMBER			Foreign key to okl_cnsld_ar_strms_b
RECEIPT_ID	NUMBER			Receipt Id
TCN_ID	NUMBER			Foreign Key to OKL_TRX_CONTRACTS
TRY_ID	NUMBER			Foreign Key to OKL_TRX_TYPES_B
CUR_PRINCIPAL_BALANCE	NUMBER	(14)		Current Principal Balance
CUR_ACCUM_INTEREST	NUMBER	(14)		Current Accumulated Interest
LEGAL_ENTITY_ID	NUMBER			Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      OBJECT1_ID1
,      OBJECT1_ID2
,      JTOT_OBJECT1_CODE
,      DNZ_KHR_ID
,      REQUEST_TYPE_CODE
,      APPLY_TO_CODE
,      START_DATE
,      END_DATE
,      TERM_DURATION
,      AMOUNT
,      CURRENCY_CODE
,      SUBSIDY_YN
,      CASH_APPLIED_YN
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MINIMUM_RATE
,      MAXIMUM_RATE
,      TOLERANCE
,      ADJUSTMENT_FREQUENCY_CODE
,      BASE_RATE
,      INDEX_NAME
,      VARIABLE_METHOD_CODE
,      ADDER
,      DAYS_IN_YEAR
,      DAYS_IN_MONTH
,      INTEREST_METHOD_CODE
,      INTEREST_START_DATE
,      METHOD_OF_CALCULATION_CODE
,      REQUEST_NUMBER
,      DATE_OF_CONVERSION
,      VARIABLE_RATE_YN
,      REQUEST_STATUS_CODE
,      YIELD
,      RESIDUAL
,      COMMENTS
,      PAYMENT_FREQUENCY_CODE
,      RESTRUCTURE_DATE
,      PAST_DUE_YN
,      REQUEST_REASON_CODE
,      PARENT_KHR_ID
,      YIELD_TYPE
,      PAYMENT_AMOUNT
,      PAYMENT_DATE
,      PAYDOWN_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CHR_ID
,      LSM_ID
,      RECEIPT_ID
,      TCN_ID
,      TRY_ID
,      CUR_PRINCIPAL_BALANCE
,      CUR_ACCUM_INTEREST
,      LEGAL_ENTITY_ID
FROM OKL.OKL_TRX_REQUESTS;

Dependencies

[top of page]

OKL.OKL_TRX_REQUESTS does not reference any database object

OKL.OKL_TRX_REQUESTS is referenced by following:

APPS: OKL_TRX_REQUESTS