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_ASSETS_V

Object Details

Object Name:	OKX_ASSETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_ASSETS_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 System generated asset identification number
ID2	CHAR	(1)		Primary key column
NAME	VARCHAR2	(15)	Yes	User defined asset number
DESCRIPTION	VARCHAR2	(80)		User defined asset description
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
ASSET_NUMBER	VARCHAR2	(15)	Yes	User defined asset number
CORPORATE_BOOK	VARCHAR2	(15)	Yes	Corporate book code for the asset
LIFE_IN_MONTHS	NUMBER	(4)		Total life of the asset in months
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 adjustment or revaluation
TAG_NUMBER	VARCHAR2	(15)		Tag number of the asset
CURRENT_UNITS	NUMBER		Yes	Current number of units for the asset
SERIAL_NUMBER	VARCHAR2	(35)		Serial number of the asset
REVAL_CEILING	NUMBER			Upper limit for revaluing asset cost
NEW_USED	VARCHAR2	(4)	Yes	Indicates whether the asset is new or used
IN_SERVICE_DATE	DATE		Yes	Date the asset was placed in service
MANUFACTURER_NAME	VARCHAR2	(360)		Name of the manufacturer
MODEL_NUMBER	VARCHAR2	(40)		Model number of asset
ASSET_TYPE	VARCHAR2	(11)	Yes	Indicates whether the asset is CIP, capitalized or expensed
SALVAGE_VALUE	NUMBER		Yes	Asset salvage value
PERCENT_SALVAGE_VALUE	NUMBER			Salvage value percentage amount
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 the depreciation method for the asset
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Percent of remaining depreciation after a revaluation or an amortized change, or 1
BASIC_RATE	NUMBER			Base rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE	NUMBER			Actual rate used to calculate depreciation for flat-rate methods
START_DATE_ACTIVE	DATE		Yes	Effective from date
END_DATE_ACTIVE	DATE			Effective to date
STATUS	VARCHAR2	(2)		Indicates whether current record is active or inactive
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
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Indicates the property type
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Indicates whether property class is 1245(personal) or 1250(real)
IN_USE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is in use
OWNED_LEASED	VARCHAR2	(15)	Yes	Indicates whether asset is owned or leased
INVENTORIAL	VARCHAR2	(3)		Indicates whether the asset should be included in physical inventory

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ASSET_ID
,      ASSET_NUMBER
,      CORPORATE_BOOK
,      LIFE_IN_MONTHS
,      ORIGINAL_COST
,      COST
,      ADJUSTED_COST
,      TAG_NUMBER
,      CURRENT_UNITS
,      SERIAL_NUMBER
,      REVAL_CEILING
,      NEW_USED
,      IN_SERVICE_DATE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      ASSET_TYPE
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      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
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      INVENTORIAL
FROM APPS.OKX_ASSETS_V;

Dependencies

[top of page]

APPS.OKX_ASSETS_V references the following:

APPS: FA_ADDITIONS_B; FA_ADDITIONS_TL; FA_BOOKS; FA_BOOK_CONTROLS

APPS.OKX_ASSETS_V is referenced by following:

APPS: IEX_REP_PVT - show dependent code; OKL_ACTIVATE_ASSET_PVT - show dependent code; OKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code; OKL_AM_CREATE_QUOTE_PVT - show dependent code; OKL_AM_SALVAGE_VALUE_WD_UV; OKL_AM_TERMNT_INTERFACE_PVT - show dependent code; OKL_BPD_CNTR_LVLNG_SUMRY_UV; OKL_BPD_CNTR_READING_UV; OKL_CNTR_GRP_BILLING_PVT - show dependent code; OKL_CONTRACT_LINE_ITEM_PVT - show dependent code; OKL_CONTRACT_PVT - show dependent code; OKL_COPY_ASSET_PVT - show dependent code; OKL_COPY_CONTRACT_PVT - show dependent code; OKL_CREATE_KLE_PVT - show dependent code; OKL_LA_VALIDATION_UTIL_PVT - show dependent code; OKL_MAINTAIN_CONTRACT_PVT - show dependent code; OKL_OPEN_INTERFACE_PVT - show dependent code; OKL_OPI_PVT - show dependent code; OKL_POOL_ASSETS_UV; OKL_POOL_PVT - show dependent code; OKL_RELEASE_PVT - show dependent code; OKL_SPLIT_ASSET_COMP_PVT - show dependent code; OKL_SPLIT_ASSET_PVT - show dependent code; OKL_VERSION_PVT - show dependent code; OKL_VIEW_TRX_ASSETS_V; OKX_ASSET_LINES_V