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]

VIEW: APPS.GL_CONSOLIDATION_HISTORY_V

Object Details

Object Name:	GL_CONSOLIDATION_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_CONSOLIDATION_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONSOLIDATION_SET_ID	NUMBER	(15)		Consolidation set defining column
CONSOLIDATION_SET_NAME	VARCHAR2	(30)		Consolidation set name
CONSOLIDATION_ID	NUMBER	(15)	Yes	Consolidation defining column
CONSOLIDATION_NAME	VARCHAR2	(33)	Yes	Consolidation name
MAPPING_ID	NUMBER	(15)	Yes
MAPPING_NAME	VARCHAR2	(33)	Yes
FROM_LEDGER_ID	NUMBER	(15)	Yes
TO_LEDGER_ID	NUMBER	(15)	Yes
FROM_LEDGER_NAME	VARCHAR2	(4000)
TO_LEDGER_NAME	VARCHAR2	(30)	Yes
TO_CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
ACTUAL_FLAG	VARCHAR2	(1)
STATUS_CODE	VARCHAR2	(2)
OBSOLETE_CONSOLIDATION_FLAG	VARCHAR2	(1)
OBSOLETE_CONSOLIDATION_STATUS	VARCHAR2	(80)	Yes
REQ_ID	NUMBER	(15)
TO_CURRENCY_CODE	VARCHAR2	(15)	Yes
FROM_CURRENCY_CODE	VARCHAR2	(15)	Yes
FROM_PERIOD_NAME	VARCHAR2	(15)
METHOD_FLAG	VARCHAR2	(1)
SOURCE_BUDGET	VARCHAR2	(15)
TARGET_BUDGET	VARCHAR2	(15)
SOURCE_BUDGET_VERSION_ID	NUMBER	(15)
TARGET_BUDGET_VERSION_ID	NUMBER	(15)
CONSOLIDATION_DESCRIPTION	VARCHAR2	(240)
CONSOLIDATION_SET_DESCRIPTION	VARCHAR2	(240)
MAPPING_DESCRIPTION	VARCHAR2	(240)
TO_PERIOD_NAME	VARCHAR2	(15)
JE_BATCH_ID	NUMBER	(15)
JB_CONTROL_TOTAL	NUMBER
JB_RUNNING_TOTAL_DR	NUMBER
JB_RUNNING_TOTAL_CR	NUMBER
JB_ROW_ID	ROWID	(10)
JB_CHART_OF_ACCOUNTS_ID	NUMBER	(15)
JB_NAME	VARCHAR2	(100)
JB_STATUS	VARCHAR2	(1)
JB_STATUS_VERIFIED	VARCHAR2	(1)
JB_ACTUAL_FLAG	VARCHAR2	(1)
JB_BUDGETARY_CONTROL_STATUS	VARCHAR2	(1)
JB_DEFAULT_PERIOD_NAME	VARCHAR2	(15)
JB_POSTING_RUN_ID	NUMBER	(15)
JB_REQUEST_ID	NUMBER	(15)
JB_APPROVAL_STATUS_CODE	VARCHAR2	(1)
JB_LAST_UPDATE_DATE	DATE
JB_LAST_UPDATED_BY	NUMBER	(15)
JB_LAST_UPDATE_LOGIN	NUMBER	(15)
ROW_ID	ROWID	(10)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
CONSOLIDATION_RUN_ID	NUMBER	(15)

Query Text

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


SELECT CONSOLIDATION_SET_ID
,      CONSOLIDATION_SET_NAME
,      CONSOLIDATION_ID
,      CONSOLIDATION_NAME
,      MAPPING_ID
,      MAPPING_NAME
,      FROM_LEDGER_ID
,      TO_LEDGER_ID
,      FROM_LEDGER_NAME
,      TO_LEDGER_NAME
,      TO_CHART_OF_ACCOUNTS_ID
,      ACTUAL_FLAG
,      STATUS_CODE
,      OBSOLETE_CONSOLIDATION_FLAG
,      OBSOLETE_CONSOLIDATION_STATUS
,      REQ_ID
,      TO_CURRENCY_CODE
,      FROM_CURRENCY_CODE
,      FROM_PERIOD_NAME
,      METHOD_FLAG
,      SOURCE_BUDGET
,      TARGET_BUDGET
,      SOURCE_BUDGET_VERSION_ID
,      TARGET_BUDGET_VERSION_ID
,      CONSOLIDATION_DESCRIPTION
,      CONSOLIDATION_SET_DESCRIPTION
,      MAPPING_DESCRIPTION
,      TO_PERIOD_NAME
,      JE_BATCH_ID
,      JB_CONTROL_TOTAL
,      JB_RUNNING_TOTAL_DR
,      JB_RUNNING_TOTAL_CR
,      JB_ROW_ID
,      JB_CHART_OF_ACCOUNTS_ID
,      JB_NAME
,      JB_STATUS
,      JB_STATUS_VERIFIED
,      JB_ACTUAL_FLAG
,      JB_BUDGETARY_CONTROL_STATUS
,      JB_DEFAULT_PERIOD_NAME
,      JB_POSTING_RUN_ID
,      JB_REQUEST_ID
,      JB_APPROVAL_STATUS_CODE
,      JB_LAST_UPDATE_DATE
,      JB_LAST_UPDATED_BY
,      JB_LAST_UPDATE_LOGIN
,      ROW_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CONSOLIDATION_RUN_ID
FROM APPS.GL_CONSOLIDATION_HISTORY_V;

Dependencies

[top of page]

APPS.GL_CONSOLIDATION_HISTORY_V references the following:

APPS: FND_LOOKUP_VALUES; GL_ACCESS_SET_LEDGERS; GL_COA_MAPPINGS; GL_CONSOLIDATION; GL_CONSOLIDATION_HISTORY; GL_CONSOLIDATION_SETS; GL_CONS_WRK_PKG - show dependent code; GL_FC_XLATE_PKG - show dependent code; GL_JE_BATCHES; GL_LEDGERS

APPS.GL_CONSOLIDATION_HISTORY_V is not referenced by any database object