PA Event Types
Description
Categories: BI Publisher
Columns: Event Type, Description, Event Type Classification, Revenue Category Code, Start Date Active, End Date Active ...
Columns: Event Type, Description, Event Type Classification, Revenue Category Code, Start Date Active, End Date Active ...
Application: Projects
Source: IMP: Event Types (XML)
Short Name: PAXRWPET_XML
DB package: PA_PAXRWPET_XMLP_PKG
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 |
