eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_PROJ_ROLES_V

Line 475: , pa_proj_roles_v ro

471: , firstrow.resource_assignment_id
472: , firstrow.res_type_code
473: FROM pa_resource_assignments firstrow
474: , pa_resource_list_members rlm
475: , pa_proj_roles_v ro
476: , (SELECT project_id , budget_version_id , resource_list_member_id , count(1) role_count , max(max_id) max_id
477: , min(min_date) min_date , max(max_date) max_date
478: FROM (SELECT project_id , budget_version_id , resource_list_member_id , project_role_id
479: , max(resource_assignment_id) max_id , min(SCHEDULE_START_DATE) min_date , max(SCHEDULE_END_DATE) max_date

Line 6293: , pa_proj_roles_v ro

6289: , firstrow.resource_assignment_id
6290: , firstrow.res_type_code
6291: FROM pa_resource_assignments firstrow
6292: , pa_resource_list_members rlm
6293: , pa_proj_roles_v ro
6294: , (SELECT project_id , budget_version_id , resource_list_member_id , count(1) role_count , max(max_id) max_id
6295: , min(min_date) min_date , max(max_date) max_date
6296: FROM (SELECT project_id , budget_version_id , resource_list_member_id , project_role_id
6297: , max(resource_assignment_id) max_id , min(SCHEDULE_START_DATE) min_date , max(SCHEDULE_END_DATE) max_date