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_K_HEADERS

Object Details

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

OKL_K_HEADERS contains lease contract specific header information for all the lease contracts. It covers additional attributes which are not there in contracts core header. Following types of lease contract documents use OKL_K_HEADERS :
* Lease Contract
* Master Lease Agreement
* Operating Agreement
* Program Agreement
* Lease Quote
* Syndication Agreement
* Contract and Agreement templates
Primary key column ID has a foreign key relation to OKC_K_HEADERS_B.ID. This links the Lease contract specific header information to the contracts core header.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_K_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_K_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CRS_ID
OKL_K_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMD_CODE
OKL_K_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ISG_ID
OKL_K_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
OKL_K_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PDT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
ISG_ID	NUMBER			Unique identifier for sales region
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
PDT_ID	NUMBER			Foreign key to table OKL_PRODUCTS
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
DATE_FIRST_ACTIVITY	DATE			Date of first activity on the contract
SYNDICATABLE_YN	VARCHAR2	(3)		Indicates whether the contract is eligible for syndication or not
SALESTYPE_YN	VARCHAR2	(3)		Indicates whether it is a sales type contract or not
DATE_REFINANCED	DATE			The date finance closed if this was a rollover, restructure, renew or refinance contract
DATE_CONVERSION_EFFECTIVE	DATE			Date on which the deal conversion becomes active
DATE_DEAL_TRANSFERRED	DATE			Date on which the deal was transferred from one lessee to another
TERM_DURATION	NUMBER	(10)		The duration of the contract in months
DATETIME_PROPOSAL_EFFECTIVE	DATE			Date on which the proposal becomes effective
DATETIME_PROPOSAL_INEFFECTIVE	DATE			Date on which the proposal becomes ineffective
DATE_PROPOSAL_ACCEPTED	DATE			Date on which notification of acceptance of the proposal was received
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
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
AMD_CODE	VARCHAR2	(30)		Acceptance method code. This is a foreign key to FND_LOOKUP code 'OKL_ACCEPTANCE_METHOD'.
GENERATE_ACCRUAL_YN	VARCHAR2	(3)		Indicates whether to generate accrual or not
GENERATE_ACCRUAL_OVERRIDE_YN	VARCHAR2	(3)		Indicates whether to override generation of accrual or not
CREDIT_ACT_YN	VARCHAR2	(3)		Indicates whether contract is consumer credit act deal or not
CONVERTED_ACCOUNT_YN	VARCHAR2	(3)		Indicates whether the contract account is a converted account or not
PRE_TAX_YIELD	NUMBER			Yield before tax
AFTER_TAX_YIELD	NUMBER			Yield after tax
IMPLICIT_INTEREST_RATE	NUMBER			Implicit interest rate
IMPLICIT_NON_IDC_INTEREST_RATE	NUMBER			Implicit non-IDC interest rate
TARGET_PRE_TAX_YIELD	NUMBER			Target pre tax yield
TARGET_AFTER_TAX_YIELD	NUMBER			Target after tax yield
TARGET_IMPLICIT_INTEREST_RATE	NUMBER			Target implicit interest rate
TARGET_IMPLICIT_NONIDC_INTRATE	NUMBER			Target implicit non-IDC interest rate
DATE_LAST_INTERIM_INTEREST_CAL	DATE			Last Interim interest calculation date
DEAL_TYPE	VARCHAR2	(30)		Book Classification of the contract
PRE_TAX_IRR	NUMBER			Pre tax IRR for the contract
AFTER_TAX_IRR	NUMBER			After tax IRR for the contract
EXPECTED_DELIVERY_DATE	DATE			Earliest date by which a line (financial asset) under this contract will be delivered to the lessee
ACCEPTED_DATE	DATE			Earliest date by which all the lines on the contract will be accepted
PREFUNDING_ELIGIBLE_YN	VARCHAR2	(3)		Indicates whether the contract is eligible for pre-funding or not
REVOLVING_CREDIT_YN	VARCHAR2	(3)		Indicates whether the contract is eligible for a revolving line of credit or not
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
MULTI_GAAP_YN	VARCHAR2	(3)		Indicates whether contract is eligible for Multi-GAAP accounting.
RECOURSE_CODE	VARCHAR2	(30)		Recource Code
LESSOR_SERV_ORG_CODE	VARCHAR2	(30)		Lessor service organization code
ASSIGNABLE_YN	VARCHAR2	(3)		Indicates whether the lease contract can e assigned to an investor agreement
SECURITIZED_CODE	VARCHAR2	(30)		Securitized code
SECURITIZATION_TYPE	VARCHAR2	(30)		Type of securitization
SUB_PRE_TAX_YIELD	NUMBER			Subsidized pre-tax yield
SUB_AFTER_TAX_YIELD	NUMBER			Subsidized after tax yield
SUB_IMPL_INTEREST_RATE	NUMBER			Subsidized implicit interest rate
SUB_IMPL_NON_IDC_INT_RATE	NUMBER			Subsidized non IDC implicit interest rate
SUB_PRE_TAX_IRR	NUMBER			subsidized pre-tax IRR
SUB_AFTER_TAX_IRR	NUMBER			Subsidized after tax IRR
TOT_CL_TRANSFER_AMT	NUMBER			Total creditline transfer amount
TOT_CL_NET_TRANSFER_AMT	NUMBER			Total creditline net transfer amount
TOT_CL_LIMIT	NUMBER			Total creditline limit
TOT_CL_FUNDING_AMT	NUMBER			Total creditline funding amount
CRS_ID	NUMBER			Change request identifier
TEMPLATE_TYPE_CODE	VARCHAR2	(30)		Template type code
TRADEIN_DESCRIPTION	VARCHAR2	(1995)		Description of trade in.
TRADEIN_AMOUNT	NUMBER			Tradein amount
DATE_TRADEIN	DATE			Date on which tradein amount is applied
DATE_FUNDING_EXPECTED	DATE			Date on which funding is expected for a lease contract
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
,      ISG_ID
,      KHR_ID
,      PDT_ID
,      OBJECT_VERSION_NUMBER
,      DATE_FIRST_ACTIVITY
,      SYNDICATABLE_YN
,      SALESTYPE_YN
,      DATE_REFINANCED
,      DATE_CONVERSION_EFFECTIVE
,      DATE_DEAL_TRANSFERRED
,      TERM_DURATION
,      DATETIME_PROPOSAL_EFFECTIVE
,      DATETIME_PROPOSAL_INEFFECTIVE
,      DATE_PROPOSAL_ACCEPTED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AMD_CODE
,      GENERATE_ACCRUAL_YN
,      GENERATE_ACCRUAL_OVERRIDE_YN
,      CREDIT_ACT_YN
,      CONVERTED_ACCOUNT_YN
,      PRE_TAX_YIELD
,      AFTER_TAX_YIELD
,      IMPLICIT_INTEREST_RATE
,      IMPLICIT_NON_IDC_INTEREST_RATE
,      TARGET_PRE_TAX_YIELD
,      TARGET_AFTER_TAX_YIELD
,      TARGET_IMPLICIT_INTEREST_RATE
,      TARGET_IMPLICIT_NONIDC_INTRATE
,      DATE_LAST_INTERIM_INTEREST_CAL
,      DEAL_TYPE
,      PRE_TAX_IRR
,      AFTER_TAX_IRR
,      EXPECTED_DELIVERY_DATE
,      ACCEPTED_DATE
,      PREFUNDING_ELIGIBLE_YN
,      REVOLVING_CREDIT_YN
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      MULTI_GAAP_YN
,      RECOURSE_CODE
,      LESSOR_SERV_ORG_CODE
,      ASSIGNABLE_YN
,      SECURITIZED_CODE
,      SECURITIZATION_TYPE
,      SUB_PRE_TAX_YIELD
,      SUB_AFTER_TAX_YIELD
,      SUB_IMPL_INTEREST_RATE
,      SUB_IMPL_NON_IDC_INT_RATE
,      SUB_PRE_TAX_IRR
,      SUB_AFTER_TAX_IRR
,      TOT_CL_TRANSFER_AMT
,      TOT_CL_NET_TRANSFER_AMT
,      TOT_CL_LIMIT
,      TOT_CL_FUNDING_AMT
,      CRS_ID
,      TEMPLATE_TYPE_CODE
,      TRADEIN_DESCRIPTION
,      TRADEIN_AMOUNT
,      DATE_TRADEIN
,      DATE_FUNDING_EXPECTED
,      LEGAL_ENTITY_ID
FROM OKL.OKL_K_HEADERS;

Dependencies

[top of page]

OKL.OKL_K_HEADERS does not reference any database object

OKL.OKL_K_HEADERS is referenced by following:

APPS: OKL_K_HEADERS