VIEW: APPS.GL_BUDGET_DETAIL_BALANCES_V

Source

View Text - Preformatted

SELECT /*+ ORDERED USE_NL(a b) INDEX(a GL_ACCOUNT_HIERARCHIES_U1) INDEX(b GL_BALANCES_N1) */ b.ledger_id LEDGER_ID, b.code_combination_id CODE_COMBINATION_ID, a.summary_code_combination_id SUMMARY_CODE_COMBINATION_ID, b.currency_code CURRENCY_CODE, b.period_name PERIOD_NAME, b.budget_version_id BUDGET_VERSION_ID, b.translated_flag TRANSLATED_FLAG, b.revaluation_status REVALUATION_STATUS, b.period_year PERIOD_YEAR, b.period_num PERIOD_NUM, b.period_type PERIOD_TYPE, (nvl(b.period_net_dr,0) - nvl(b.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PERIOD_NET_AMOUNT, (nvl(b.begin_balance_dr,0) - nvl(b.begin_balance_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR BEGIN_BALANCE_AMOUNT, (nvl(b.quarter_to_date_dr,0) - nvl(b.quarter_to_date_cr,0)) + (nvl(b.period_net_dr,0) - nvl(b.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QUARTER_TO_DATE_AMOUNT, (nvl(b.project_to_date_dr,0) - nvl(b.project_to_date_cr,0)) + (nvl(b.period_net_dr,0) - nvl(b.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PROJECT_TO_DATE_AMOUNT, (nvl(b.begin_balance_dr,0) - nvl(b.begin_balance_cr,0) + nvl(b.period_net_dr,0) - nvl(b.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YEAR_TO_DATE_AMOUNT, a.rowid ROW_ID FROM gl_account_hierarchies a, gl_balances b WHERE b.actual_flag = 'B' AND b.template_id IS NULL AND nvl(b.translated_flag,'x') not in ('Y','N') AND b.ledger_id = a.ledger_id AND b.code_combination_id = a.detail_code_combination_id

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL(A B) INDEX(A GL_ACCOUNT_HIERARCHIES_U1) INDEX(B GL_BALANCES_N1) */ B.LEDGER_ID LEDGER_ID
, B.CODE_COMBINATION_ID CODE_COMBINATION_ID
, A.SUMMARY_CODE_COMBINATION_ID SUMMARY_CODE_COMBINATION_ID
, B.CURRENCY_CODE CURRENCY_CODE
, B.PERIOD_NAME PERIOD_NAME
, B.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.REVALUATION_STATUS REVALUATION_STATUS
, B.PERIOD_YEAR PERIOD_YEAR
, B.PERIOD_NUM PERIOD_NUM
, B.PERIOD_TYPE PERIOD_TYPE
, (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PERIOD_NET_AMOUNT
, (NVL(B.BEGIN_BALANCE_DR
, 0) - NVL(B.BEGIN_BALANCE_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR BEGIN_BALANCE_AMOUNT
, (NVL(B.QUARTER_TO_DATE_DR
, 0) - NVL(B.QUARTER_TO_DATE_CR
, 0)) + (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QUARTER_TO_DATE_AMOUNT
, (NVL(B.PROJECT_TO_DATE_DR
, 0) - NVL(B.PROJECT_TO_DATE_CR
, 0)) + (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PROJECT_TO_DATE_AMOUNT
, (NVL(B.BEGIN_BALANCE_DR
, 0) - NVL(B.BEGIN_BALANCE_CR
, 0) + NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YEAR_TO_DATE_AMOUNT
, A.ROWID ROW_ID
FROM GL_ACCOUNT_HIERARCHIES A
, GL_BALANCES B
WHERE B.ACTUAL_FLAG = 'B'
AND B.TEMPLATE_ID IS NULL
AND NVL(B.TRANSLATED_FLAG
, 'X') NOT IN ('Y'
, 'N')
AND B.LEDGER_ID = A.LEDGER_ID
AND B.CODE_COMBINATION_ID = A.DETAIL_CODE_COMBINATION_ID