PA Service Types

Description

Categories
BI Publisher
Application
Projects
Source
IMP: Service Types (XML)
Short Name
PAXRWPSV_XML
DB package
PA_PAXRWPSV_XMLP_PKG

SQL 10 lines

select LOOKUP_CODE, description, START_DATE_ACTIVE,
       END_DATE_ACTIVE
from
    PA_LOOKUPS L
where 
    LOOKUP_TYPE = 'SERVICE TYPE'
order by 
    LOOKUP_CODE,
    START_DATE_ACTIVE