DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FAFV_ASSETS

Object Details
Object Name: FAFV_ASSETS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FAFV_ASSETS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows asset financial information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes
ASSET_NUMBER VARCHAR2 (15) Yes
_KF:CODE_COMBINATION CHAR (15)

CURRENT_UNITS NUMBER
Yes
ASSET_TYPE VARCHAR2 (11) Yes
TAG_NUMBER VARCHAR2 (15)

ASSET_DESCRIPTION VARCHAR2 (80)

PARENT_ASSET_ID NUMBER (15)

MANUFACTURER_NAME VARCHAR2 (360)

SERIAL_NUMBER VARCHAR2 (35)

MODEL_NUMBER VARCHAR2 (40)

PROPERTY_TYPE_CODE VARCHAR2 (10)

PROPERTY_1245_1250_CODE VARCHAR2 (4)

IN_USE_FLAG VARCHAR2 (3) Yes
OWNED_LEASED VARCHAR2 (15) Yes
NEW_USED VARCHAR2 (4) Yes
INVENTORIAL VARCHAR2 (3)

ASSET_CATEGORY_ID NUMBER (15) Yes
CATEGORY_DESCRIPTION VARCHAR2 (40)

LEASE_ID NUMBER (15)

LEASE_NUMBER VARCHAR2 (15)

DISTRIBUTION_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
Query Text

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


SELECT ASSET_ID
,      ASSET_NUMBER
,      _KF:CODE_COMBINATION
,      CURRENT_UNITS
,      ASSET_TYPE
,      TAG_NUMBER
,      ASSET_DESCRIPTION
,      PARENT_ASSET_ID
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      INVENTORIAL
,      ASSET_CATEGORY_ID
,      CATEGORY_DESCRIPTION
,      LEASE_ID
,      LEASE_NUMBER
,      DISTRIBUTION_ID
,      BOOK_TYPE_CODE
FROM APPS.FAFV_ASSETS;

Dependencies

[top of page]

APPS.FAFV_ASSETS references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_ASSET_KEYWORDS
SynonymFA_BOOKS
SynonymFA_CATEGORIES
SynonymFA_DISTRIBUTION_HISTORY
SynonymFA_LEASES

APPS.FAFV_ASSETS is not referenced by any database object