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

TABLE: GL.GL_XFR_LEDGER_BSV_MAPS

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


Stores specific Balancing segment values of a Fusion Ledger that can be used for booking balances by the external instances.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_XFR_LEDGER_BSV_MAPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_MAP_ID
ColumnLEDGER_ID
ColumnBALANCING_SEGMENT_VALUE
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 This is referenced from ledger_id in GL_XFR_SOURCE_SYSTEMS
BALANCING_SEGMENT_VALUE VARCHAR2 (75) Yes Balancing segment value assigned to the ledger
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
LEDGER_BSV_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
,      BALANCING_SEGMENT_VALUE
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LEDGER_BSV_MAP_ID
FROM GL.GL_XFR_LEDGER_BSV_MAPS;

Dependencies

[top of page]

GL.GL_XFR_LEDGER_BSV_MAPS does not reference any database object

GL.GL_XFR_LEDGER_BSV_MAPS is referenced by following:

SchemaGL
ViewGL_XFR_LEDGER_BSV_MAPS#