View: GL_DETAIL_BALANCES_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_DETAIL_BALANCES_V

View Text

SELECT LR.TARGET_LEDGER_ID LEDGER_ID
, LR.TARGET_LEDGER_NAME LEDGER_NAME
, LR.TARGET_CURRENCY_CODE LEDGER_CURRENCY
, GLR03300_PKG.GET_PERIOD_NAME PERIOD_NAME
, BA.PERIOD_YEAR PERIOD_YEAR
, BA.PERIOD_NUM PERIOD_NUM
, BA.ROWID ROW_ID
, BA.CURRENCY_CODE CURRENCY_CODE
, HI.DETAIL_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
, ( 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
, 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
, 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
, 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
, 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
, 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
, 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
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
FROM GL_BALANCES BA
, GL_LEDGER_RELATIONSHIPS LR
, GL_ACCOUNT_HIERARCHIES HI
, GL_CODE_COMBINATIONS CC
, GL_LEDGERS LED
WHERE LR.SOURCE_LEDGER_ID = GLR03300_PKG.GET_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 LED.LEDGER_ID = LR.TARGET_LEDGER_ID
AND HI.TEMPLATE_ID = GLR03300_PKG.GET_TEMPLATE_ID
AND HI.SUMMARY_CODE_COMBINATION_ID = GLR03300_PKG.GET_CODE_COMBINATION_ID
AND HI.LEDGER_ID = LR.TARGET_LEDGER_ID
AND BA.LEDGER_ID = HI.LEDGER_ID
AND BA.CODE_COMBINATION_ID = HI.DETAIL_CODE_COMBINATION_ID
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.PERIOD_NAME LIKE GLR03300_PKG.GET_PERIOD_NAME
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 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')
AND CC.CODE_COMBINATION_ID = BA.CODE_COMBINATION_ID

Columns