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_MAINT_VIEW

Object Details

Object Name:	FA_ASSET_MAINT_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_ASSET_MAINT_VIEW
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	Comments
ASSET_ID	NUMBER	(15)	Yes	Asset Identifier
ASSET_NUMBER	VARCHAR2	(15)	Yes	Asset Number
DESCRIPTION	VARCHAR2	(80)		Asset Description
TAG_NUMBER	VARCHAR2	(15)		Tag Number
ASSET_CATEGORY_ID	NUMBER	(15)	Yes	Asset Category Identifier
SERIAL_NUMBER	VARCHAR2	(35)		Asset Serial Number
ASSET_KEY_CCID	NUMBER	(15)		Asset Key Flexfield Combination Identifier
ASSET_TYPE	VARCHAR2	(11)	Yes	Asset Type
PARENT_ASSET_ID	NUMBER	(15)		Parent Asset Identifier
MANUFACTURER_NAME	VARCHAR2	(360)		Generic Brand or Manufacturer Name
MODEL_NUMBER	VARCHAR2	(40)		Model number
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Property type code
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Property code reserved for US Legislation
IN_USE_FLAG	VARCHAR2	(3)	Yes	Whether the asset is in use
OWNED_LEASED	VARCHAR2	(15)	Yes	Whether the asset is owned or leased
NEW_USED	VARCHAR2	(4)	Yes	Whether the asset is new or used
UNIT_ADJUSTMENT_FLAG	VARCHAR2	(3)	Yes	whether any adjustments were made to assigment units
ADD_COST_JE_FLAG	VARCHAR2	(3)	Yes	Whether addition related cost journal entries are required
CONTEXT	VARCHAR2	(210)		Descriptive Flexfield Context
LEASE_ID	NUMBER	(15)		Lease Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
INVENTORIAL	VARCHAR2	(3)		Whether the asset is inventorial
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book Type Code

Query Text

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


SELECT ASSET_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      TAG_NUMBER
,      ASSET_CATEGORY_ID
,      SERIAL_NUMBER
,      ASSET_KEY_CCID
,      ASSET_TYPE
,      PARENT_ASSET_ID
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      UNIT_ADJUSTMENT_FLAG
,      ADD_COST_JE_FLAG
,      CONTEXT
,      LEASE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      INVENTORIAL
,      BOOK_TYPE_CODE
FROM APPS.FA_ASSET_MAINT_VIEW;

Dependencies

[top of page]

APPS.FA_ASSET_MAINT_VIEW references the following:

APPS: FA_ADDITIONS; FA_BOOK_CONTROLS_SEC; FA_MAINT_EVENTS

APPS.FA_ASSET_MAINT_VIEW is not referenced by any database object