VIEW: APPS.IGW_EXPENDITURE_CATEGORIES_V

Source

View Text - Preformatted

SELECT rowid row_id, expenditure_category, decode(igw_security.gms_enabled, 'N', description, 'Y', igw_exp_categories_v_pkg. get_description_from_pa (expenditure_category)) description, budget_category_code, personnel_attached_flag, decode(igw_security.gms_enabled, 'N', start_date_active, 'Y', igw_exp_categories_v_pkg. get_start_date_active_from_pa(expenditure_category)) start_date_active, decode(igw_security.gms_enabled, 'N', end_date_active, 'Y', igw_exp_categories_v_pkg. get_end_date_active_from_pa (expenditure_category)) end_date_active, last_update_date, last_updated_by, creation_date, created_by, last_update_login from igw_expenditure_categories where decode(igw_security.gms_enabled, 'N', start_date_active, 'Y', igw_exp_categories_v_pkg. get_start_date_active_from_pa(expenditure_category)) is not null

View Text - HTML Formatted

SELECT ROWID ROW_ID
, EXPENDITURE_CATEGORY
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, DESCRIPTION
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_DESCRIPTION_FROM_PA (EXPENDITURE_CATEGORY)) DESCRIPTION
, BUDGET_CATEGORY_CODE
, PERSONNEL_ATTACHED_FLAG
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, START_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_START_DATE_ACTIVE_FROM_PA(EXPENDITURE_CATEGORY)) START_DATE_ACTIVE
, DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, END_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_END_DATE_ACTIVE_FROM_PA (EXPENDITURE_CATEGORY)) END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW_EXPENDITURE_CATEGORIES
WHERE DECODE(IGW_SECURITY.GMS_ENABLED
, 'N'
, START_DATE_ACTIVE
, 'Y'
, IGW_EXP_CATEGORIES_V_PKG. GET_START_DATE_ACTIVE_FROM_PA(EXPENDITURE_CATEGORY)) IS NOT NULL