PA Event Types

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Event Types (XML)
Short Name: PAXRWPET_XML
DB package: PA_PAXRWPET_XMLP_PKG
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