View: GL_CONSOLIDATION_HISTORY_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_CONSOLIDATION_HISTORY_V

View Text

SELECT GL_CS.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, GL_CS.NAME CONSOLIDATION_SET_NAME
, C.CONSOLIDATION_ID CONSOLIDATION_ID
, C.NAME CONSOLIDATION_NAME
, M.COA_MAPPING_ID MAPPING_ID
, M.NAME MAPPING_NAME
, LEDGER1.LEDGER_ID FROM_LEDGER_ID
, LEDGER2.LEDGER_ID TO_LEDGER_ID
, GL_FC_XLATE_PKG.GET_LEDGER_NAME(LEDGER1.NAME
, LEDGER1.LEDGER_ID
, C.FROM_CURRENCY_CODE) FROM_LEDGER_NAME
, LEDGER2.NAME TO_LEDGER_NAME
, LEDGER2.CHART_OF_ACCOUNTS_ID TO_CHART_OF_ACCOUNTS_ID
, HIS.ACTUAL_FLAG ACTUAL_FLAG
, NVL(HIS.STATUS
, 'NT') STATUS_CODE
, NVL(HIS.OBSOLETE_CONSOLIDATION_FLAG
, 'N') OBSOLETE_CONSOLIDATION_FLAG
, FLV.MEANING OBSOLETE_CONSOLIDATION_STATUS
, HIS.REQUEST_ID REQ_ID
, LEDGER2.CURRENCY_CODE TO_CURRENCY_CODE
, LEDGER1.CURRENCY_CODE FROM_CURRENCY_CODE
, HIS.FROM_PERIOD_NAME FROM_PERIOD_NAME
, C.METHOD METHOD_FLAG
, HIS.FROM_BUDGET_NAME SOURCE_BUDGET
, HIS.TO_BUDGET_NAME TARGET_BUDGET
, HIS.FROM_BUDGET_VERSION_ID SOURCE_BUDGET_VERSION_ID
, HIS.TO_BUDGET_VERSION_ID TARGET_BUDGET_VERSION_ID
, C.DESCRIPTION CONSOLIDATION_DESCRIPTION
, GL_CS.DESCRIPTION CONSOLIDATION_SET_DESCRIPTION
, M.DESCRIPTION MAPPING_DESCRIPTION
, HIS.TO_PERIOD_NAME TO_PERIOD_NAME
, HIS.JE_BATCH_ID JE_BATCH_ID
, JB.CONTROL_TOTAL JB_CONTROL_TOTAL
, JB.RUNNING_TOTAL_DR JB_RUNNING_TOTAL_DR
, JB.RUNNING_TOTAL_CR JB_RUNNING_TOTAL_CR
, JB.ROWID JB_ROW_ID
, JB.CHART_OF_ACCOUNTS_ID JB_CHART_OF_ACCOUNTS_ID
, JB.NAME JB_NAME
, JB.STATUS JB_STATUS
, JB.STATUS_VERIFIED JB_STATUS_VERIFIED
, JB.ACTUAL_FLAG JB_ACTUAL_FLAG
, JB.BUDGETARY_CONTROL_STATUS JB_BUDGETARY_CONTROL_STATUS
, JB.DEFAULT_PERIOD_NAME JB_DEFAULT_PERIOD_NAME
, JB.POSTING_RUN_ID JB_POSTING_RUN_ID
, JB.REQUEST_ID JB_REQUEST_ID
, JB.APPROVAL_STATUS_CODE JB_APPROVAL_STATUS_CODE
, JB.LAST_UPDATE_DATE JB_LAST_UPDATE_DATE
, JB.LAST_UPDATED_BY JB_LAST_UPDATED_BY
, JB.LAST_UPDATE_LOGIN JB_LAST_UPDATE_LOGIN
, HIS.ROWID ROW_ID
, HIS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HIS.LAST_UPDATED_BY LAST_UPDATED_BY
, HIS.CONSOLIDATION_RUN_ID CONSOLIDATION_RUN_ID
FROM GL_JE_BATCHES JB
, (SELECT *
FROM GL_CONSOLIDATION_HISTORY
WHERE STATUS IS NOT NULL) HIS
, GL_CONSOLIDATION_SETS GL_CS
, GL_CONSOLIDATION C
, GL_COA_MAPPINGS M
, GL_LEDGERS LEDGER1
, GL_LEDGERS LEDGER2
, FND_LOOKUP_VALUES FLV
WHERE C.FROM_LEDGER_ID = LEDGER1.LEDGER_ID AND C.TO_LEDGER_ID = LEDGER2.LEDGER_ID AND HIS.CONSOLIDATION_ID(+) = C.CONSOLIDATION_ID+0
AND HIS.TO_PERIOD_NAME(+) = GL_CONS_WRK_PKG.GET_PERIOD AND GL_CS.CONSOLIDATION_SET_ID(+) = HIS.CONSOLIDATION_SET_ID
AND JB.JE_BATCH_ID(+) = HIS.JE_BATCH_ID
AND EXISTS (SELECT 1
FROM GL_ACCESS_SET_LEDGERS GL_ASL
WHERE GL_ASL.ACCESS_SET_ID = GL_CONS_WRK_PKG.GET_ACCESS_SET_ID
AND GL_ASL.LEDGER_ID IN (C.FROM_LEDGER_ID
, C.TO_LEDGER_ID)) AND FLV.LOOKUP_TYPE = 'OBSOLETE_CONSOLIDATION_STATUS' AND FLV.LANGUAGE = USERENV('LANG') AND FLV.LOOKUP_CODE = NVL(HIS.OBSOLETE_CONSOLIDATION_FLAG
, 'N') AND C.COA_MAPPING_ID = M.COA_MAPPING_ID

Columns