View: GL_BUDGETS_V

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

View Text

SELECT B.ROWID ROW_ID
, B.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.STATUS STATUS
, ST.MEANING SHOW_STATUS
, B.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, B.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, B.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
, DEST_PER.PERIOD_YEAR LAST_VALID_YEAR
, DEST_PER.PERIOD_NUM LAST_VALID_PERIOD_NUM
, START_PER.PERIOD_YEAR FIRST_VALID_YEAR
, START_PER.PERIOD_NUM FIRST_VALID_PERIOD_NUM
, START_PER.START_DATE START_DATE
, DEST_PER.END_DATE END_DATE
, B.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
, B.DESCRIPTION DESCRIPTION
, B.DATE_CREATED DATE_CREATED
, B.DATE_CLOSED DATE_CLOSED
, B.LEDGER_ID LEDGER_ID
, LDG.NAME LEDGER_NAME
, B.CURRENT_VERSION_ID CURRENT_VERSION_ID
, B.BUDGET_TYPE BUDGET_TYPE
, MBV.BUDGET_VERSION_ID MASTER_BUDGET_VERSION_ID
, MBV.BUDGET_NAME MASTER_BUDGET_NAME
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.CONTEXT CONTEXT
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
, GL_PERIOD_STATUSES DEST_PER
, GL_PERIOD_STATUSES START_PER
, GL_BUDGET_VERSIONS MBV
, GL_LOOKUPS ST
, GL_LEDGERS LDG
WHERE BV.BUDGET_NAME = B.BUDGET_NAME||''
AND DEST_PER.APPLICATION_ID = DECODE(B.LEDGER_ID
, NULL
, 101
, 101)
AND DEST_PER.LEDGER_ID = B.LEDGER_ID
AND DEST_PER.PERIOD_NAME = B.LAST_VALID_PERIOD_NAME
AND START_PER.APPLICATION_ID = DECODE(B.LEDGER_ID
, NULL
, 101
, 101)
AND START_PER.LEDGER_ID = B.LEDGER_ID
AND START_PER.PERIOD_NAME = B.FIRST_VALID_PERIOD_NAME
AND MBV.BUDGET_VERSION_ID(+) = BV.CONTROL_BUDGET_VERSION_ID
AND ST.LOOKUP_TYPE = DECODE(B.STATUS
, NULL
, 'PLAN/VERSION STATUS'
, 'PLAN/VERSION STATUS')
AND ST.LOOKUP_CODE = B.STATUS
AND LDG.LEDGER_ID = B.LEDGER_ID

Columns