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

VIEW: APPS.FEM_DSNP_DIM_ATTR_VRS_V

Object Details
Object Name: FEM_DSNP_DIM_ATTR_VRS_V
Object Type: VIEW
Owner: APPS
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
CREATED_BY_OBJECT_ID NUMBER (9) Yes Identifies the Dimension Snapshot Object ID
ATTRIBUTE_ID NUMBER (9) Yes Identifies the attribute to which the version pertains
VERSION_DISPLAY_CODE VARCHAR2 (150) Yes Non translatable alphanumeric identifier for the version
DEFAULT_VERSION_FLAG VARCHAR2 (1) Yes A Y designates that the version is the default version
PERSONAL_FLAG VARCHAR2 (1) Yes This column is not current implemented
VERSION_ID NUMBER
Yes Attribute Version Identifier
VERSION_NAME VARCHAR2 (80) Yes Version Name
DESCRIPTION VARCHAR2 (255)
Description
CREATION_DATE DATE
Yes Identifies the date on which the version was created
CREATED_BY NUMBER
Yes Identifies the user that created the version
LAST_UPDATED_BY NUMBER
Yes Identifies the user that last updated the version
LAST_UPDATE_DATE DATE
Yes Identifies the data on which the version was last updated
LAST_UPDATE_LOGIN NUMBER

Identifies the login user that last updated the version
Query Text

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


SELECT CREATED_BY_OBJECT_ID
,      ATTRIBUTE_ID
,      VERSION_DISPLAY_CODE
,      DEFAULT_VERSION_FLAG
,      PERSONAL_FLAG
,      VERSION_ID
,      VERSION_NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.FEM_DSNP_DIM_ATTR_VRS_V;

Dependencies

[top of page]

APPS.FEM_DSNP_DIM_ATTR_VRS_V references the following:

SchemaAPPS
SynonymFEM_DIM_ATTR_VERSIONS_B
SynonymFEM_DSNP_DIM_ATTR_VRS_TL

APPS.FEM_DSNP_DIM_ATTR_VRS_V is not referenced by any database object