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


TABLE: IGI.IGI_INT_ARCH_REFS

Object Details
Object Name: IGI_INT_ARCH_REFS
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_INT_ARCH_REFS
Subobject Name:
Status: VALID


IGI_INT_ARCH_REFS archives Generic Interface data.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JE_BATCH_ID NUMBER
Yes Journal batch identifier
JE_HEADER_ID NUMBER
Yes Journal header identifier
JE_LINE_NUM NUMBER
Yes Journal line number
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REFERENCE_1 VARCHAR2 (240)
Journal Import Reference Column 1
REFERENCE_2 VARCHAR2 (240)
Journal Import Reference Column 2
REFERENCE_3 VARCHAR2 (240)
Journal Import Reference Column 3
REFERENCE_4 VARCHAR2 (240)
Journal Import Reference Column 4
REFERENCE_5 VARCHAR2 (240)
Journal Import Reference Column 5
REFERENCE_6 VARCHAR2 (240)
Journal Import Reference Column 6
REFERENCE_7 VARCHAR2 (240)
Journal Import Reference Column 7
REFERENCE_8 VARCHAR2 (240)
Journal Import Reference Column 8
REFERENCE_9 VARCHAR2 (240)
Journal Import Reference Column 9
REFERENCE_10 VARCHAR2 (240)
Journal Import Reference Column 10
SUBLEDGER_DOC_SEQUENCE_ID NUMBER

Sequence defining column
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

Sequence value
Query Text

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


SELECT JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
FROM IGI.IGI_INT_ARCH_REFS;

Dependencies

[top of page]

IGI.IGI_INT_ARCH_REFS does not reference any database object

IGI.IGI_INT_ARCH_REFS is referenced by following:

SchemaIGI
ViewIGI_INT_ARCH_REFS#