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

TABLE: GL.GL_INTERFACE_CONTROL

Object Details
Object Name: GL_INTERFACE_CONTROL
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_INTERFACE_CONTROL
Subobject Name:
Status: VALID


GL_INTERFACE_CONTROL is used to control Journal Import execution. Whenever you start Journal Import from the Import Journals form, a row is inserted into this table for each source and group id that you specified. When Journal Import completes, it deletes these rows from the table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_INTERFACE_CONTROL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_SOURCE_NAME
ColumnSET_OF_BOOKS_ID
ColumnINTERFACE_RUN_ID
Columns
Name Datatype Length Mandatory Comments
JE_SOURCE_NAME VARCHAR2 (25) Yes Journal entry source
STATUS VARCHAR2 (1) Yes Journal Import status
INTERFACE_RUN_ID NUMBER (15)
Journal Import process defining column
GROUP_ID NUMBER (15)
Interface group defining column
SET_OF_BOOKS_ID NUMBER (15)
Ledger defining column
PACKET_ID NUMBER (15)
Budgetary control packet defining column
INTERFACE_TABLE_NAME VARCHAR2 (30)
Journal Import interface table
PROCESSED_TABLE_CODE VARCHAR2 (1)
Indicates what should be done with the data once it has been processed
REQUEST_ID NUMBER (15)
Concurrent request defining column
Query Text

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


SELECT JE_SOURCE_NAME
,      STATUS
,      INTERFACE_RUN_ID
,      GROUP_ID
,      SET_OF_BOOKS_ID
,      PACKET_ID
,      INTERFACE_TABLE_NAME
,      PROCESSED_TABLE_CODE
,      REQUEST_ID
FROM GL.GL_INTERFACE_CONTROL;

Dependencies

[top of page]

GL.GL_INTERFACE_CONTROL does not reference any database object

GL.GL_INTERFACE_CONTROL is referenced by following:

SchemaGL
ViewGL_INTERFACE_CONTROL#