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.IGI_BUD_VARIANCE_BAL_V

Source

View Text - Preformatted


SELECT BA.ledger_id SET_OF_BOOKS_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, /* * Debit amounts */ DECODE(BA.code_combination_id, NULL, NULL, (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, /* * Credit amounts */ DECODE(BA.code_combination_id, NULL, NULL, (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, /* * Quarter to Date amount */ DECODE(BA.code_combination_id, NULL, NULL, ((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, /* * Project to date amount */ DECODE(BA.code_combination_id, NULL, NULL, ((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, /* * Year to date amounts */ DECODE(IGIGGACC_PKG.get_bud_status_flag,'N', DECODE(BA.code_combination_id, NULL, NULL, ((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, DECODE(IGIGGACC_PKG.get_balanced_budget_flag,'Y', DECODE(BA.code_combination_id, NULL, NULL, ((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, DECODE(IGIGGACC_PKG.get_average_unbalanced,'N', DECODE(BA.code_combination_id, NULL, NULL, ((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, (DECODE(BA.code_combination_id, NULL, NULL, ((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)/BA.period_num))) 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, /* * Period to date amounts */ DECODE(BA.code_combination_id, NULL, NULL, ((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 NVL(DECODE(BA.translated_flag(+), 'N', 'Y', BA.translated_flag(+)), DECODE(GLR03300_PKG.get_actual_flag, 'A', DECODE(GLR03300_PKG.get_entered_currency_code, LED.currency_code, 'R', 'STAT', 'R', DECODE(GLR03300_PKG.get_translated_flag, 'E', DECODE(BA.template_id(+), NULL, 'R', 'X'), DECODE(BA.template_id(+), NULL, 'R', 'Y'))), 'B', DECODE(GLR03300_PKG.get_entered_currency_code, LED.currency_code, 'R', 'STAT', 'R', DECODE(GLR03300_PKG.get_translated_flag, 'E', DECODE(BA.template_id(+),NULL, 'R', 'X'), DECODE(BA.template_id(+),NULL, 'R', 'Y'))), 'E', 'E')) = DECODE(GLR03300_PKG.get_actual_flag, 'A', DECODE(GLR03300_PKG.get_entered_currency_code, LED.currency_code, 'R', 'STAT', 'R', DECODE(GLR03300_PKG.get_translated_flag, 'E', 'R', 'Y')), 'B', DECODE(GLR03300_PKG.get_entered_currency_code, LED.currency_code, 'R', 'STAT', 'R', DECODE(GLR03300_PKG.get_translated_flag, 'E', 'R', 'Y')), 'E', 'E') 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.code_combination_id = GLR03300_PKG.get_code_combination_id AND BA.actual_flag = GLR03300_PKG.get_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 BA.LEDGER_ID = LED.LEDGER_ID

View Text - HTML Formatted

SELECT BA.LEDGER_ID SET_OF_BOOKS_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
, /* * DEBIT AMOUNTS */ DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, (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
, /* * CREDIT AMOUNTS */ DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, (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
, /* * QUARTER TO DATE AMOUNT */ DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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
, /* * PROJECT TO DATE AMOUNT */ DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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
, /* * YEAR TO DATE AMOUNTS */ DECODE(IGIGGACC_PKG.GET_BUD_STATUS_FLAG
, 'N'
, DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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
, DECODE(IGIGGACC_PKG.GET_BALANCED_BUDGET_FLAG
, 'Y'
, DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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
, DECODE(IGIGGACC_PKG.GET_AVERAGE_UNBALANCED
, 'N'
, DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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
, (DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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)/BA.PERIOD_NUM))) 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
, /* * PERIOD TO DATE AMOUNTS */ DECODE(BA.CODE_COMBINATION_ID
, NULL
, NULL
, ((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 NVL(DECODE(BA.TRANSLATED_FLAG(+)
, 'N'
, 'Y'
, BA.TRANSLATED_FLAG(+))
, DECODE(GLR03300_PKG.GET_ACTUAL_FLAG
, 'A'
, DECODE(GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, LED.CURRENCY_CODE
, 'R'
, 'STAT'
, 'R'
, DECODE(GLR03300_PKG.GET_TRANSLATED_FLAG
, 'E'
, DECODE(BA.TEMPLATE_ID(+)
, NULL
, 'R'
, 'X')
, DECODE(BA.TEMPLATE_ID(+)
, NULL
, 'R'
, 'Y')))
, 'B'
, DECODE(GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, LED.CURRENCY_CODE
, 'R'
, 'STAT'
, 'R'
, DECODE(GLR03300_PKG.GET_TRANSLATED_FLAG
, 'E'
, DECODE(BA.TEMPLATE_ID(+)
, NULL
, 'R'
, 'X')
, DECODE(BA.TEMPLATE_ID(+)
, NULL
, 'R'
, 'Y')))
, 'E'
, 'E')) = DECODE(GLR03300_PKG.GET_ACTUAL_FLAG
, 'A'
, DECODE(GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, LED.CURRENCY_CODE
, 'R'
, 'STAT'
, 'R'
, DECODE(GLR03300_PKG.GET_TRANSLATED_FLAG
, 'E'
, 'R'
, 'Y'))
, 'B'
, DECODE(GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, LED.CURRENCY_CODE
, 'R'
, 'STAT'
, 'R'
, DECODE(GLR03300_PKG.GET_TRANSLATED_FLAG
, 'E'
, 'R'
, 'Y'))
, 'E'
, 'E')
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.CODE_COMBINATION_ID = GLR03300_PKG.GET_CODE_COMBINATION_ID
AND BA.ACTUAL_FLAG = GLR03300_PKG.GET_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 BA.LEDGER_ID = LED.LEDGER_ID