PA Project Roles

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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