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

VIEW: APPS.FA_ASSET_HIERARCHY_PURPOSE_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ASSET_HIERARCHY_PURPOSE_ID NUMBER
Yes
NAME VARCHAR2 (30) Yes
PURPOSE_TYPE VARCHAR2 (30) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
DEFAULT_RULE_SET_ID NUMBER
Yes
DEFAULT_RULE_SET_NAME VARCHAR2 (30)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
DESCRIPTION VARCHAR2 (150)
MANDATORY_ASSET_FLAG VARCHAR2 (1)
RULE_SET_LEVEL VARCHAR2 (30) Yes
PERMISSIBLE_LEVELS NUMBER

Query Text

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


SELECT ROW_ID
,      ASSET_HIERARCHY_PURPOSE_ID
,      NAME
,      PURPOSE_TYPE
,      BOOK_TYPE_CODE
,      DEFAULT_RULE_SET_ID
,      DEFAULT_RULE_SET_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      MANDATORY_ASSET_FLAG
,      RULE_SET_LEVEL
,      PERMISSIBLE_LEVELS
FROM APPS.FA_ASSET_HIERARCHY_PURPOSE_V;

Dependencies

[top of page]

APPS.FA_ASSET_HIERARCHY_PURPOSE_V references the following:

SchemaAPPS
SynonymFA_ASSET_HIERARCHY_PURPOSE
SynonymFA_HIERARCHY_RULE_SET

APPS.FA_ASSET_HIERARCHY_PURPOSE_V is not referenced by any database object