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

TABLE: IGS.IGS_SC_USR_ATTRIBS

Object Details
Object Name: IGS_SC_USR_ATTRIBS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_SC_USR_ATTRIBS
Subobject Name:
Status: VALID


Table that stores the information related to Security User Attributes


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SC_USR_ATTRIBS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnUSER_ATTRIB_ID
IGS_SC_USR_ATTRIBS_UK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnUSER_ATTRIB_NAME
Columns
Name Datatype Length Mandatory Comments
USER_ATTRIB_ID NUMBER
Yes User attribute identifier generated from sequence.
USER_ATTRIB_NAME VARCHAR2 (260) Yes User attribute name defined by user
USER_ATTRIB_TYPE VARCHAR2 (1) Yes User attribute type
STATIC_TYPE VARCHAR2 (1) Yes Static type
SELECT_TEXT VARCHAR2 (4000) Yes Select statement text string
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ACTIVE_FLAG VARCHAR2 (1) Yes Identifies the no longer used user attributes.
Query Text

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


SELECT USER_ATTRIB_ID
,      USER_ATTRIB_NAME
,      USER_ATTRIB_TYPE
,      STATIC_TYPE
,      SELECT_TEXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACTIVE_FLAG
FROM IGS.IGS_SC_USR_ATTRIBS;

Dependencies

[top of page]

IGS.IGS_SC_USR_ATTRIBS does not reference any database object

IGS.IGS_SC_USR_ATTRIBS is referenced by following:

SchemaAPPS
SynonymIGS_SC_USR_ATTRIBS