VIEW: APPS.GL_BUD_PERIOD_RANGES_V

Source

View Text - Preformatted

SELECT p.rowid ROW_ID, p.budget_version_id BUDGET_VERSION_ID, v.budget_name BUDGET_NAME, p.period_year PERIOD_YEAR, p.start_period_name START_PERIOD_NAME, p.start_period_num START_PERIOD_NUM, p.end_period_name END_PERIOD_NAME, p.end_period_num END_PERIOD_NUM, p.open_flag OPEN_FLAG, p.last_update_date LAST_UPDATE_DATE, p.last_updated_by LAST_UPDATED_BY FROM gl_budget_versions v, gl_budget_period_ranges p WHERE v.budget_version_id = p.budget_version_id

View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.BUDGET_VERSION_ID BUDGET_VERSION_ID
, V.BUDGET_NAME BUDGET_NAME
, P.PERIOD_YEAR PERIOD_YEAR
, P.START_PERIOD_NAME START_PERIOD_NAME
, P.START_PERIOD_NUM START_PERIOD_NUM
, P.END_PERIOD_NAME END_PERIOD_NAME
, P.END_PERIOD_NUM END_PERIOD_NUM
, P.OPEN_FLAG OPEN_FLAG
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_BUDGET_VERSIONS V
, GL_BUDGET_PERIOD_RANGES P
WHERE V.BUDGET_VERSION_ID = P.BUDGET_VERSION_ID