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 CS_INCIDENTS_ALL_B

Line 54: cs_incidents_all_b cia,

50: OR jts_jta.cancelled_flag = 'Y' OR jts_jta.closed_flag = 'Y'
51: OR jts_jta.completed_flag = 'Y' OR jts_jta.rejected_flag = 'Y')
52: AND NOT EXISTS (SELECT 'x'
53: FROM csm_service_history_acc hist,
54: cs_incidents_all_b cia,
55: cs_incident_statuses_b ists
56: WHERE hist.user_id = acc.user_id
57: AND hist.history_incident_id = jt.source_object_id
58: AND jt.source_object_type_code = 'SR'

Line 480: cs_incidents_all_b csi,

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
483: AND jta.assignee_role = 'ASSIGNEE'
484: AND au.resource_id = jta.resource_id

Line 511: cs_incidents_all_b csi,

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
514: AND jta.assignee_role = 'ASSIGNEE'
515: AND au.resource_id = jta.resource_id

Line 755: cs_incidents_all_b csi,

751: jt.source_object_type_code,
752: csi.incident_location_type
753: FROM JTF_TASK_ASSIGNMENTS jta,
754: jtf_tasks_b jt,
755: cs_incidents_all_b csi,
756: hz_party_sites hz_ps
757: WHERE jta.task_assignment_id = p_taskassgid
758: AND jt.task_id = jta.task_id
759: AND jt.source_object_type_code = 'SR'

Line 780: cs_incidents_all_b csi,

776: jt.source_object_type_code,
777: csi.incident_location_type
778: FROM JTF_TASK_ASSIGNMENTS jta,
779: jtf_tasks_b jt,
780: cs_incidents_all_b csi,
781: hz_locations lc
782: WHERE jta.task_assignment_id = p_taskassgid
783: AND jt.task_id = jta.task_id
784: AND jt.source_object_type_code = 'SR'

Line 928: cs_incidents_all_b csi,

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
931: AND acc.task_assignment_id = jta.task_assignment_id
932: AND acc.user_id = au.user_id

Line 960: cs_incidents_all_b csi,

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
963: AND acc.task_assignment_id = jta.task_assignment_id
964: AND acc.user_id = au.user_id

Line 1466: cs_incidents_all_b csi,

1462: jt.source_object_type_code,
1463: csi.incident_location_type
1464: FROM JTF_TASK_ASSIGNMENTS jta,
1465: jtf_tasks_b jt,
1466: cs_incidents_all_b csi,
1467: hz_party_sites hz_ps
1468: WHERE jta.task_assignment_id = p_task_assignment_id
1469: AND jt.task_id = jta.task_id
1470: AND jt.source_object_type_code = 'SR'

Line 1491: cs_incidents_all_b csi,

1487: jt.source_object_type_code,
1488: csi.incident_location_type
1489: FROM JTF_TASK_ASSIGNMENTS jta,
1490: jtf_tasks_b jt,
1491: cs_incidents_all_b csi,
1492: hz_locations lc
1493: WHERE jta.task_assignment_id = p_task_assignment_id
1494: AND jt.task_id = jta.task_id
1495: AND jt.source_object_type_code = 'SR'