View: GL_BUDGET_DEPENDENT_AMTS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BUDGET_DEPENDENT_AMTS_V

View Text

SELECT /* $HEADER: GLGVWREG.LDT 120.29.12020000.1 2012/06/27 14:57:54 APPLDEV 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

Columns