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]

VIEW: APPS.OKL_K_HEADERS_V

Object Details

Object Name:	OKL_K_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_K_HEADERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier in the database
ID	NUMBER		Yes	Primary key column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
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
AMD_CODE	VARCHAR2	(30)		Acceptance method code. This is a foreign key to FND_LOOKUP code 'OKL_ACCEPTANCE_METHOD'.
DATE_FIRST_ACTIVITY	DATE			Date of first activity on the contract
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
DATE_REFINANCED	DATE			The date finance closed if this was a rollover, restructure, renew, refinance contract
CREDIT_ACT_YN	VARCHAR2	(3)		Indicates whether contract is consumer credit act deal or not
TERM_DURATION	NUMBER	(10)		The duration of the contract in months
CONVERTED_ACCOUNT_YN	VARCHAR2	(3)		Indicates whether the contract account is a converted account or not
DATE_CONVERSION_EFFECTIVE	DATE			Date on which the deal conversion becomes active
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_DEAL_TRANSFERRED	DATE			Date on which the deal was transferred from one lessee to another
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
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 lease contract is eligible for multi - GAAP accounting
RECOURSE_CODE	VARCHAR2	(30)		Recourse code
LESSOR_SERV_ORG_CODE	VARCHAR2	(30)		Lessor service organization code
ASSIGNABLE_YN	VARCHAR2	(3)		Indicates whether lease contract can be assigned to an investor agreement
SECURITIZED_CODE	VARCHAR2	(30)		Securitized code
SECURITIZATION_TYPE	VARCHAR2	(30)		Securitization type
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 implicit non-IDC 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			Chage request identifier for vendor program agreement
TEMPLATE_TYPE_CODE	VARCHAR2	(30)		Contract template type code
TRADEIN_DESCRIPTION	VARCHAR2	(1995)		Trade in description
TRADEIN_AMOUNT	NUMBER			Trade in amount
DATE_TRADEIN	DATE			Date on which trade in was applied
DATE_FUNDING_EXPECTED	DATE			Date on which funding is expected
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 ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      ISG_ID
,      KHR_ID
,      PDT_ID
,      AMD_CODE
,      DATE_FIRST_ACTIVITY
,      GENERATE_ACCRUAL_YN
,      GENERATE_ACCRUAL_OVERRIDE_YN
,      DATE_REFINANCED
,      CREDIT_ACT_YN
,      TERM_DURATION
,      CONVERTED_ACCOUNT_YN
,      DATE_CONVERSION_EFFECTIVE
,      SYNDICATABLE_YN
,      SALESTYPE_YN
,      DATE_DEAL_TRANSFERRED
,      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
,      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 APPS.OKL_K_HEADERS_V;

Dependencies

[top of page]

APPS.OKL_K_HEADERS_V references the following:

APPS: OKL_K_HEADERS

APPS.OKL_K_HEADERS_V is referenced by following:

APPS: OKL_ACC_CALL_PVT - show dependent code; OKL_AM_BAL_WRITEOFF_PVT - show dependent code; OKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code; OKL_AM_CONTRACT_PRTFL_PVT - show dependent code; OKL_AM_LEASE_LOAN_TRMNT_PVT - show dependent code; OKL_AM_LEASE_TRMNT_PVT - show dependent code; OKL_ASE_PVT - show dependent code; OKL_BILL_UPFRONT_TAX_PVT - show dependent code; OKL_CONTRACT_BOOK_PVT - show dependent code; OKL_CONTRACT_INFO - show dependent code; OKL_CONTRACT_PVT - show dependent code; OKL_CONTRACT_REBOOK_PVT - show dependent code; OKL_COPY_ASSET_PVT - show dependent code; OKL_COPY_CONTRACT_PVT - show dependent code; OKL_CREATE_ADJST_PVT - show dependent code; OKL_CREATE_KLE_PVT - show dependent code; OKL_CSP_PVT - show dependent code; OKL_CS_LC_CONTRACT_PVT - show dependent code; OKL_CS_LEASE_RENEWAL_PVT - show dependent code; OKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code; OKL_CS_WF - show dependent code; OKL_DEAL_CREATE_PUB - show dependent code; OKL_DEAL_CREAT_PVT - show dependent code; OKL_EXECUTE_FORMULA_PUB - show dependent code; OKL_EXECUTE_FORMULA_PUB - show dependent code; OKL_EXECUTE_FORMULA_PVT - show dependent code; OKL_EXECUTE_FORMULA_PVT - show dependent code; OKL_FORMULAEVALUATE_PUB - show dependent code; OKL_FORMULAEVALUATE_PUB - show dependent code; OKL_INSURANCE_POLICIES_PVT - show dependent code; OKL_INS_QUOTE_PVT - show dependent code; OKL_INTERNAL_BILLING_PVT - show dependent code; OKL_INTERNAL_TO_EXTERNAL - show dependent code; OKL_IPY_PVT - show dependent code; OKL_KHR_PVT - show dependent code; OKL_KHR_PVT - show dependent code; OKL_LA_STREAM_PVT - show dependent code; OKL_LLN_PVT - show dependent code; OKL_MASS_REBOOK_PVT - show dependent code; OKL_MASTER_LEASE_AGREEMENT_PUB - show dependent code; OKL_OPEN_INTERFACE_PVT - show dependent code; OKL_PFC_PVT - show dependent code; OKL_POC_PVT - show dependent code; OKL_POL_PVT - show dependent code; OKL_PTC_PVT - show dependent code; OKL_QA_DATA_INTEGRITY - show dependent code; OKL_QTE_PVT - show dependent code; OKL_RCA_PVT - show dependent code; OKL_RECONCILE_DISPLAY_UV; OKL_REFUND_UV; OKL_SETUPDQUALITYS_PVT - show dependent code; OKL_SETUPPMVALUES_PVT - show dependent code; OKL_SETUPPOPTIONS_PVT - show dependent code; OKL_SETUPPOVALUES_PVT - show dependent code; OKL_SETUPPQVALUES_PVT - show dependent code; OKL_SETUPPRODUCTS_PVT - show dependent code; OKL_SETUPPSTYPES_PVT - show dependent code; OKL_SIF_PVT - show dependent code; OKL_STM_PVT - show dependent code; OKL_SXP_PVT - show dependent code; OKL_TAI_PVT - show dependent code; OKL_TCL_PVT - show dependent code; OKL_TCN_PVT - show dependent code