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

TABLE: FEM.FEM_USER_LOV17_B

Object Details
Object Name: FEM_USER_LOV17_B
Object Type: TABLE
Owner: FEM
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_USER_LOV17_B_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_LOV17_CODE
Columns
Name Datatype Length Mandatory Comments
USER_LOV17_CODE VARCHAR2 (30) Yes Code identifying the dimension member
ENABLED_FLAG VARCHAR2 (1) Yes Designates whether or not the dimension member is enabled
PERSONAL_FLAG VARCHAR2 (1) Yes Designates whether or not the dimension member is a personal member only available to the Created By user
CREATION_DATE DATE
Yes Designates the date on which the dimension member was created
CREATED_BY NUMBER (15) Yes Identifies the user that created the dimension member
LAST_UPDATED_BY NUMBER (15) Yes Identifies the user that last updated the dimension member
LAST_UPDATE_DATE DATE
Yes Designates the last date on which the dimension member was updated
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login that last updated the dimension member
OBJECT_VERSION_NUMBER NUMBER
Yes Framework required column for stale data detection
READ_ONLY_FLAG VARCHAR2 (1) Yes Designates whether or not the dimension member is updatable
Query Text

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


SELECT USER_LOV17_CODE
,      ENABLED_FLAG
,      PERSONAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      READ_ONLY_FLAG
FROM FEM.FEM_USER_LOV17_B;

Dependencies

[top of page]

FEM.FEM_USER_LOV17_B does not reference any database object

FEM.FEM_USER_LOV17_B is referenced by following:

SchemaAPPS
SynonymFEM_USER_LOV17_B