View: GL_BUDGET_DEP_BALANCES_V

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

View Text

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'

Columns