SELECT PET.EVENT_TYPE , PET.DESCRIPTION , '_LA:EVENT_TYPE_CLASSIFICATION:PA_LOOKUPS:EVENT TYPE CLASSIFICATION:MEANING' , PET.START_DATE_ACTIVE , PET.END_DATE_ACTIVE , PET.REVENUE_CATEGORY_CODE , PAL.DESCRIPTION , '_DF:PA:PA_EVENT_TYPES_DESC_FLEX:PET' , PET.LAST_UPDATE_DATE , PET.LAST_UPDATED_BY , PET.CREATION_DATE , PET.CREATED_BY FROM PA_EVENT_TYPES PET , PA_LOOKUPS PAL WHERE REVENUE_CATEGORY_CODE=PAL.LOOKUP_CODE AND LOOKUP_TYPE='REVENUE CATEGORY' WITH READ ONLY