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

TABLE: GL.GL_EFC_CHANGED_TRX

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_EFC_CHANGED_TRX_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnNCU_SET_OF_BOOKS_ID
ColumnEURO_SET_OF_BOOKS_ID
ColumnAPPLICATION_ID
ColumnTABLE_NAME
ColumnPK_ID
ColumnPK_ID2
ColumnPK_ID3
Columns
Name Datatype Length Mandatory Comments
NCU_SET_OF_BOOKS_ID NUMBER (15) Yes NCU set of books defining column
EURO_SET_OF_BOOKS_ID NUMBER (15) Yes Euro set of books defining column
APPLICATION_ID NUMBER (15) Yes Application defining column
TABLE_NAME VARCHAR2 (30) Yes Table name
PK_ID NUMBER (15) Yes Transaction primary key value
PK_ID2 NUMBER (15)
Transaction primary key value
PK_ID3 NUMBER (15)
Transaction primary key value
ACTION_CODE VARCHAR2 (15) Yes Action required for reprocessing
REFERENCE1 VARCHAR2 (100)
EFC reference column
REFERENCE2 VARCHAR2 (100)
EFC reference column
REFERENCE3 VARCHAR2 (100)
EFC reference column
REFERENCE4 VARCHAR2 (100)
EFC reference column
REFERENCE5 VARCHAR2 (100)
EFC reference column
Query Text

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


SELECT NCU_SET_OF_BOOKS_ID
,      EURO_SET_OF_BOOKS_ID
,      APPLICATION_ID
,      TABLE_NAME
,      PK_ID
,      PK_ID2
,      PK_ID3
,      ACTION_CODE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
FROM GL.GL_EFC_CHANGED_TRX;

Dependencies

[top of page]

GL.GL_EFC_CHANGED_TRX does not reference any database object

GL.GL_EFC_CHANGED_TRX is referenced by following:

SchemaGL
ViewGL_EFC_CHANGED_TRX#