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_VARIANCE_SEC_BALANCES_V

Source

View Text - Preformatted


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 ( 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, ( 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_sec_budget_version_id,-100 ) AND NVL ( BA.encumbrance_type_id,-100 ) = NVL ( GLR03300_PKG.get_sec_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_sec_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

View Text - HTML Formatted

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 ( 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
, ( 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_SEC_BUDGET_VERSION_ID
, -100 )
AND NVL ( BA.ENCUMBRANCE_TYPE_ID
, -100 ) = NVL ( GLR03300_PKG.GET_SEC_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_SEC_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