VIEW: APPS.IGW_EXPENDITURE_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'