[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_AM_OFF_LSE_TRX_UPD_UV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_AM_OFF_LSE_TRX_UPD_UV
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier in the database | |
| TAL_ID | NUMBER | Yes | Foreign key to view OKL_TXL_ASSETS_V | |
| TAS_TYPE | VARCHAR2 | (10) | Yes | |
| TAS_TYPE_MEANING | VARCHAR2 | (80) | Yes | QuickCode meaning |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
| TAS_ID | NUMBER | Yes | Foreign key to view OKL_TRX_ASSETS_V | |
| ILO_ID | NUMBER | |||
| ILO_ID_OLD | NUMBER | |||
| IAY_ID | NUMBER | |||
| FA_CATEGORY_DESCRIPTION | VARCHAR2 | (40) | ||
| IAY_ID_NEW | NUMBER | |||
| KLE_ID | NUMBER | Foreign key to view OKL_K_LINES_V | ||
| DNZ_KHR_ID | NUMBER | |||
| LINE_NUMBER | NUMBER | Yes | Line Number | |
| ORG_ID | NUMBER | Operating Unit identifier | ||
| TAL_TYPE | VARCHAR2 | (10) | Yes | |
| ASSET_NUMBER | VARCHAR2 | (15) | Yes | Asset Number |
| DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
| FA_LOCATION_ID | NUMBER | |||
| ORIGINAL_COST | NUMBER | Yes | ||
| CURRENT_UNITS | NUMBER | Yes | ||
| MANUFACTURER_NAME | VARCHAR2 | (360) | ||
| YEAR_MANUFACTURED | NUMBER | |||
| SUPPLIER_ID | NUMBER | |||
| USED_ASSET_YN | VARCHAR2 | (3) | Yes or No | |
| TAG_NUMBER | VARCHAR2 | (40) | ||
| MODEL_NUMBER | VARCHAR2 | (40) | ||
| DATE_PURCHASED | DATE | |||
| DATE_DELIVERY | DATE | |||
| IN_SERVICE_DATE | DATE | |||
| LIFE_IN_MONTHS | NUMBER | (15) | ||
| DEPRECIATION_ID | NUMBER | (15) | ||
| DEPRECIATION_COST | NUMBER | |||
| DEPRN_METHOD | VARCHAR2 | (12) | ||
| DEPRN_METHOD_NAME | VARCHAR2 | (80) | Full name of the depreciation method | |
| DEPRN_RATE | NUMBER | |||
| SALVAGE_VALUE | NUMBER | (14) | ||
| PERCENT_SALVAGE_VALUE | NUMBER | |||
| DATE_DUE | DATE | |||
| 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 | |
| DEPRECIATE_YN | VARCHAR2 | (3) | ||
| HOLD_PERIOD_DAYS | NUMBER | |||
| OLD_SALVAGE_VALUE | NUMBER | (14) | ||
| NEW_RESIDUAL_VALUE | NUMBER | (14) | ||
| OLD_RESIDUAL_VALUE | NUMBER | (14) | ||
| UNITS_RETIRED | NUMBER | |||
| COST_RETIRED | NUMBER | (14) | ||
| SALE_PROCEEDS | NUMBER | (14) | ||
| REMOVAL_COST | NUMBER | (14) | ||
| DNZ_ASSET_ID | NUMBER | (15) | ||
| TSU_CODE | VARCHAR2 | (30) | Yes | Notes and comments |
| TSU_CODE_MEANING | VARCHAR2 | (80) | Yes | QuickCode meaning |
| TRY_ID | NUMBER | Yes | Foreign key to view OKL_TRX_TYPES_V | |
| DATE_TRANS_OCCURRED | DATE | Yes | ||
| FIN_ASSET_NUMBER | VARCHAR2 | (150) | Item name. | |
| CONTRACT_STATUS | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
| PRODUCT_NAME | VARCHAR2 | (150) | This is the name for the Product. | |
| CONTRACT_END_DATE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
| ASSET_BOOK | VARCHAR2 | (70) | ||
| ASSET_BOOK_NAME | VARCHAR2 | (30) | Yes | |
| ASSET_BOOK_TYPE | VARCHAR2 | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TAL_ID
, TAS_TYPE
, TAS_TYPE_MEANING
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, TAS_ID
, ILO_ID
, ILO_ID_OLD
, IAY_ID
, FA_CATEGORY_DESCRIPTION
, IAY_ID_NEW
, KLE_ID
, DNZ_KHR_ID
, LINE_NUMBER
, ORG_ID
, TAL_TYPE
, ASSET_NUMBER
, DESCRIPTION
, FA_LOCATION_ID
, ORIGINAL_COST
, CURRENT_UNITS
, MANUFACTURER_NAME
, YEAR_MANUFACTURED
, SUPPLIER_ID
, USED_ASSET_YN
, TAG_NUMBER
, MODEL_NUMBER
, DATE_PURCHASED
, DATE_DELIVERY
, IN_SERVICE_DATE
, LIFE_IN_MONTHS
, DEPRECIATION_ID
, DEPRECIATION_COST
, DEPRN_METHOD
, DEPRN_METHOD_NAME
, DEPRN_RATE
, SALVAGE_VALUE
, PERCENT_SALVAGE_VALUE
, DATE_DUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DEPRECIATE_YN
, HOLD_PERIOD_DAYS
, OLD_SALVAGE_VALUE
, NEW_RESIDUAL_VALUE
, OLD_RESIDUAL_VALUE
, UNITS_RETIRED
, COST_RETIRED
, SALE_PROCEEDS
, REMOVAL_COST
, DNZ_ASSET_ID
, TSU_CODE
, TSU_CODE_MEANING
, TRY_ID
, DATE_TRANS_OCCURRED
, FIN_ASSET_NUMBER
, CONTRACT_STATUS
, CONTRACT_NUMBER
, PRODUCT_NAME
, CONTRACT_END_DATE
, ASSET_BOOK
, ASSET_BOOK_NAME
, ASSET_BOOK_TYPE
FROM APPS.OKL_AM_OFF_LSE_TRX_UPD_UV;
APPS
FA_BOOK_CONTROLS
FA_CATEGORIES_VL
FA_METHODS
FND_GLOBAL
- show dependent code
FND_LOOKUPS
OKC_K_LINES_V
OKC_UTIL
- show dependent code
OKL_K_HEADERS_FULL_V
OKL_PRODUCTS_V
OKL_TRX_ASSETS
OKL_TXD_ASSETS_B
OKL_TXL_ASSETS_B
OKL_TXL_ASSETS_TL
APPS.OKL_AM_OFF_LSE_TRX_UPD_UV is not referenced by any database object
|
|
|
|