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.OKL_VIEW_TRX_ASSETS_V

Object Details

Object Name:	OKL_VIEW_TRX_ASSETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_VIEW_TRX_ASSETS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ID1	NUMBER		Yes
ID2	CHAR	(1)
NAME	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(80)
ITEM_DESCRIPTION	VARCHAR2	(1995)
COMMENTS	VARCHAR2	(1995)
CHR_ID	NUMBER
DNZ_CHR_ID	NUMBER		Yes
LTY_CODE	VARCHAR2	(30)	Yes
LSE_TYPE	VARCHAR2	(10)	Yes
LSE_PARENT_ID	NUMBER
PARENT_LINE_ID	NUMBER
LINE_NUMBER	VARCHAR2	(150)	Yes
DATE_TERMINATED	DATE
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
STATUS	VARCHAR2	(1)
ASSET_ID	NUMBER	(15)	Yes
QUANTITY	NUMBER		Yes
UNIT_OF_MEASURE_CODE	VARCHAR2	(3)
ASSET_NUMBER	VARCHAR2	(15)	Yes
CORPORATE_BOOK	VARCHAR2	(15)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
ORIGINAL_COST	NUMBER
COST	NUMBER		Yes
ADJUSTED_COST	NUMBER		Yes
TAG_NUMBER	VARCHAR2	(15)
CURRENT_UNITS	NUMBER		Yes
SERIAL_NUMBER	VARCHAR2	(35)
REVAL_CEILING	NUMBER
NEW_USED	VARCHAR2	(4)	Yes
IN_SERVICE_DATE	DATE		Yes
MANUFACTURER_NAME	VARCHAR2	(360)
MODEL_NUMBER	VARCHAR2	(40)
ASSET_TYPE	VARCHAR2	(11)	Yes
SALVAGE_VALUE	NUMBER		Yes
PERCENT_SALVAGE_VALUE	NUMBER
DEPRECIATION_CATEGORY	NUMBER	(15)	Yes
DEPRN_START_DATE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes
BASIC_RATE	NUMBER
ADJUSTED_RATE	NUMBER
RECOVERABLE_COST	NUMBER		Yes
ORG_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
PROPERTY_TYPE_CODE	VARCHAR2	(10)
PROPERTY_1245_1250_CODE	VARCHAR2	(4)
IN_USE_FLAG	VARCHAR2	(3)	Yes
OWNED_LEASED	VARCHAR2	(15)	Yes
INVENTORIAL	VARCHAR2	(3)
LINE_STATUS	VARCHAR2	(30)	Yes
YEAR_BUILT	NUMBER	(4)

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      DNZ_CHR_ID
,      LTY_CODE
,      LSE_TYPE
,      LSE_PARENT_ID
,      PARENT_LINE_ID
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ASSET_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      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
,      RECOVERABLE_COST
,      ORG_ID
,      SET_OF_BOOKS_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      INVENTORIAL
,      LINE_STATUS
,      YEAR_BUILT
FROM APPS.OKL_VIEW_TRX_ASSETS_V;

Dependencies

[top of page]

APPS.OKL_VIEW_TRX_ASSETS_V references the following:

APPS: OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_LINE_STYLES_B; OKL_K_HEADERS; OKL_K_LINES; OKX_ASSETS_V

APPS.OKL_VIEW_TRX_ASSETS_V is referenced by following:

APPS: OKL_FA_TRX_LINE_UV; OKL_TRX_HEADER_UV