View: IGW_EXPENDITURE_CATEGORIES_V

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGW_EXPENDITURE_CATEGORIES_V

View Text

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

Columns