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 6291: FROM pa_resource_assignments firstrow

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

Line 6298: FROM pa_resource_assignments

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
6298: FROM pa_resource_assignments
6299: WHERE ta_display_flag = 'Y' and nvl(PROJECT_ASSIGNMENT_ID, -1) = -1
6300: AND resource_class_code = 'PEOPLE'
6301: GROUP BY project_id, budget_version_id, resource_list_member_id, project_role_id
6302: ) res_roles