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_RESOURCE_ASSIGNMENTS

Line 473: FROM pa_resource_assignments firstrow

469: , ra.min_date task_assign_start_date
470: , ra.max_date task_assign_end_date
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

Line 480: FROM pa_resource_assignments

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
480: FROM pa_resource_assignments
481: WHERE ta_display_flag = 'Y' and nvl(PROJECT_ASSIGNMENT_ID, -1) = -1
482: AND resource_class_code = 'PEOPLE'
483: GROUP BY project_id, budget_version_id, resource_list_member_id, project_role_id
484: ) res_roles

Line 6290: FROM pa_resource_assignments firstrow

6286: , ra.min_date task_assign_start_date
6287: , ra.max_date task_assign_end_date
6288: , firstrow.resource_assignment_id
6289: , firstrow.res_type_code
6290: FROM pa_resource_assignments firstrow
6291: , pa_resource_list_members rlm
6292: , pa_proj_roles_v ro
6293: , (SELECT project_id , budget_version_id , resource_list_member_id , count(1) role_count , max(max_id) max_id
6294: , min(min_date) min_date , max(max_date) max_date

Line 6297: FROM pa_resource_assignments

6293: , (SELECT project_id , budget_version_id , resource_list_member_id , count(1) role_count , max(max_id) max_id
6294: , min(min_date) min_date , max(max_date) max_date
6295: FROM (SELECT project_id , budget_version_id , resource_list_member_id , project_role_id
6296: , max(resource_assignment_id) max_id , min(SCHEDULE_START_DATE) min_date , max(SCHEDULE_END_DATE) max_date
6297: FROM pa_resource_assignments
6298: WHERE ta_display_flag = 'Y' and nvl(PROJECT_ASSIGNMENT_ID, -1) = -1
6299: AND resource_class_code = 'PEOPLE'
6300: GROUP BY project_id, budget_version_id, resource_list_member_id, project_role_id
6301: ) res_roles