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