PA Project Roles

Description

Categories
BI Publisher
Application
Projects
Source
IMP: Project Roles (XML)
Short Name
PAXRWPRT_XML
DB package
PA_PAXRWPRT_XMLP_PKG

SQL 13 lines

SELECT  p.meaning
,	p.description
,	q.meaning query_labor_cost
,	p.start_date_active
,	p.end_date_active
FROM	pa_proj_role_types_v p 
,	fnd_lookups q
WHERE	p.query_labor_cost_flag = q.lookup_code(+)
and	q.lookup_type(+) = 'YES_NO'
ORDER BY
	p.project_role_type
,	p.start_date_active