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: APPS.OKX_AST_BKS_V

Object Details

Object Name:	OKX_AST_BKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_AST_BKS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER	(15)	Yes	Primary key column. Unique identifier for the asset
ID2	VARCHAR2	(15)	Yes	Primary key colum. Unique identifier for asset book
NAME	VARCHAR2	(15)	Yes	User assigned asset number
DESCRIPTION	VARCHAR2	(80)		User assigned asset description
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Asset book code
BOOK_CLASS	VARCHAR2	(15)	Yes	Indicates whether the book is 'CORPORATE', 'TAX' or 'BUDGET'
ASSET_ID	NUMBER	(15)	Yes	Unique identifier for the asset
ASSET_NUMBER	VARCHAR2	(15)	Yes	User assigned asset number
SERIAL_NUMBER	VARCHAR2	(35)		Serial number of the asset
SALVAGE_VALUE	NUMBER		Yes	Salvage value for the asset
PERCENT_SALVAGE_VALUE	NUMBER			Percentage salvage value
LIFE_IN_MONTHS	NUMBER	(4)		Life ofthe asset in complete months
ACQUISITION_DATE	DATE		Yes	Date the asset was place in service
ORIGINAL_COST	NUMBER		Yes	Original cost of the asset
COST	NUMBER		Yes	Current cost of the asset
ADJUSTED_COST	NUMBER		Yes	Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustmet or revaluation
TAG_NUMBER	VARCHAR2	(15)		Tag number of the asset
CURRENT_UNITS	NUMBER		Yes	Current units of the asset
REVAL_CEILING	NUMBER			Upper limit for revaluing the cost
NEW_USED	VARCHAR2	(4)	Yes	Indicates whether the asset is new or used
MANUFACTURER_NAME	VARCHAR2	(30)		Manufacturer name
MODEL_NUMBER	VARCHAR2	(40)		Model number of the asset
ASSET_TYPE	VARCHAR2	(11)	Yes	Indicates whether the asset is CIP, capitalized or expensed
DEPRECIATION_CATEGORY	NUMBER	(15)	Yes	Unique identifier for asset category
DEPRN_START_DATE	DATE		Yes	Date the asset started to depreciate
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Name of te depreciation method for the asset
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Percent of remaining depreciation after revaluation or an amortized change , or 1
BASIC_RATE	NUMBER			Basic rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE	NUMBER			Actual rate used to calculate depreciation amount for flat-rate methods
START_DATE_ACTIVE	DATE		Yes	Effective from date
END_DATE_ACTIVE	DATE			Effective to date
STATUS	VARCHAR2	(1)		Indiates whether the asset record is active
PRIMARY_UOM_CODE	VARCHAR2	(0)		Primary unit of measure code
RECOVERABLE_COST	NUMBER		Yes	Cost minus salvage value , or depreciation ceiling whichever is lower
ORG_ID	NUMBER	(15)		Unique identifier for operating unit
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Unique identifier for accounting set of books

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      BOOK_TYPE_CODE
,      BOOK_CLASS
,      ASSET_ID
,      ASSET_NUMBER
,      SERIAL_NUMBER
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      LIFE_IN_MONTHS
,      ACQUISITION_DATE
,      ORIGINAL_COST
,      COST
,      ADJUSTED_COST
,      TAG_NUMBER
,      CURRENT_UNITS
,      REVAL_CEILING
,      NEW_USED
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      ASSET_TYPE
,      DEPRECIATION_CATEGORY
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      RATE_ADJUSTMENT_FACTOR
,      BASIC_RATE
,      ADJUSTED_RATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      RECOVERABLE_COST
,      ORG_ID
,      SET_OF_BOOKS_ID
FROM APPS.OKX_AST_BKS_V;

Dependencies

[top of page]

APPS.OKX_AST_BKS_V references the following:

APPS: FA_ADDITIONS_B; FA_ADDITIONS_TL; FA_BOOKS; FA_BOOK_CONTROLS

APPS.OKX_AST_BKS_V is referenced by following:

APPS: OKL_ACTIVATE_ASSET_PVT - show dependent code; OKL_ACTIVATE_ASSET_PVT - show dependent code; OKL_COPY_ASSET_PVT - show dependent code; OKL_LIKE_KIND_EXCHANGE_PVT - show dependent code; OKL_MASS_REBOOK_PVT - show dependent code; OKL_SPLIT_ASSET_PVT - show dependent code