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

TABLE: IGS.IGS_HE_EX_RN_DAT_FD

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


Determines the field level details of each extract line comes from the Extract run process


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_HE_EX_RN_DAT_FD_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTRACT_RUN_ID
ColumnLINE_NUMBER
ColumnFIELD_NUMBER
IGS_HE_EX_RN_DAT_FD_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRN_DAT_FD_ID
Columns
Name Datatype Length Mandatory Comments
RN_DAT_FD_ID NUMBER
Yes Sequence generated column used to uniquely identify the Extract run data fields
EXTRACT_RUN_ID NUMBER
Yes Sequence generated column used to uniquely identify the extract process
LINE_NUMBER NUMBER
Yes Indicates the Line Number after the extraction process
FIELD_NUMBER NUMBER
Yes Indicates the Field Number after extraction process
VALUE VARCHAR2 (100)
Holds the Value of the extracted field
OVERRIDE_VALUE VARCHAR2 (100)
Contains the overridden value, if the value is overridden after extraction process is complete
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 RN_DAT_FD_ID
,      EXTRACT_RUN_ID
,      LINE_NUMBER
,      FIELD_NUMBER
,      VALUE
,      OVERRIDE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_EX_RN_DAT_FD;

Dependencies

[top of page]

IGS.IGS_HE_EX_RN_DAT_FD does not reference any database object

IGS.IGS_HE_EX_RN_DAT_FD is referenced by following:

SchemaAPPS
SynonymIGS_HE_EX_RN_DAT_FD