[Home] [Help]
View: 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
Name |
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 |