eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_SUMMARY_BALANCES_V

Source

View Text - Preformatted


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.summary_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_LEDGERS LED, GL_CODE_COMBINATIONS CC 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 ( + ) = nvl ( GLR03300_pkg.get_template_id, HI.template_id ( + ) ) AND HI.detail_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.summary_code_combination_id AND BA.period_name like GLR03300_pkg.get_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.template_id+0 = HI.template_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 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

View Text - HTML Formatted

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.SUMMARY_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_LEDGERS LED
, GL_CODE_COMBINATIONS CC
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 ( + ) = NVL ( GLR03300_PKG.GET_TEMPLATE_ID
, HI.TEMPLATE_ID ( + ) )
AND HI.DETAIL_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.SUMMARY_CODE_COMBINATION_ID
AND BA.PERIOD_NAME LIKE GLR03300_PKG.GET_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.TEMPLATE_ID+0 = HI.TEMPLATE_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 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