[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_ST_MAP_ASSETS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_ST_MAP_ASSETS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_NUMBER | NUMBER | Yes | order or sequence within "parent" | |
| SIF_ID | NUMBER | Yes | Foreign key to view OKL_STREAM_INTERFACES_V | |
| KLE_ID | NUMBER | Yes | Foreign key to view OKL_K_LINES_V | |
| INDEX_NUMBER | NUMBER | Yes | Index to determine relationship with Contract | |
| DESCRIPTION | VARCHAR2 | (1995) | Description | |
| ASSET_COST | NUMBER | (14) | OEC | |
| DATE_DELIVERY | DATE | Delivery Date | ||
| DATE_FUNDING | DATE | Date A/P payment | ||
| RESIDUAL_AMOUNT | NUMBER | (14) | Residual value | |
| RESIDUAL_GUARANTEE_AMOUNT | NUMBER | (14) | Amount of the RV guaranteed | |
| RESIDUAL_GUARANTEE_METHOD | VARCHAR2 | (30) | RV guaranteed by lessee or 3rd party | |
| FED_DEPRE_METHOD | VARCHAR2 | (80) | Tax depreciation method from FA | |
| DATE_FED_DEPRE | DATE | Date in-service or delivery date | ||
| FED_DEPRE_BASIS_PERCENT | NUMBER | Depreciable amount per asset cost | ||
| FED_DEPRE_TERM | NUMBER | (4) | From FA Category pre-set depreciable term | |
| FED_DEPRE_DMNSHING_VALUE_RATE | NUMBER | (5) | From FA Category rate for tax methods that decline over the term | |
| FED_DEPRE_SALVAGE | NUMBER | From FA Category value to depreciate to (usually zero) | ||
| FED_DEPRE_ADR_CONVE | VARCHAR2 | (80) | From FA Category tax handling method for partial year | |
| STATE_DEPRE_METHOD | VARCHAR2 | (80) | Tax depreciation method from FA | |
| DATE_STATE_DEPRE | DATE | Same as Fed | ||
| STATE_DEPRE_BASIS_PERCENT | NUMBER | Depreciable amount per asset cost | ||
| STATE_DEPRE_TERM | NUMBER | (4) | From FA Category pre-set depreciable term | |
| STATE_DEPRE_DMNSHING_VALUE_RT | NUMBER | (5) | From FA Category rate for tax methods that decline over the term | |
| STATE_DEPRE_SALVAGE | NUMBER | From FA Category value to depreciate to (usually zero) | ||
| STATE_DEPRE_ADR_CONVENT | VARCHAR2 | (80) | From FA Category tax handling method for partial year | |
| BOOK_METHOD | VARCHAR2 | (80) | From FA (method of depreciation) | |
| DATE_BOOK | DATE | From FA (date depreciation starts) | ||
| BOOK_BASIS_PERCENT | NUMBER | From FA (percent of cost to depreciate) | ||
| BOOK_TERM | NUMBER | (4) | From FA (term to depreciate over) | |
| BOOK_DEPRE_DMNSHING_VALUE_RT | NUMBER | (5) | From FA (rate for methods that decline over the term) | |
| BOOK_SALVAGE | NUMBER | From FA (value to depreciate to) | ||
| BOOK_ADR_CONVENTION | VARCHAR2 | (80) | From FA (handling of partial year depreciation) | |
| PURCHASE_OPTION | VARCHAR2 | (30) | Option available to lessee | |
| DATE_START | DATE | Start date for contract | ||
| DATE_LENDING | DATE | Funding date of a loan | ||
| PURCHASE_OPTION_AMOUNT | NUMBER | (14) | Interest rate for a loan | |
| RESIDUAL_GUARANTEE_TYPE | VARCHAR2 | (200) | ||
| STREAM_INTERFACE_ATTRIBUTE01 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE02 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE03 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE04 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE05 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE06 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE07 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE08 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE09 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| RESIDUAL_DATE | DATE | Residual Date | ||
| DOWN_PAYMENT_AMOUNT | NUMBER | Down Payment Amount | ||
| CAPITALIZE_DOWN_PAYMENT_YN | VARCHAR2 | (30) | Flag to indicate if the down payment is capitalized or not | |
| ORIG_CONTRACT_LINE_ID | NUMBER | Foreign key to table okc_k_lines_b |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_NUMBER
, SIF_ID
, KLE_ID
, INDEX_NUMBER
, DESCRIPTION
, ASSET_COST
, DATE_DELIVERY
, DATE_FUNDING
, RESIDUAL_AMOUNT
, RESIDUAL_GUARANTEE_AMOUNT
, RESIDUAL_GUARANTEE_METHOD
, FED_DEPRE_METHOD
, DATE_FED_DEPRE
, FED_DEPRE_BASIS_PERCENT
, FED_DEPRE_TERM
, FED_DEPRE_DMNSHING_VALUE_RATE
, FED_DEPRE_SALVAGE
, FED_DEPRE_ADR_CONVE
, STATE_DEPRE_METHOD
, DATE_STATE_DEPRE
, STATE_DEPRE_BASIS_PERCENT
, STATE_DEPRE_TERM
, STATE_DEPRE_DMNSHING_VALUE_RT
, STATE_DEPRE_SALVAGE
, STATE_DEPRE_ADR_CONVENT
, BOOK_METHOD
, DATE_BOOK
, BOOK_BASIS_PERCENT
, BOOK_TERM
, BOOK_DEPRE_DMNSHING_VALUE_RT
, BOOK_SALVAGE
, BOOK_ADR_CONVENTION
, PURCHASE_OPTION
, DATE_START
, DATE_LENDING
, PURCHASE_OPTION_AMOUNT
, RESIDUAL_GUARANTEE_TYPE
, STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
, RESIDUAL_DATE
, DOWN_PAYMENT_AMOUNT
, CAPITALIZE_DOWN_PAYMENT_YN
, ORIG_CONTRACT_LINE_ID
FROM APPS.OKL_ST_MAP_ASSETS_V;
APPS
OKL_SIF_LINES
OKL_STREAM_INTERFACES
APPS.OKL_ST_MAP_ASSETS_V is not referenced by any database object
|
|
|
|