VIEW: APPS.GL_BUDGETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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