VIEW: APPS.GL_BUDGET_DEP_BALANCES_V

Source

View Text - Preformatted

SELECT bv.budget_name BUDGET_NAME, bv.budget_version_id BUDGET_VERSION_ID, bv.control_budget_version_id CONTROL_BUDGET_VERSION_ID, bv.description DESCRIPTION, bal.ledger_id LEDGER_ID, bal.period_name PERIOD_NAME, bal.currency_code CURRENCY_CODE, bal.code_combination_id CODE_COMBINATION_ID, lk1.meaning BUDGET_STATUS, lk2.meaning REQUIRE_BUDGET_JOURNALS, bud.require_budget_journals_flag REQUIRE_BUDGET_JOURNALS_FLAG, bud.latest_opened_year LATEST_OPENED_YEAR, bud.first_valid_period_name FIRST_VALID_PERIOD_NAME, bud.last_valid_period_name LAST_VALID_PERIOD_NAME, bud.date_closed DATE_CLOSED, (nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PTD_BUDGET_AMOUNT, (nvl(bal.begin_balance_dr,0) - nvl(bal.begin_balance_cr,0) + nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YTD_BUDGET_AMOUNT, (nvl(bal.quarter_to_date_dr,0) - nvl(bal.quarter_to_date_cr,0) + nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QTD_BUDGET_AMOUNT, (nvl(bal.project_to_date_dr,0) - nvl(bal.project_to_date_cr,0) + nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PJTD_BUDGET_AMOUNT, bal.rowid ROW_ID, bal.last_update_date LAST_UPDATE_DATE, bal.last_updated_by LAST_UPDATED_BY FROM gl_lookups lk1, gl_lookups lk2, gl_budgets bud, gl_budget_versions bv, gl_balances bal WHERE bv.budget_name = bud.budget_name AND bv.budget_version_id = bal.budget_version_id AND lk1.lookup_type = 'PLAN/VERSION STATUS' AND lk1.lookup_code = bud.status AND lk2.lookup_type = 'YES/NO' AND lk2.lookup_code = bud.require_budget_journals_flag AND bal.actual_flag = 'B'

View Text - HTML Formatted

SELECT BV.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BV.CONTROL_BUDGET_VERSION_ID CONTROL_BUDGET_VERSION_ID
, BV.DESCRIPTION DESCRIPTION
, BAL.LEDGER_ID LEDGER_ID
, BAL.PERIOD_NAME PERIOD_NAME
, BAL.CURRENCY_CODE CURRENCY_CODE
, BAL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, LK1.MEANING BUDGET_STATUS
, LK2.MEANING REQUIRE_BUDGET_JOURNALS
, BUD.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, BUD.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
, BUD.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, BUD.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
, BUD.DATE_CLOSED DATE_CLOSED
, (NVL(BAL.PERIOD_NET_DR
, 0) - NVL(BAL.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PTD_BUDGET_AMOUNT
, (NVL(BAL.BEGIN_BALANCE_DR
, 0) - NVL(BAL.BEGIN_BALANCE_CR
, 0) + NVL(BAL.PERIOD_NET_DR
, 0) - NVL(BAL.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YTD_BUDGET_AMOUNT
, (NVL(BAL.QUARTER_TO_DATE_DR
, 0) - NVL(BAL.QUARTER_TO_DATE_CR
, 0) + NVL(BAL.PERIOD_NET_DR
, 0) - NVL(BAL.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QTD_BUDGET_AMOUNT
, (NVL(BAL.PROJECT_TO_DATE_DR
, 0) - NVL(BAL.PROJECT_TO_DATE_CR
, 0) + NVL(BAL.PERIOD_NET_DR
, 0) - NVL(BAL.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PJTD_BUDGET_AMOUNT
, BAL.ROWID ROW_ID
, BAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BAL.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_LOOKUPS LK1
, GL_LOOKUPS LK2
, GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV
, GL_BALANCES BAL
WHERE BV.BUDGET_NAME = BUD.BUDGET_NAME
AND BV.BUDGET_VERSION_ID = BAL.BUDGET_VERSION_ID
AND LK1.LOOKUP_TYPE = 'PLAN/VERSION STATUS'
AND LK1.LOOKUP_CODE = BUD.STATUS
AND LK2.LOOKUP_TYPE = 'YES/NO'
AND LK2.LOOKUP_CODE = BUD.REQUIRE_BUDGET_JOURNALS_FLAG
AND BAL.ACTUAL_FLAG = 'B'