PA Event Types

SELECT 	e.event_type
,	e.description
,       pa.meaning event_type_classification
,	e.revenue_category_code
,	e.start_date_active
,	e.end_date_active
FROM	pa_lookups pa
,	pa_event_types e
WHERE	e.event_type_classification = pa.lookup_code
and	pa.lookup_type = 'EVENT TYPE CLASSIFICATION'
ORDER BY
	e.event_type ,e.start_date_active

SELECT e.event_type , e.description , pa.meaning event_type_classification , e.revenue_category_code , e.start_date_active , e.end_date_active FROM pa_lookups pa , pa_event_types e WHERE e.event_type_classification = pa.lookup_code and pa.lookup_type = 'EVENT TYPE CLASSIFICATION' ORDER BY e.event_type ,e.start_date_active