eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GL.GL_CONSOLIDATION_HISTORY

Object Details

Object Name:	GL_CONSOLIDATION_HISTORY
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_CONSOLIDATION_HISTORY
Subobject Name:
Status:	VALID

GL_CONSOLIDATION_HISTORY stores information about the transferred consolidation data. One row is inserted into this table for each transfer of consolidation data.
FROM_PERIOD_NAME is the subsidiary's accounting period name. TO_PERIOD_NAME is the parent's accounting period name. ACTUAL_FLAG is 'A' when actual amounts are transferred and 'B' budget amounts are transferred.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_CONSOLIDATION_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TO_PERIOD_NAME CONSOLIDATION_RUN_ID
GL_CONSOLIDATION_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSOLIDATION_RUN_ID
GL_CONSOLIDATION_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID
GL_CONSOLIDATION_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_BATCH_ID
GL_CONSOLIDATION_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSOLIDATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONSOLIDATION_RUN_ID	NUMBER	(15)	Yes	Consolidation run process defining column
CONSOLIDATION_ID	NUMBER	(15)	Yes	Consolidation defining column
FROM_PERIOD_NAME	VARCHAR2	(15)	Yes	Subsidiary period name
TO_PERIOD_NAME	VARCHAR2	(15)	Yes	Parent period name
TO_CURRENCY_CODE	VARCHAR2	(15)	Yes	Parent currency
METHOD_FLAG	VARCHAR2	(1)	Yes	Consolidation method (Balances, Transactions)
RUN_EASYLINK_FLAG	VARCHAR2	(1)	Yes	Submit Journal Import process
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type lookup (Actual, Budget, or Encumbrance)
AVERAGE_CONSOLIDATION_FLAG	VARCHAR2	(1)	Yes	Average consolidation flag
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
FROM_BUDGET_NAME	VARCHAR2	(15)		Subsidiary budget name
FROM_BUDGET_VERSION_ID	NUMBER	(15)		Subsidiary budget defining column
TO_BUDGET_NAME	VARCHAR2	(15)		Parent budget name
TO_BUDGET_VERSION_ID	NUMBER	(15)		Parent budget defining column
AMOUNT_TYPE	VARCHAR2	(30)		Amount type consolidated
FROM_DATE	DATE			Subsidiary effective date
AVERAGE_TO_PERIOD_NAME	VARCHAR2	(15)		Parent period name for average journals
CONSOLIDATION_SET_ID	NUMBER	(15)		Consolidation set defining column
OBSOLETE_CONSOLIDATION_FLAG	VARCHAR2	(1)		Flag which indicates whether the current consolidation transfer is obsolete
STATUS	VARCHAR2	(2)		Consolidation status
REQUEST_ID	NUMBER	(15)		Id of the request currently processing this consolidation run (or journal batch)
GROUP_ID	NUMBER	(15)		Group id of the consolidation data in journal import
JE_BATCH_ID	NUMBER	(15)		Defining column of the consolidation batch produced by journal import
RUN_POSTING_FLAG	VARCHAR2	(1)		Run journal posting flag
TARGET_USER_NAME	VARCHAR2	(30)		User name in target database.
TARGET_RESP_NAME	VARCHAR2	(100)		Responsibility name in target database
TARGET_DATABASE_NAME	VARCHAR2	(30)		Target database name

Query Text

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


SELECT CONSOLIDATION_RUN_ID
,      CONSOLIDATION_ID
,      FROM_PERIOD_NAME
,      TO_PERIOD_NAME
,      TO_CURRENCY_CODE
,      METHOD_FLAG
,      RUN_EASYLINK_FLAG
,      ACTUAL_FLAG
,      AVERAGE_CONSOLIDATION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FROM_BUDGET_NAME
,      FROM_BUDGET_VERSION_ID
,      TO_BUDGET_NAME
,      TO_BUDGET_VERSION_ID
,      AMOUNT_TYPE
,      FROM_DATE
,      AVERAGE_TO_PERIOD_NAME
,      CONSOLIDATION_SET_ID
,      OBSOLETE_CONSOLIDATION_FLAG
,      STATUS
,      REQUEST_ID
,      GROUP_ID
,      JE_BATCH_ID
,      RUN_POSTING_FLAG
,      TARGET_USER_NAME
,      TARGET_RESP_NAME
,      TARGET_DATABASE_NAME
FROM GL.GL_CONSOLIDATION_HISTORY;

Dependencies

[top of page]

GL.GL_CONSOLIDATION_HISTORY does not reference any database object

GL.GL_CONSOLIDATION_HISTORY is referenced by following:

APPS: GL_CONSOLIDATION_HISTORY