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 |