VIEW: APPS.GL_CONTROL_BUDGET_BALANCES_V

Source

View Text - Preformatted

SELECT ps.period_name PERIOD_NAME, ps.period_year PERIOD_YEAR, ps.period_num PERIOD_NUM, ps.ledger_id LEDGER_ID, b.code_combination_id CODE_COMBINATION_ID, b.currency_code CURRENCY_CODE, b.budget_version_id BUDGET_VERSION_ID, b.template_id TEMPLATE_ID, DECODE(b.rowid,NULL,NULL,(nvl(b.period_net_dr,0) - nvl(b.period_net_cr,0)) / BUDGET_INQUIRY_PKG.GET_FACTOR) CONTROL_BALANCE_PTD, DECODE(b.rowid,NULL,NULL,(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) CONTROL_BALANCE_YTD, DECODE(b.rowid,NULL,NULL,(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) CONTROL_BALANCE_QTD, DECODE(b.rowid,NULL,NULL,(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) CONTROL_BALANCE_PJTD, b.rowid ROW_ID, b.last_update_date LAST_UPDATE_DATE, b.last_updated_by LAST_UPDATED_BY FROM gl_period_statuses ps, gl_balances b WHERE b.ledger_id (+) = ps.ledger_id AND b.period_name (+) = ps.period_name AND b.budget_version_id(+) = BUDGET_INQUIRY_PKG.Get_Bvid AND b.code_combination_id(+) = BUDGET_INQUIRY_PKG.Get_Ccid AND b.currency_code(+) = BUDGET_INQUIRY_PKG.Get_Currency AND b.template_id(+) = BUDGET_INQUIRY_PKG.Get_Template_Id AND b.actual_flag (+) = 'B' AND nvl(b.translated_flag (+), 'x') = decode(BUDGET_INQUIRY_PKG.Get_Currency, 'STAT', 'x', BUDGET_INQUIRY_PKG.Get_Funct_Curr, 'x', 'R') AND ps.application_id = 101

View Text - HTML Formatted

SELECT PS.PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, PS.LEDGER_ID LEDGER_ID
, B.CODE_COMBINATION_ID CODE_COMBINATION_ID
, B.CURRENCY_CODE CURRENCY_CODE
, B.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.TEMPLATE_ID TEMPLATE_ID
, DECODE(B.ROWID
, NULL
, NULL
, (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR) CONTROL_BALANCE_PTD
, DECODE(B.ROWID
, NULL
, NULL
, (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) CONTROL_BALANCE_YTD
, DECODE(B.ROWID
, NULL
, NULL
, (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) CONTROL_BALANCE_QTD
, DECODE(B.ROWID
, NULL
, NULL
, (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) CONTROL_BALANCE_PJTD
, B.ROWID ROW_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_PERIOD_STATUSES PS
, GL_BALANCES B
WHERE B.LEDGER_ID (+) = PS.LEDGER_ID
AND B.PERIOD_NAME (+) = PS.PERIOD_NAME
AND B.BUDGET_VERSION_ID(+) = BUDGET_INQUIRY_PKG.GET_BVID
AND B.CODE_COMBINATION_ID(+) = BUDGET_INQUIRY_PKG.GET_CCID
AND B.CURRENCY_CODE(+) = BUDGET_INQUIRY_PKG.GET_CURRENCY
AND B.TEMPLATE_ID(+) = BUDGET_INQUIRY_PKG.GET_TEMPLATE_ID
AND B.ACTUAL_FLAG (+) = 'B'
AND NVL(B.TRANSLATED_FLAG (+)
, 'X') = DECODE(BUDGET_INQUIRY_PKG.GET_CURRENCY
, 'STAT'
, 'X'
, BUDGET_INQUIRY_PKG.GET_FUNCT_CURR
, 'X'
, 'R')
AND PS.APPLICATION_ID = 101