[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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
|
| 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 |
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;
OKL.OKL_K_HEADERS does not reference any database object
OKL.OKL_K_HEADERS is referenced by following:
APPS
OKL_K_HEADERS
|
|
|
|