View: GL_JE_CONS_BALANCES_V

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

View Text

SELECT BA.LEDGER_ID LEDGER_ID
, BA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TO_NUMBER(IR.REFERENCE_1) CONSOLIDATION_ID
, BA.PERIOD_NAME PERIOD_NAME
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.BUDGET_VERSION_ID BUDGET_VERSION_ID
, DECODE(BA.TEMPLATE_ID
, NULL
, BA.TRANSLATED_FLAG
, DECODE(BA.CURRENCY_CODE
, L.CURRENCY_CODE
, BA.TRANSLATED_FLAG
, DECODE(BA.TRANSLATED_FLAG
, NULL
, 'Y'
, BA.TRANSLATED_FLAG))) TRANSLATED_FLAG
, BA.TEMPLATE_ID TEMPLATE_ID
, IR.JE_BATCH_ID JE_BATCH_ID
, IR.JE_HEADER_ID JE_HEADER_ID
, IR.JE_LINE_NUM JE_LINE_NUM
, IR.REFERENCE_9 AMOUNT_TYPE
, TO_NUMBER(IR.REFERENCE_10
, '99999999999999999999.99999999999999999999') /GLR03300_PKG.GET_FACTOR CONSOLIDATED_AMOUNT
, /* * PTD */ (NVL(BA.PERIOD_NET_DR
, 0) - NVL(BA.PERIOD_NET_CR
, 0)) / GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_TO_DATE
, /* * QTD */ ((NVL(BA.QUARTER_TO_DATE_DR
, 0) - NVL(BA.QUARTER_TO_DATE_CR
, 0)) + (NVL(BA.PERIOD_NET_DR
, 0) - NVL(BA.PERIOD_NET_CR
, 0))) / GLR03300_PKG.GET_FACTOR ENTERED_QUARTER_TO_DATE
, /* * YTD */ ((NVL(BA.BEGIN_BALANCE_DR
, 0) - NVL(BA.BEGIN_BALANCE_CR
, 0)) + (NVL(BA.PERIOD_NET_DR
, 0) - NVL(BA.PERIOD_NET_CR
, 0))) / GLR03300_PKG.GET_FACTOR ENTERED_YEAR_TO_DATE
, /* * PJTD */ ((NVL(BA.PROJECT_TO_DATE_DR
, 0) - NVL(BA.PROJECT_TO_DATE_CR
, 0)) + (NVL(BA.PERIOD_NET_DR
, 0) - NVL(BA.PERIOD_NET_CR
, 0))) / GLR03300_PKG.GET_FACTOR ENTERED_PROJECT_TO_DATE
, BA.ROWID ROW_ID
, BA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY LAST_UPDATED_BY
, BA.ACTUAL_FLAG ACTUAL_FLAG FROM GL_BALANCES BA
, GL_IMPORT_REFERENCES IR
, GL_LEDGERS L
WHERE BA.LEDGER_ID = IR.REFERENCE_7
AND BA.CODE_COMBINATION_ID = IR.REFERENCE_3 AND BA.PERIOD_NAME = IR.REFERENCE_8
AND DECODE (BA.TRANSLATED_FLAG
, 'Y'
, 'T'
, 'N'
, 'T'
, 'E') = NVL(IR.REFERENCE_4
, 'E')
AND NVL(BA.BUDGET_VERSION_ID
, -100) = NVL(IR.REFERENCE_5
, -100)
AND L.LEDGER_ID = BA.LEDGER_ID

Columns