View: IGW_EXPENDITURE_TYPES_V

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

View Text

SELECT ROWID ROW_ID
, EXPENDITURE_CATEGORY
, EXPENDITURE_TYPE
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW_EXPENDITURE_TYPES
WHERE IGW_SECURITY.GMS_ENABLED = 'N' UNION SELECT PET.ROWID ROW_ID
, PET.EXPENDITURE_CATEGORY
, PET.EXPENDITURE_TYPE
, PET.DESCRIPTION
, PET.START_DATE_ACTIVE
, PET.END_DATE_ACTIVE
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.CREATION_DATE
, PET.CREATED_BY
, PET.LAST_UPDATE_LOGIN
FROM PA_EXPENDITURE_TYPES PET
, IGW_EXPENDITURE_CATEGORIES IEC
WHERE PET.EXPENDITURE_CATEGORY = IEC.EXPENDITURE_CATEGORY
AND IGW_SECURITY.GMS_ENABLED = 'Y'

Columns