[Home] [Help] [Dependency Information]
Object Name: | GL_EFC_CHANGED_TRX |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_EFC_CHANGED_TRX |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_EFC_CHANGED_TRX_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
NCU_SET_OF_BOOKS_ID
EURO_SET_OF_BOOKS_ID APPLICATION_ID TABLE_NAME PK_ID PK_ID2 PK_ID3 |
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 |
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;
GL.GL_EFC_CHANGED_TRX does not reference any database object
GL.GL_EFC_CHANGED_TRX is referenced by following:
|
|
|