VIEW: APPS.GL_BUDGET_DEPENDENT_AMTS_V

Source

View Text - Preformatted

SELECT /* $Header: glgvw.odf 120.39 2011/02/18 13:08:22 sommukhe ship $ */ b1.budget_version_id MASTER_BUDGET_VERSION_ID, b1.ledger_id LEDGER_ID, b1.period_name PERIOD_NAME, b1.period_year PERIOD_YEAR, b1.period_num PERIOD_NUM, b1.code_combination_id CODE_COMBINATION_ID, b1.currency_code CURRENCY_CODE, b1.template_id TEMPLATE_ID, sum(nvl(b2.period_net_dr,0)- nvl(b2.period_net_cr,0)) / BUDGET_INQUIRY_PKG.Get_Factor PTD_DETAIL_AMOUNT, sum(nvl(b2.quarter_to_date_dr,0) - nvl(b2.quarter_to_date_cr,0) + nvl(b2.period_net_dr,0) - nvl(b2.period_net_cr,0)) / BUDGET_INQUIRY_PKG.Get_Factor QTD_DETAIL_AMOUNT, sum(nvl(b2.begin_balance_dr,0) - nvl(b2.begin_balance_cr,0) + nvl(b2.period_net_dr,0) - nvl(b2.period_net_cr,0)) / BUDGET_INQUIRY_PKG.Get_Factor YTD_DETAIL_AMOUNT, sum(nvl(b2.project_to_date_dr,0) - nvl(b2.project_to_date_cr,0) + nvl(b2.period_net_dr,0) - nvl(b2.period_net_cr,0)) / BUDGET_INQUIRY_PKG.Get_Factor PJTD_DETAIL_AMOUNT FROM gl_budget_versions bv, gl_balances b1, gl_balances b2 WHERE b1.budget_version_id = bv.control_budget_version_id AND bv.budget_version_id = b2.budget_version_id AND b1.period_name = b2.period_name AND b1.code_combination_id = b2.code_combination_id AND b1.currency_code = b2.currency_code AND b2.actual_flag = 'B' AND b1.actual_flag = 'B' GROUP BY b1.budget_version_id, b1.ledger_id, b1.period_name, b1.code_combination_id, b1.currency_code, b1.period_year, b1.period_num, b1.template_id

View Text - HTML Formatted

SELECT /* $HEADER: GLGVW.ODF 120.39 2011/02/18 13:08:22 SOMMUKHE SHIP $ */ B1.BUDGET_VERSION_ID MASTER_BUDGET_VERSION_ID
, B1.LEDGER_ID LEDGER_ID
, B1.PERIOD_NAME PERIOD_NAME
, B1.PERIOD_YEAR PERIOD_YEAR
, B1.PERIOD_NUM PERIOD_NUM
, B1.CODE_COMBINATION_ID CODE_COMBINATION_ID
, B1.CURRENCY_CODE CURRENCY_CODE
, B1.TEMPLATE_ID TEMPLATE_ID
, SUM(NVL(B2.PERIOD_NET_DR
, 0)- NVL(B2.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PTD_DETAIL_AMOUNT
, SUM(NVL(B2.QUARTER_TO_DATE_DR
, 0) - NVL(B2.QUARTER_TO_DATE_CR
, 0) + NVL(B2.PERIOD_NET_DR
, 0) - NVL(B2.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QTD_DETAIL_AMOUNT
, SUM(NVL(B2.BEGIN_BALANCE_DR
, 0) - NVL(B2.BEGIN_BALANCE_CR
, 0) + NVL(B2.PERIOD_NET_DR
, 0) - NVL(B2.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YTD_DETAIL_AMOUNT
, SUM(NVL(B2.PROJECT_TO_DATE_DR
, 0) - NVL(B2.PROJECT_TO_DATE_CR
, 0) + NVL(B2.PERIOD_NET_DR
, 0) - NVL(B2.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PJTD_DETAIL_AMOUNT
FROM GL_BUDGET_VERSIONS BV
, GL_BALANCES B1
, GL_BALANCES B2
WHERE B1.BUDGET_VERSION_ID = BV.CONTROL_BUDGET_VERSION_ID
AND BV.BUDGET_VERSION_ID = B2.BUDGET_VERSION_ID
AND B1.PERIOD_NAME = B2.PERIOD_NAME
AND B1.CODE_COMBINATION_ID = B2.CODE_COMBINATION_ID
AND B1.CURRENCY_CODE = B2.CURRENCY_CODE
AND B2.ACTUAL_FLAG = 'B'
AND B1.ACTUAL_FLAG = 'B' GROUP BY B1.BUDGET_VERSION_ID
, B1.LEDGER_ID
, B1.PERIOD_NAME
, B1.CODE_COMBINATION_ID
, B1.CURRENCY_CODE
, B1.PERIOD_YEAR
, B1.PERIOD_NUM
, B1.TEMPLATE_ID