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

Object Details

Object Name:	FA_ASSET_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_ASSET_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ASSET_NUMBER	VARCHAR2	(15)	Yes
TAG_NUMBER	VARCHAR2	(15)
DESCRIPTION	VARCHAR2	(80)
MANUFACTURER_NAME	VARCHAR2	(30)
SERIAL_NUMBER	VARCHAR2	(35)
MODEL_NUMBER	VARCHAR2	(40)
MAJOR_CATEGORY	VARCHAR2	(30)
SUB_CATEGORY	VARCHAR2	(30)
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
DATE_PLACED_IN_SERVICE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
COST	NUMBER		Yes
SALVAGE_VALUE	NUMBER		Yes
ADJUSTED_RATE	NUMBER
PRODUCTION_CAPACITY	NUMBER

Query Text

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


SELECT ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      MAJOR_CATEGORY
,      SUB_CATEGORY
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      COST
,      SALVAGE_VALUE
,      ADJUSTED_RATE
,      PRODUCTION_CAPACITY
FROM APPS.FA_ASSET_V;

Dependencies

[top of page]

APPS.FA_ASSET_V references the following:

APPS: FA_ADDITIONS; FA_BOOKS; FA_BOOK_CONTROLS; FA_CATEGORIES_B

APPS.FA_ASSET_V is not referenced by any database object