VIEW: APPS.GL_ENTITY_BUDGETS_V

Source

View Text - Preformatted

SELECT /* $Header: glgvw.odf 120.39 2011/02/18 13:08:22 sommukhe ship $ */ eb.frozen_flag FROZEN_FLAG, be.name NAME, eb.budget_entity_id BUDGET_ENTITY_ID, eb.budget_version_id BUDGET_VERSION_ID, be.status_code STATUS_CODE, eb.last_update_date LAST_UPDATE_DATE, eb.last_updated_by LAST_UPDATED_BY, eb.last_update_login LAST_UPDATE_LOGIN, eb.rowid ROW_ID FROM gl_entity_budgets eb, gl_budget_entities be WHERE eb.budget_entity_id = be.budget_entity_id AND be.status_code <> 'D'

View Text - HTML Formatted

SELECT /* $HEADER: GLGVW.ODF 120.39 2011/02/18 13:08:22 SOMMUKHE SHIP $ */ EB.FROZEN_FLAG FROZEN_FLAG
, BE.NAME NAME
, EB.BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, EB.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BE.STATUS_CODE STATUS_CODE
, EB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EB.LAST_UPDATED_BY LAST_UPDATED_BY
, EB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EB.ROWID ROW_ID
FROM GL_ENTITY_BUDGETS EB
, GL_BUDGET_ENTITIES BE
WHERE EB.BUDGET_ENTITY_ID = BE.BUDGET_ENTITY_ID
AND BE.STATUS_CODE <> 'D'