[Home] [Help] [Dependency Information]
Object Name: | OKL_TXL_ASSETS_B# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
TAS_ID | NUMBER | Yes | ||
ILO_ID | NUMBER | |||
ILO_ID_OLD | NUMBER | |||
IAY_ID | NUMBER | |||
IAY_ID_NEW | NUMBER | |||
KLE_ID | NUMBER | |||
DNZ_KHR_ID | NUMBER | |||
LINE_NUMBER | NUMBER | Yes | ||
ORG_ID | NUMBER | |||
TAL_TYPE | VARCHAR2 | (10) | Yes | |
ASSET_NUMBER | VARCHAR2 | (15) | Yes | |
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) | ||
TAG_NUMBER | VARCHAR2 | (40) | ||
MODEL_NUMBER | VARCHAR2 | (40) | ||
CORPORATE_BOOK | VARCHAR2 | (70) | ||
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_RATE | NUMBER | |||
SALVAGE_VALUE | NUMBER | (14) | ||
PERCENT_SALVAGE_VALUE | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
ATTRIBUTE1 | VARCHAR2 | (450) | ||
ATTRIBUTE2 | VARCHAR2 | (450) | ||
ATTRIBUTE3 | VARCHAR2 | (450) | ||
ATTRIBUTE4 | VARCHAR2 | (450) | ||
ATTRIBUTE5 | VARCHAR2 | (450) | ||
ATTRIBUTE6 | VARCHAR2 | (450) | ||
ATTRIBUTE7 | VARCHAR2 | (450) | ||
ATTRIBUTE8 | VARCHAR2 | (450) | ||
ATTRIBUTE9 | VARCHAR2 | (450) | ||
ATTRIBUTE10 | VARCHAR2 | (450) | ||
ATTRIBUTE11 | VARCHAR2 | (450) | ||
ATTRIBUTE12 | VARCHAR2 | (450) | ||
ATTRIBUTE13 | VARCHAR2 | (450) | ||
ATTRIBUTE14 | VARCHAR2 | (450) | ||
ATTRIBUTE15 | VARCHAR2 | (450) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
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) | ||
DATE_DUE | DATE | |||
REP_ASSET_ID | NUMBER | |||
LKE_ASSET_ID | NUMBER | |||
MATCH_AMOUNT | NUMBER | |||
SPLIT_INTO_SINGLES_FLAG | VARCHAR2 | (3) | ||
SPLIT_INTO_UNITS | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
ASSET_KEY_ID | NUMBER | |||
FA_TRX_DATE | DATE | |||
RESIDUAL_SHR_PARTY_ID | NUMBER | |||
RESIDUAL_SHR_AMOUNT | NUMBER | |||
RETIREMENT_ID | NUMBER | |||
FA_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, TAS_ID
, ILO_ID
, ILO_ID_OLD
, IAY_ID
, IAY_ID_NEW
, KLE_ID
, DNZ_KHR_ID
, LINE_NUMBER
, ORG_ID
, TAL_TYPE
, ASSET_NUMBER
, FA_LOCATION_ID
, ORIGINAL_COST
, CURRENT_UNITS
, MANUFACTURER_NAME
, YEAR_MANUFACTURED
, SUPPLIER_ID
, USED_ASSET_YN
, TAG_NUMBER
, MODEL_NUMBER
, CORPORATE_BOOK
, DATE_PURCHASED
, DATE_DELIVERY
, IN_SERVICE_DATE
, LIFE_IN_MONTHS
, DEPRECIATION_ID
, DEPRECIATION_COST
, DEPRN_METHOD
, DEPRN_RATE
, SALVAGE_VALUE
, PERCENT_SALVAGE_VALUE
, 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
, 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
, DATE_DUE
, REP_ASSET_ID
, LKE_ASSET_ID
, MATCH_AMOUNT
, SPLIT_INTO_SINGLES_FLAG
, SPLIT_INTO_UNITS
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, ASSET_KEY_ID
, FA_TRX_DATE
, RESIDUAL_SHR_PARTY_ID
, RESIDUAL_SHR_AMOUNT
, RETIREMENT_ID
, FA_COST
FROM OKL.OKL_TXL_ASSETS_B#;
|
|
|