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]

TABLE: OKL.OKL_TXL_ASSETS_B

Object Details

Object Name:	OKL_TXL_ASSETS_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TXL_ASSETS_B
Subobject Name:
Status:	VALID

A contract line level transaction table to record various asset attributes needed by Fixed Asset module before activating the contract.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TXL_ASSETS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TXL_ASSETS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_NUMBER
OKL_TXL_ASSETS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_KHR_ID
TAL_IAY_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IAY_ID
TAL_IAY_NEW_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IAY_ID_NEW
TAL_ILO_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ILO_ID
TAL_ILO_OLD_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ILO_ID_OLD
TAL_KLE_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KLE_ID
TAL_TAS_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
TAS_ID	NUMBER		Yes	Foreign key to table OKL_TRX_ASSETS
ILO_ID	NUMBER			Foreign Key to view OKX_AST_LOCS_V.ID1( first part of the Primary key)
ILO_ID_OLD	NUMBER			Foreign Key to view OKX_AST_LOCS_V.ID1( first part of the Primary key)
IAY_ID	NUMBER			Foreign Key to view OKX_ASST_CATGRS_V.ID1( first part of the Primary key)
IAY_ID_NEW	NUMBER			Foreign Key to view OKX_ASST_CATGRS_V.ID1( first part of the Primary key)
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
DNZ_KHR_ID	NUMBER			Foreign Key to table OKC_K_LINES_V.DNZ_CHR_ID for Fixed asset line style.
LINE_NUMBER	NUMBER		Yes	Line number
ORG_ID	NUMBER			Operating unit identifier
TAL_TYPE	VARCHAR2	(10)	Yes	Foreign Key to table FND_LOOKUPS.LOOKUP_CODE for Lookup Type 'OKL_TRANS_LINE_TYPE
ASSET_NUMBER	VARCHAR2	(15)	Yes	Asset number
FA_LOCATION_ID	NUMBER			Fixed asset Location id
ORIGINAL_COST	NUMBER	(14)	Yes	Original cost of the asset
CURRENT_UNITS	NUMBER		Yes	Current number of units for the asset
MANUFACTURER_NAME	VARCHAR2	(30)		Manufacture Name
YEAR_MANUFACTURED	NUMBER			Year Manufactured
SUPPLIER_ID	NUMBER			Foreign Key to view OKX_VENDORS_V.ID1( first part of the Primary key) and will be populated for equipment exchange tal_type(typically OAS and NAS)
USED_ASSET_YN	VARCHAR2	(3)		Indicates whether asset is new or used, typical values are null for new and 'Y' for used
TAG_NUMBER	VARCHAR2	(40)		Tag number of the asset
MODEL_NUMBER	VARCHAR2	(40)		Model number of the asset
CORPORATE_BOOK	VARCHAR2	(70)		Corporate Book
DATE_PURCHASED	DATE			Not used
DATE_DELIVERY	DATE			Not used
IN_SERVICE_DATE	DATE			Date the asset was placed in service
LIFE_IN_MONTHS	NUMBER	(15)		Life of asset in total months
DEPRECIATION_ID	NUMBER	(15)		Foreign Key to view OKX_ASST_CATGRS_V .ID1( first part of the Primary key)
DEPRECIATION_COST	NUMBER			Depreciation cost of the asset and at the transaction at line level will be equal to Original cost of the asset
DEPRN_METHOD	VARCHAR2	(12)		Name of the depreciation method for the asset
DEPRN_RATE	NUMBER			Effective depreciation rate for Flate rate methods
SALVAGE_VALUE	NUMBER	(14)		Asset salvage value
PERCENT_SALVAGE_VALUE	NUMBER			Salvage value percentage 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
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)		Flag to indicate whether depreciation will be started/stopped in Fixed Asset
HOLD_PERIOD_DAYS	NUMBER			The number of days the transaction will be held.
OLD_SALVAGE_VALUE	NUMBER	(14)		The old salvage value in a salvage value writedown transaction.
NEW_RESIDUAL_VALUE	NUMBER	(14)		The new residual value in a residual value writedown transaction.
OLD_RESIDUAL_VALUE	NUMBER	(14)		The old residual value in a residual value writedown transaction.
UNITS_RETIRED	NUMBER			The number of units posted to Fixed Assets for retirement.
COST_RETIRED	NUMBER	(14)		The cost posted to Fixed Assets for retirement.
SALE_PROCEEDS	NUMBER	(14)		The sale proceeds posted to Fixed Assets for retirement.
REMOVAL_COST	NUMBER	(14)		The costs incurred while scrapping an Asset and retiring in Fixed Assets
DNZ_ASSET_ID	NUMBER	(15)		A denormalized key to the Fixed Asset ID.
DATE_DUE	DATE			Cut off date when the equipment exchange is due
REP_ASSET_ID	NUMBER			Like Kind Exchange Replacement Asset Id
LKE_ASSET_ID	NUMBER			Like kind Exchange Asset Id
MATCH_AMOUNT	NUMBER			Like Kind exchange Match Amount
SPLIT_INTO_SINGLES_FLAG	VARCHAR2	(3)		Split Assets Will be 'Y' if asset has to be split into single units of qty 1 each.
SPLIT_INTO_UNITS	NUMBER			Split Asset - Number of units to be split into
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
ASSET_KEY_ID	NUMBER			Asset key code combination identifier
FA_TRX_DATE	DATE			Oracle fixed assets transaction date corresponding to this transaction
RESIDUAL_SHR_PARTY_ID	NUMBER			Residual Share Party ID
RESIDUAL_SHR_AMOUNT	NUMBER			Residual Share Amount
RETIREMENT_ID	NUMBER			Asset Retirement ID
FA_COST	NUMBER			Fixed asset depreciable cost

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 does not reference any database object

OKL.OKL_TXL_ASSETS_B is referenced by following:

APPS: OKL_TXL_ASSETS_B