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

TABLE: IGS.IGS_HE_EXT_RUN_PRMS

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


Holds the Extract Run Parameters details for each run while extracting data from the database


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_HE_EXT_RUN_PRMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_PRMS_ID
IGS_HE_EXT_RUN_PRMS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTRACT_RUN_ID
ColumnPARAM_TYPE
Columns
Name Datatype Length Mandatory Comments
RUN_PRMS_ID NUMBER
Yes Sequence generated column used to uniquely identify the Extract run parameters
EXTRACT_RUN_ID NUMBER
Yes Sequence generated column used to uniquely identify the extract run parameters
PARAM_TYPE VARCHAR2 (30) Yes Indicates the type of Parameter whose data we are trying to restrict
EXCLUDE VARCHAR2 (100)
Contains the value need to be excluded depending on the Parameter Type defined
ONLY VARCHAR2 (100)
Indicates the field for which the data will be extracted depending on the parameter type
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 RUN_PRMS_ID
,      EXTRACT_RUN_ID
,      PARAM_TYPE
,      EXCLUDE
,      ONLY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_EXT_RUN_PRMS;

Dependencies

[top of page]

IGS.IGS_HE_EXT_RUN_PRMS does not reference any database object

IGS.IGS_HE_EXT_RUN_PRMS is referenced by following:

SchemaAPPS
SynonymIGS_HE_EXT_RUN_PRMS