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_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, 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')

View Text - HTML Formatted

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')