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

TABLE: GL.GL_XFR_SOURCE_SYSTEMS

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


Stores the list of External Instances with URL info that will be used to drill down from Fusion GL balances to the external instance


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_XFR_SOURCE_SYSTEMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_MAP_ID NUMBER (18) Yes Sequence generated unique number
SYSTEM_ID NUMBER (18) Yes System Id that is configured in the gl_system_usages of an EBS Instance
NAME VARCHAR2 (90) Yes Name
JE_SOURCE_KEY VARCHAR2 (75) Yes This will indicate the journal source for an external instance
DESCRIPTION VARCHAR2 (720)
Description
DRILLDOWN_URL VARCHAR2 (3000)
External Instance URL
OBJECT_VERSION_NUMBER NUMBER (9) Yes Used for locking rows in database
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY VARCHAR2 (192) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY VARCHAR2 (192) Yes Standard Who Column
LAST_UPDATE_LOGIN VARCHAR2 (96)
Standard Who Column
Query Text

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


SELECT SYSTEM_MAP_ID
,      SYSTEM_ID
,      NAME
,      JE_SOURCE_KEY
,      DESCRIPTION
,      DRILLDOWN_URL
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GL.GL_XFR_SOURCE_SYSTEMS;

Dependencies

[top of page]

GL.GL_XFR_SOURCE_SYSTEMS does not reference any database object

GL.GL_XFR_SOURCE_SYSTEMS is referenced by following:

SchemaGL
ViewGL_XFR_SOURCE_SYSTEMS#