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: ViewOFA.FA_ASSET_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view contains asset identification and financial
information. To access category information, update
the view definition with the appropriate segment
number for you flexfields.
Oracle Assets standard modules do not use this view.


[View Source]

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

Refer to base table
PRODUCTION_CAPACITY NUMBER

Refer to base table
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:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_BOOKS
SynonymFA_BOOK_CONTROLS
SynonymFA_CATEGORIES_B

APPS.FA_ASSET_V is not referenced by any database object