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

TABLE: IGS.IGS_EN_MRG_ID_ACT_CH

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


IGS_EN_MRG_ID_ACT_CH contains the possible actions than can be applied to a row in the merge ID process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_EN_MRG_ID_ACT_CH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSMIR_ID
ColumnTABLE_ALIAS
ColumnACTION_ID
Columns
Name Datatype Length Mandatory Comments
SMIR_ID NUMBER (6) Yes Contains the unique identifier for a row containing the information to which an action is to be applied for the rows identified in the merge ID process.
TABLE_ALIAS VARCHAR2 (10) Yes Contains the table alias of the table involved in the merge ID process.
ACTION_ID NUMBER (2) Yes Contains the action identifier
PERFORM_ACTION_IND VARCHAR2 (1) Yes Indicates that the action is to be performed.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
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
Query Text

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


SELECT SMIR_ID
,      TABLE_ALIAS
,      ACTION_ID
,      PERFORM_ACTION_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_MRG_ID_ACT_CH;

Dependencies

[top of page]

IGS.IGS_EN_MRG_ID_ACT_CH does not reference any database object

IGS.IGS_EN_MRG_ID_ACT_CH is referenced by following:

SchemaAPPS
SynonymIGS_EN_MRG_ID_ACT_CH