PA Project Roles

Description
Categories: BI Publisher
Application: Projects
Source: IMP: Project Roles (XML)
Short Name: PAXRWPRT_XML
DB package: PA_PAXRWPRT_XMLP_PKG
Run PA Project Roles and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™