View: GL_VARIANCE_BALANCES_V

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

View Text

SELECT BA.LEDGER_ID LEDGER_ID
, BA.PERIOD_NAME PERIOD_NAME
, BA.PERIOD_YEAR PERIOD_YEAR
, BA.PERIOD_NUM PERIOD_NUM
, BA.ROWID ROW_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, BA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, BA.ACTUAL_FLAG ACTUAL_FLAG
, BA.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, BA.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BA.TRANSLATED_FLAG TRANSLATED_FLAG
, BA.TEMPLATE_ID TEMPLATE_ID
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, NVL ( BA.PERIOD_NET_DR_BEQ
, 0 )
, NVL ( BA.PERIOD_NET_DR
, 0 ) )
, NVL ( BA.PERIOD_NET_DR
, 0 ) )
, NVL ( BA.PERIOD_NET_DR
, 0 ) ) ) /GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_NET_DR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_PERIOD_NET_DR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, NVL ( BA.PERIOD_NET_CR_BEQ
, 0 )
, NVL ( BA.PERIOD_NET_CR
, 0 ) )
, NVL ( BA.PERIOD_NET_CR
, 0 ) )
, NVL ( BA.PERIOD_NET_CR
, 0 ) ) ) /GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_NET_CR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_PERIOD_NET_CR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, ( ( NVL ( BA.QUARTER_TO_DATE_DR_BEQ
, 0 ) -NVL ( BA.QUARTER_TO_DATE_CR_BEQ
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) -NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) )
, ( ( 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 ) ) ) )
, ( ( 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 ) ) ) )
, ( ( 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
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, ( ( NVL ( BA.PROJECT_TO_DATE_DR_BEQ
, 0 ) -NVL ( BA.PROJECT_TO_DATE_CR_BEQ
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) -NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) )
, ( ( 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 ) ) ) )
, ( ( 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 ) ) ) )
, ( ( 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
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, ( ( NVL ( BA.BEGIN_BALANCE_DR_BEQ
, 0 ) -NVL ( BA.BEGIN_BALANCE_CR_BEQ
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) -NVL ( PERIOD_NET_CR_BEQ
, 0 ) ) )
, ( ( NVL ( BA.BEGIN_BALANCE_DR
, 0 ) -NVL ( BA.BEGIN_BALANCE_CR
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR
, 0 ) -NVL ( PERIOD_NET_CR
, 0 ) ) ) )
, ( ( NVL ( BA.BEGIN_BALANCE_DR
, 0 ) - NVL ( BA.BEGIN_BALANCE_CR
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR
, 0 ) - NVL ( BA.PERIOD_NET_CR
, 0 ) ) ) )
, ( ( 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
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, ( NVL ( BA.BEGIN_BALANCE_DR_BEQ
, 0 ) - NVL ( BA.BEGIN_BALANCE_CR_BEQ
, 0 ) ) + ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) - NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_YEAR_TO_DATE
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) -NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) )
, ( NVL ( BA.PERIOD_NET_DR
, 0 ) -NVL ( BA.PERIOD_NET_CR
, 0 ) ) )
, ( NVL ( BA.PERIOD_NET_DR
, 0 ) -NVL ( BA.PERIOD_NET_CR
, 0 ) ) )
, ( NVL ( BA.PERIOD_NET_DR
, 0 ) - NVL ( BA.PERIOD_NET_CR
, 0 ) ) ) ) /GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_TO_DATE
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) - NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_PERIOD_TO_DATE
FROM GL_BALANCES BA
, GL_LEDGERS LED
WHERE DECODE ( BA.TRANSLATED_FLAG
, 'R'
, 'R'
, 'Y'
, 'Y'
, 'N'
, 'Y'
, NULL
, DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, 'R'
, 'X')
, 'S'
, 'S'
, 'T'
, DECODE ( BA.CURRENCY_CODE
, 'STAT'
, 'X'
, 'Y') ) ) = DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, 'R'
, 'S'
, 'S'
, 'T'
, 'Y')
AND NVL ( BA.BUDGET_VERSION_ID
, -100 ) = NVL ( GLR03300_PKG.GET_BUDGET_VERSION_ID
, -100 )
AND NVL ( BA.ENCUMBRANCE_TYPE_ID
, -100 ) = NVL ( GLR03300_PKG.GET_ENCUMBRANCE_TYPE_ID
, -100 )
AND NVL ( BA.TEMPLATE_ID
, -100 ) = NVL ( GLR03300_PKG.GET_TEMPLATE_ID
, -100 )
AND BA.CODE_COMBINATION_ID = GLR03300_PKG.GET_CODE_COMBINATION_ID
AND BA.ACTUAL_FLAG = GLR03300_PKG.GET_ACTUAL_FLAG
AND BA.CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, NULL
, GLR03300_PKG.GET_LEDGER_CURRENCY
, 'ALL123456789012345'
, NULL
, GLR03300_PKG.GET_ENTERED_CURRENCY_CODE )
AND BA.PERIOD_NAME = GLR03300_PKG.GET_PERIOD_NAME
AND BA.LEDGER_ID = GLR03300_PKG.GET_LEDGER_ID
AND LED.LEDGER_ID = BA.LEDGER_ID

Columns