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

TABLE: IGS.IGS_SC_OBJ_ATT_MTHS

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


Table that stores the information related to Security User Attribute Values that are associated to the user attributes defined.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SC_OBJ_ATT_MTHS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnOBJECT_ID
ColumnOBJ_ATTRIB_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Yes Object identifier sequence created from FND_OBJECTS
OBJ_ATTRIB_ID NUMBER
Yes Object attribute identifier sequence created from IGS_SC_OBJ_ATTRIBS
OBJ_ATTRIB_TYPE VARCHAR2 (1) Yes Object attribute type
STATIC_TYPE VARCHAR2 (1) Yes Static type
SELECT_TEXT VARCHAR2 (4000) Yes Select statement text
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
NULL_ALLOW_FLAG VARCHAR2 (1) Yes Identify the Object attributes that will not result zero number of rows.
Query Text

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


SELECT OBJECT_ID
,      OBJ_ATTRIB_ID
,      OBJ_ATTRIB_TYPE
,      STATIC_TYPE
,      SELECT_TEXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NULL_ALLOW_FLAG
FROM IGS.IGS_SC_OBJ_ATT_MTHS;

Dependencies

[top of page]

IGS.IGS_SC_OBJ_ATT_MTHS does not reference any database object

IGS.IGS_SC_OBJ_ATT_MTHS is referenced by following:

SchemaAPPS
SynonymIGS_SC_OBJ_ATT_MTHS