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.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on ASG_USER

Line 477: asg_user au,

473: hz_ps.location_id,
474: jt.source_object_type_code,
475: csi.incident_location_type
476: FROM JTF_TASK_ASSIGNMENTS jta,
477: asg_user au,
478: asg_user_pub_resps aupr,
479: jtf_tasks_b jt,
480: cs_incidents_all_b csi,
481: hz_party_sites hz_ps

Line 478: asg_user_pub_resps aupr,

474: jt.source_object_type_code,
475: csi.incident_location_type
476: FROM JTF_TASK_ASSIGNMENTS jta,
477: asg_user au,
478: asg_user_pub_resps aupr,
479: jtf_tasks_b jt,
480: cs_incidents_all_b csi,
481: hz_party_sites hz_ps
482: WHERE jta.task_assignment_id = p_taskassgid

Line 508: asg_user au,

504: lc.location_id,
505: jt.source_object_type_code,
506: csi.incident_location_type
507: FROM JTF_TASK_ASSIGNMENTS jta,
508: asg_user au,
509: asg_user_pub_resps aupr,
510: jtf_tasks_b jt,
511: cs_incidents_all_b csi,
512: hz_locations lc

Line 509: asg_user_pub_resps aupr,

505: jt.source_object_type_code,
506: csi.incident_location_type
507: FROM JTF_TASK_ASSIGNMENTS jta,
508: asg_user au,
509: asg_user_pub_resps aupr,
510: jtf_tasks_b jt,
511: cs_incidents_all_b csi,
512: hz_locations lc
513: WHERE jta.task_assignment_id = p_taskassgid

Line 539: asg_user au,

535: to_number(NULL),
536: jt.source_object_type_code,
537: to_char(NULL)
538: FROM JTF_TASK_ASSIGNMENTS jta,
539: asg_user au,
540: asg_user_pub_resps aupr,
541: jtf_tasks_b jt
542: WHERE jta.task_assignment_id = p_taskassgid
543: AND jta.assignee_role = 'ASSIGNEE'

Line 540: asg_user_pub_resps aupr,

536: jt.source_object_type_code,
537: to_char(NULL)
538: FROM JTF_TASK_ASSIGNMENTS jta,
539: asg_user au,
540: asg_user_pub_resps aupr,
541: jtf_tasks_b jt
542: WHERE jta.task_assignment_id = p_taskassgid
543: AND jta.assignee_role = 'ASSIGNEE'
544: AND au.resource_id = jta.resource_id

Line 925: asg_user au,

921: jt.source_object_type_code,
922: csi.incident_location_type
923: FROM csm_task_assignments_acc acc,
924: jtf_task_assignments jta,
925: asg_user au,
926: asg_user_pub_resps aupr,
927: jtf_tasks_b jt,
928: cs_incidents_all_b csi,
929: hz_party_sites hz_ps

Line 926: asg_user_pub_resps aupr,

922: csi.incident_location_type
923: FROM csm_task_assignments_acc acc,
924: jtf_task_assignments jta,
925: asg_user au,
926: asg_user_pub_resps aupr,
927: jtf_tasks_b jt,
928: cs_incidents_all_b csi,
929: hz_party_sites hz_ps
930: WHERE acc.task_assignment_id = p_task_assignment_id

Line 957: asg_user au,

953: jt.source_object_type_code,
954: csi.incident_location_type
955: FROM csm_task_assignments_acc acc,
956: jtf_task_assignments jta,
957: asg_user au,
958: asg_user_pub_resps aupr,
959: jtf_tasks_b jt,
960: cs_incidents_all_b csi,
961: hz_locations lc

Line 958: asg_user_pub_resps aupr,

954: csi.incident_location_type
955: FROM csm_task_assignments_acc acc,
956: jtf_task_assignments jta,
957: asg_user au,
958: asg_user_pub_resps aupr,
959: jtf_tasks_b jt,
960: cs_incidents_all_b csi,
961: hz_locations lc
962: WHERE acc.task_assignment_id = p_task_assignment_id

Line 989: asg_user au,

985: jt.source_object_type_code,
986: TO_CHAR(NULL)
987: FROM csm_task_assignments_acc acc,
988: JTF_TASK_ASSIGNMENTS jta,
989: asg_user au,
990: asg_user_pub_resps aupr,
991: jtf_tasks_b jt
992: WHERE acc.task_assignment_id = p_task_assignment_id
993: AND acc.task_assignment_id = jta.task_assignment_id

Line 990: asg_user_pub_resps aupr,

986: TO_CHAR(NULL)
987: FROM csm_task_assignments_acc acc,
988: JTF_TASK_ASSIGNMENTS jta,
989: asg_user au,
990: asg_user_pub_resps aupr,
991: jtf_tasks_b jt
992: WHERE acc.task_assignment_id = p_task_assignment_id
993: AND acc.task_assignment_id = jta.task_assignment_id
994: AND acc.user_id = au.user_id