PA Project Customer Relationships

Description

Categories
BI Publisher
Application
Projects
Source
IMP: Project Customer Relationships (XML)
Short Name
PAXRWPCR_XML
DB package
PA_PAXRWPCR_XMLP_PKG

SQL 12 lines

select LOOKUP_CODE,
       DESCRIPTION,
       START_DATE_ACTIVE,
       END_DATE_ACTIVE
from
       PA_LOOKUPS L
where
       LOOKUP_TYPE = 'CUSTOMER PROJECT RELATIONSHIP'
order by
       LOOKUP_CODE,
       START_DATE_ACTIVE