View: GL_BALANCES_V

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

View Text

SELECT LR.TARGET_LEDGER_ID LEDGER_ID
, LR.TARGET_LEDGER_NAME LEDGER_NAME
, LR.TARGET_CURRENCY_CODE LEDGER_CURRENCY
, PS.PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.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
, GLR03300_PKG.GET_FACTOR FACTOR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( NVL ( DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, BA.PERIOD_NET_DR_BEQ
, BA.PERIOD_NET_DR )
, BA.PERIOD_NET_DR )
, BA.PERIOD_NET_DR )
, 0 ) ) ) /GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_NET_DR_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, NVL ( BA.PERIOD_NET_DR_BEQ
, 0 )
, NULL )
, NULL ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_PERIOD_NET_DR
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( NVL ( DECODE ( GLR03300_PKG.GET_CURRENCY_TYPE
, 'E'
, DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, BA.PERIOD_NET_CR_BEQ
, BA.PERIOD_NET_CR )
, BA.PERIOD_NET_CR )
, BA.PERIOD_NET_CR )
, 0 ) ) ) /GLR03300_PKG.GET_FACTOR ENTERED_PERIOD_NET_CR_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, NVL ( BA.PERIOD_NET_CR_BEQ
, 0 )
, NULL )
, NULL ) ) ) ) ) /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_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, 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 ) )
, NULL )
, NULL ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_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_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, 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 ) )
, NULL )
, NULL ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_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 ( BA.PERIOD_NET_CR_BEQ
, 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 ) ) ) )
, ( ( 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_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, 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 ( BA.PERIOD_NET_CR_BEQ
, 0 ) ) )
, NULL )
, NULL ) ) ) ) ) /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_NUM
, DECODE ( BA.CODE_COMBINATION_ID
, NULL
, NULL
, ( DECODE ( BA.CURRENCY_CODE
, LED.CURRENCY_CODE
, NULL
, 'STAT'
, NULL
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, DECODE ( BA.TRANSLATED_FLAG
, 'R'
, DECODE ( BA.ACTUAL_FLAG
, 'A'
, ( NVL ( BA.PERIOD_NET_DR_BEQ
, 0 ) - NVL ( BA.PERIOD_NET_CR_BEQ
, 0 ) )
, NULL )
, NULL ) ) ) ) ) /GLR03300_PKG.GET_FACTOR FUNCTIONAL_PERIOD_TO_DATE
, BA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BA.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_BALANCES BA
, GL_PERIOD_STATUSES PS
, GL_LEDGER_RELATIONSHIPS LR
, GL_LEDGERS LED
WHERE PS.APPLICATION_ID = 101
AND LED.LEDGER_ID = PS.LEDGER_ID
AND LR.SOURCE_LEDGER_ID = PS.LEDGER_ID
AND LR.TARGET_LEDGER_ID = LR.SOURCE_LEDGER_ID
AND LR.TARGET_CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_LEDGER_CURRENCY
, 'ALL123456789012345'
, LR.TARGET_CURRENCY_CODE
, GLR03300_PKG.GET_LEDGER_CURRENCY )
AND LR.APPLICATION_ID = 101
AND BA.LEDGER_ID = PS.LEDGER_ID
AND BA.PERIOD_NAME = PS.PERIOD_NAME
AND BA.ACTUAL_FLAG = DECODE ( GLR03300_PKG.GET_ACTUAL_FLAG
, 'E'
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, 'X'
, GLR03300_PKG.GET_ACTUAL_FLAG )
, GLR03300_PKG.GET_ACTUAL_FLAG )
AND BA.CODE_COMBINATION_ID = GLR03300_PKG.GET_CODE_COMBINATION_ID
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.CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, 'ALL123456789012345'
, BA.CURRENCY_CODE
, NULL
, LR.TARGET_CURRENCY_CODE
, GLR03300_PKG.GET_ENTERED_CURRENCY_CODE )
AND 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')

Columns