View: GL_CONTROL_BUDGET_BALANCES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_CONTROL_BUDGET_BALANCES_V

View Text

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

Columns