eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: OKL.OKL_TXL_ASSETS_B#

Object Details

Object Name:	OKL_TXL_ASSETS_B#
Object Type:	VIEW
Owner:	OKL
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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#;

Dependencies

[top of page]

OKL.OKL_TXL_ASSETS_B# references the following:

OKL: OKL_TXL_ASSETS_B

OKL.OKL_TXL_ASSETS_B# is referenced by following:

APPS: OKL_TXL_ASSETS_B