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

TABLE: GL.GL_XFR_SYSTEM_LEDGERS

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


Stores the list of Fusion Ledgers with their corresponding BSV assignment type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_XFR_SYSTEM_LEDGERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_MAP_ID
ColumnLEDGER_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_MAP_ID NUMBER (18) Yes This is referenced from system_map_id in GL_XFR_SOURCE_SYSTEMS
LEDGER_ID NUMBER (18) Yes Ledger for which assignment is being done
BSV_ASSIGNMENT_TYPE VARCHAR2 (90) Yes Can only have values 'A'(All) or 'S'(Specific) 'A'-Indicates all the balancing segments in the Fusion Ledger can be used to book balances by external instance. 'S'-Indicates only specific balancing segments in the Fusion Ledger can be used to book balances by external instance.
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
SYSTEM_LEDGER_MAP_ID NUMBER (18) Yes Sequence generated unique number
Query Text

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


SELECT SYSTEM_MAP_ID
,      LEDGER_ID
,      BSV_ASSIGNMENT_TYPE
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SYSTEM_LEDGER_MAP_ID
FROM GL.GL_XFR_SYSTEM_LEDGERS;

Dependencies

[top of page]

GL.GL_XFR_SYSTEM_LEDGERS does not reference any database object

GL.GL_XFR_SYSTEM_LEDGERS is referenced by following:

SchemaGL
ViewGL_XFR_SYSTEM_LEDGERS#