[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_K_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_K_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
OKL_K_LINES stores Oracle Lease Management specific attributes for each contract line. These attributes are not covered in the standard Contracts core line.
| 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 |
| KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
| STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
| PRC_CODE | VARCHAR2 | (30) | Property class code. Foreign key to FND_LOOKUPS | |
| FCG_CODE | VARCHAR2 | (30) | Funding category code. Foreign key to FND_LOOKUPS | |
| NTY_CODE | VARCHAR2 | (30) | Concept type code. Foreign key to FND_LOOKUPS | |
| ESTIMATED_OEC | NUMBER | (14) | Estimated original equipment cost | |
| LAO_AMOUNT | NUMBER | (14) | Amount of add ons to asset | |
| TITLE_DATE | DATE | Date the title was received by the title holder for the asset | ||
| FEE_CHARGE | NUMBER | (14) | Fee Charge | |
| LRS_PERCENT | NUMBER | (5) | Not used | |
| INITIAL_DIRECT_COST | NUMBER | (14) | Direct costs such as documentation fee associated with leasing a piece of land, built-area. | |
| PERCENT_STAKE | NUMBER | (5) | Not used | |
| PERCENT | NUMBER | (5) | Rate for insurance premium calculation | |
| EVERGREEN_PERCENT | NUMBER | (5) | Evergreen Percentage | |
| AMOUNT_STAKE | NUMBER | (14) | Not used | |
| OCCUPANCY | NUMBER | (20) | The percentage of occupancy of the built facility | |
| COVERAGE | NUMBER | (14) | The amount of coverage for insurance premium calculation | |
| RESIDUAL_PERCENTAGE | NUMBER | (5) | The percentage of original equipment cost to be used for residual value | |
| DATE_LAST_INSPECTION | DATE | Date when the built area was last inspected | ||
| DATE_SOLD | DATE | Date syndication was sold to the investor | ||
| LRV_AMOUNT | NUMBER | (14) | Residual value insurance amount | |
| CAPITAL_REDUCTION | NUMBER | Currency amount applied to principle | ||
| DATE_NEXT_INSPECTION_DUE | DATE | Next time the building will be inspected | ||
| DATE_RESIDUAL_LAST_REVIEW | DATE | Date on which residual was reviewed last time | ||
| DATE_LAST_REAMORTISATION | DATE | Date on which the amortisation was restarted | ||
| VENDOR_ADVANCE_PAID | NUMBER | (14) | Advance rent paid to the vendor | |
| WEIGHTED_AVERAGE_LIFE | NUMBER | (30) | Average life the building can stand on the ground | |
| TRADEIN_AMOUNT | NUMBER | Trade-in amount for the item/asset | ||
| BOND_EQUIVALENT_YIELD | NUMBER | (5) | The yield on the building lease as a percentage of return from Bonds for the same investment | |
| TERMINATION_PURCHASE_AMOUNT | NUMBER | (14) | The amount paid for buyout | |
| REFINANCE_AMOUNT | NUMBER | (14) | The amount used to refinance the lease of the building | |
| YEAR_BUILT | NUMBER | (4) | Year the building was built. | |
| DELIVERED_DATE | DATE | Date in which the item is delivered | ||
| CREDIT_TENANT_YN | VARCHAR2 | (3) | Indicates whether tenant has to be credited or not. Used in real estate contracts only | |
| DATE_LAST_CLEANUP | DATE | Catchup when change of interest for fixed payment impacts interest payments | ||
| YEAR_OF_MANUFACTURE | VARCHAR2 | (240) | Year in which the item/asset is manufactured | |
| COVERAGE_RATIO | NUMBER | (5) | Identifies the debt service coverage of the transaction | |
| REMARKETED_AMOUNT | NUMBER | (14) | The currency amount received for sale of item | |
| GROSS_SQUARE_FOOTAGE | NUMBER | (30) | Gross square footage of the building located on the property | |
| PRESCRIBED_ASSET_YN | VARCHAR2 | (3) | Indicates wheter asset is a prescribed asset or not | |
| DATE_REMARKETED | DATE | Date when asset remarketed | ||
| NET_RENTABLE | NUMBER | (14) | Net square footage of the building which tenants will pay rent on | |
| REMARKET_MARGIN | NUMBER | The margin on the remarketing amount | ||
| DATE_LETTER_ACCEPTANCE | DATE | Date the customer signed the acceptance letter. | ||
| REPURCHASED_AMOUNT | NUMBER | (14) | The currency amount received for sale of item to partner | |
| DATE_COMMITMENT_EXPIRATION | DATE | Date the commitment expires | ||
| DATE_REPURCHASED | DATE | Date when asset was repurchased | ||
| DATE_APPRAISAL | DATE | Appraisal date | ||
| RESIDUAL_VALUE | NUMBER | (20) | Residual value | |
| APPRAISAL_VALUE | NUMBER | (14) | Appraisal value | |
| SECURED_DEAL_YN | VARCHAR2 | (3) | Indicates whether this is a secured deal or not | |
| GAIN_LOSS | NUMBER | (4) | Flag to indicate loss or gain on the leased asset | |
| FLOOR_AMOUNT | NUMBER | (14) | The absolute minimum one should expect from a repurchase or remarket sale | |
| RE_LEASE_YN | VARCHAR2 | (3) | Indicates whether asset is a re-leased asset or not | |
| PREVIOUS_CONTRACT | VARCHAR2 | (40) | Previous Lessors Contract Number | |
| TRACKED_RESIDUAL | NUMBER | (14) | Field for tracking residual other than what is in the contract | |
| DATE_TITLE_RECEIVED | DATE | Date on which a title was received for this asset | ||
| AMOUNT | NUMBER | Amount | ||
| 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 | |
| STY_ID_FOR | NUMBER | (10) | Not used | |
| CLG_ID | NUMBER | Foreign key to table OKL_CNTR_LVLNG_GRPS_B | ||
| 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 | |
| DATE_FUNDING | DATE | Date on which funding is done | ||
| DATE_FUNDING_REQUIRED | DATE | Date on which funding is required | ||
| DATE_ACCEPTED | DATE | Acceptance date | ||
| DATE_DELIVERY_EXPECTED | DATE | Date on which delivery of asset is expected | ||
| OEC | NUMBER | Original equipment cost of the asset | ||
| CAPITAL_AMOUNT | NUMBER | Capital amount | ||
| RESIDUAL_GRNTY_AMOUNT | NUMBER | (14) | Residual guaranty amount | |
| RESIDUAL_CODE | VARCHAR2 | (30) | Residual code | |
| RVI_PREMIUM | NUMBER | (14) | RVI Premium | |
| CREDIT_NATURE | VARCHAR2 | (30) | For revolving line of credit indicates wherer the line is 'New', 'Add' or 'Reduce' | |
| CAPITALIZED_INTEREST | NUMBER | (14) | Amount of capitalized interest | |
| CAPITAL_REDUCTION_PERCENT | NUMBER | (5) | Capital reduction percentage | |
| DATE_PAY_INVESTOR_START | DATE | Investor agreement - date on which payment to investor starts | ||
| PAY_INVESTOR_FREQUENCY | VARCHAR2 | (30) | Investor agreement - investor payment frequency | |
| PAY_INVESTOR_EVENT | VARCHAR2 | (30) | Investor agreement - event on which paymet to investor starts | |
| PAY_INVESTOR_REMITTANCE_DAYS | NUMBER | Investor agreement - investor payment remittance day | ||
| FEE_TYPE | VARCHAR2 | (30) | Fee type for financed fees | |
| SUBSIDY_ID | NUMBER | Unique identifier for subsidy. Foreign key to OKL_SUBSIDIES_B.ID | ||
| SUBSIDY_OVERRIDE_AMOUNT | NUMBER | Subsidy override amount | ||
| PRE_TAX_YIELD | NUMBER | Pre tax yield | ||
| AFTER_TAX_YIELD | NUMBER | After tax yield | ||
| IMPLICIT_INTEREST_RATE | NUMBER | Implicit interest rate | ||
| IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | Implicit non-IDC interest rate | ||
| PRE_TAX_IRR | NUMBER | Pre-tax IRR | ||
| AFTER_TAX_IRR | NUMBER | After tax IRR | ||
| 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 Pe-tax IRR | ||
| SUB_AFTER_TAX_IRR | NUMBER | Subsidized after tax IRR | ||
| ITEM_INSURANCE_CATEGORY | NUMBER | Denormalized column to capture the item insurance asset category at the time of asset entry | ||
| QTE_ID | NUMBER | Rollover Quote Identifier | ||
| FUNDING_DATE | DATE | Funding Date | ||
| STREAM_TYPE_SUBCLASS | VARCHAR2 | (30) | The subclass of the stream type | |
| DATE_FUNDING_EXPECTED | DATE | Date on which funding is expected | ||
| MANUFACTURER_NAME | VARCHAR2 | (360) | Manufacturer name | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number | |
| DOWN_PAYMENT_RECEIVER_CODE | VARCHAR2 | (30) | Down payment receiver code | |
| CAPITALIZE_DOWN_PAYMENT_YN | VARCHAR2 | (3) | Flag to indicate whether down payment is capitalized or not | |
| FEE_PURPOSE_CODE | VARCHAR2 | (30) | Fee purpose code | |
| TERMINATION_VALUE | NUMBER | Termination value | ||
| EXPECTED_ASSET_COST | NUMBER | Expected Asset Cost | ||
| ORIG_CONTRACT_LINE_ID | NUMBER | Reference to the original contract line identifier | ||
| ORIGINATION_INCOME | NUMBER | Origination Income | ||
| AMOUNT_BALANCE_LEGACY | NUMBER | Balance amount in legacy system | ||
| DT_EFFECTIVE_BALANCE_LEGACY | DATE | Effective date of balance in legacy system |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, KLE_ID
, STY_ID
, PRC_CODE
, FCG_CODE
, NTY_CODE
, ESTIMATED_OEC
, LAO_AMOUNT
, TITLE_DATE
, FEE_CHARGE
, LRS_PERCENT
, INITIAL_DIRECT_COST
, PERCENT_STAKE
, PERCENT
, EVERGREEN_PERCENT
, AMOUNT_STAKE
, OCCUPANCY
, COVERAGE
, RESIDUAL_PERCENTAGE
, DATE_LAST_INSPECTION
, DATE_SOLD
, LRV_AMOUNT
, CAPITAL_REDUCTION
, DATE_NEXT_INSPECTION_DUE
, DATE_RESIDUAL_LAST_REVIEW
, DATE_LAST_REAMORTISATION
, VENDOR_ADVANCE_PAID
, WEIGHTED_AVERAGE_LIFE
, TRADEIN_AMOUNT
, BOND_EQUIVALENT_YIELD
, TERMINATION_PURCHASE_AMOUNT
, REFINANCE_AMOUNT
, YEAR_BUILT
, DELIVERED_DATE
, CREDIT_TENANT_YN
, DATE_LAST_CLEANUP
, YEAR_OF_MANUFACTURE
, COVERAGE_RATIO
, REMARKETED_AMOUNT
, GROSS_SQUARE_FOOTAGE
, PRESCRIBED_ASSET_YN
, DATE_REMARKETED
, NET_RENTABLE
, REMARKET_MARGIN
, DATE_LETTER_ACCEPTANCE
, REPURCHASED_AMOUNT
, DATE_COMMITMENT_EXPIRATION
, DATE_REPURCHASED
, DATE_APPRAISAL
, RESIDUAL_VALUE
, APPRAISAL_VALUE
, SECURED_DEAL_YN
, GAIN_LOSS
, FLOOR_AMOUNT
, RE_LEASE_YN
, PREVIOUS_CONTRACT
, TRACKED_RESIDUAL
, DATE_TITLE_RECEIVED
, AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, STY_ID_FOR
, CLG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DATE_FUNDING
, DATE_FUNDING_REQUIRED
, DATE_ACCEPTED
, DATE_DELIVERY_EXPECTED
, OEC
, CAPITAL_AMOUNT
, RESIDUAL_GRNTY_AMOUNT
, RESIDUAL_CODE
, RVI_PREMIUM
, CREDIT_NATURE
, CAPITALIZED_INTEREST
, CAPITAL_REDUCTION_PERCENT
, DATE_PAY_INVESTOR_START
, PAY_INVESTOR_FREQUENCY
, PAY_INVESTOR_EVENT
, PAY_INVESTOR_REMITTANCE_DAYS
, FEE_TYPE
, SUBSIDY_ID
, SUBSIDY_OVERRIDE_AMOUNT
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, 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
, ITEM_INSURANCE_CATEGORY
, QTE_ID
, FUNDING_DATE
, STREAM_TYPE_SUBCLASS
, DATE_FUNDING_EXPECTED
, MANUFACTURER_NAME
, MODEL_NUMBER
, DOWN_PAYMENT_RECEIVER_CODE
, CAPITALIZE_DOWN_PAYMENT_YN
, FEE_PURPOSE_CODE
, TERMINATION_VALUE
, EXPECTED_ASSET_COST
, ORIG_CONTRACT_LINE_ID
, ORIGINATION_INCOME
, AMOUNT_BALANCE_LEGACY
, DT_EFFECTIVE_BALANCE_LEGACY
FROM APPS.OKL_K_LINES_V;
APPS
OKL_K_LINES
APPS
OKL_ACD_PVT
- show dependent code
OKL_ACTIVATE_ASSET_PVT
- show dependent code
OKL_AM_CALC_QUOTE_STREAM_PVT
- show dependent code
OKL_AM_CNTRCT_LN_TRMNT_PVT
- show dependent code
OKL_ART_PVT
- show dependent code
OKL_ASD_PVT
- show dependent code
OKL_CONTRACT_PVT
- show dependent code
OKL_COPY_ASSET_PVT
- show dependent code
OKL_COPY_CONTRACT_PVT
- show dependent code
OKL_CREATE_KLE_PVT
- show dependent code
OKL_CREATE_STREAMS_PVT
- show dependent code
OKL_CREDIT_PUB
- show dependent code
OKL_CS_LEASE_RENEWAL_PVT
- show dependent code
OKL_CS_PRINCIPAL_PAYDOWN_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_INA_PVT
- show dependent code
OKL_IPY_PVT
- show dependent code
OKL_ITI_PVT
- show dependent code
OKL_KLE_PVT
- show dependent code
OKL_KLE_PVT
- show dependent code
OKL_LA_PAYMENTS_PVT
- show dependent code
OKL_LA_STREAM_PVT
- show dependent code
OKL_MASS_REBOOK_PUB
- show dependent code
OKL_MASS_REBOOK_PUB
- show dependent code
OKL_MASS_REBOOK_PVT
- show dependent code
OKL_MASS_REBOOK_PVT
- show dependent code
OKL_OPEN_INTERFACE_PVT
- show dependent code
OKL_PFL_PVT
- show dependent code
OKL_POC_PVT
- show dependent code
OKL_PTC_PVT
- show dependent code
OKL_SEC_INVESTOR_PVT
- show dependent code
OKL_SEEDED_FUNCTIONS_PVT
- show dependent code
OKL_SFE_PVT
- show dependent code
OKL_SIL_PVT
- show dependent code
OKL_SPLIT_ASSET_PVT
- show dependent code
OKL_SPLIT_CONTRACT_PVT
- show dependent code
OKL_STM_PVT
- show dependent code
OKL_TAL_PVT
- show dependent code
OKL_TCL_PVT
- show dependent code
OKL_TPL_PVT
- show dependent code
OKL_TQD_PVT
- show dependent code
OKL_TQL_PVT
- show dependent code
|
|
|
|