PA Project Roles

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Project Roles (XML)
Short Name: PAXRWPRT_XML
DB package: PA_PAXRWPRT_XMLP_PKG
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
Ask a question