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 485: cs_incidents_all_b csi,

481: FROM JTF_TASK_ASSIGNMENTS jta,
482: asg_user au,
483: asg_user_pub_resps aupr,
484: jtf_tasks_b jt,
485: cs_incidents_all_b csi,
486: hz_party_sites hz_ps
487: WHERE jta.task_assignment_id = p_taskassgid
488: AND jta.assignee_role = 'ASSIGNEE'
489: AND au.resource_id = jta.resource_id

Line 518: cs_incidents_all_b csi,

514: FROM JTF_TASK_ASSIGNMENTS jta,
515: asg_user au,
516: asg_user_pub_resps aupr,
517: jtf_tasks_b jt,
518: cs_incidents_all_b csi,
519: hz_locations lc
520: WHERE jta.task_assignment_id = p_taskassgid
521: AND jta.assignee_role = 'ASSIGNEE'
522: AND au.resource_id = jta.resource_id

Line 797: cs_incidents_all_b csi,

793: jt.source_object_type_code,
794: csi.incident_location_type
795: FROM JTF_TASK_ASSIGNMENTS jta,
796: jtf_tasks_b jt,
797: cs_incidents_all_b csi,
798: hz_party_sites hz_ps
799: WHERE jta.task_assignment_id = p_taskassgid
800: AND jt.task_id = jta.task_id
801: AND jt.source_object_type_code = 'SR'

Line 822: cs_incidents_all_b csi,

818: jt.source_object_type_code,
819: csi.incident_location_type
820: FROM JTF_TASK_ASSIGNMENTS jta,
821: jtf_tasks_b jt,
822: cs_incidents_all_b csi,
823: hz_locations lc
824: WHERE jta.task_assignment_id = p_taskassgid
825: AND jt.task_id = jta.task_id
826: AND jt.source_object_type_code = 'SR'

Line 972: cs_incidents_all_b csi,

968: jtf_task_assignments jta,
969: asg_user au,
970: asg_user_pub_resps aupr,
971: jtf_tasks_b jt,
972: cs_incidents_all_b csi,
973: hz_party_sites hz_ps
974: WHERE acc.task_assignment_id = p_task_assignment_id
975: AND acc.task_assignment_id = jta.task_assignment_id
976: AND acc.user_id = au.user_id

Line 1006: cs_incidents_all_b csi,

1002: jtf_task_assignments jta,
1003: asg_user au,
1004: asg_user_pub_resps aupr,
1005: jtf_tasks_b jt,
1006: cs_incidents_all_b csi,
1007: hz_locations lc
1008: WHERE acc.task_assignment_id = p_task_assignment_id
1009: AND acc.task_assignment_id = jta.task_assignment_id
1010: AND acc.user_id = au.user_id

Line 1538: cs_incidents_all_b csi,

1534: jt.source_object_type_code,
1535: csi.incident_location_type
1536: FROM JTF_TASK_ASSIGNMENTS jta,
1537: jtf_tasks_b jt,
1538: cs_incidents_all_b csi,
1539: hz_party_sites hz_ps
1540: WHERE jta.task_assignment_id = p_task_assignment_id
1541: AND jt.task_id = jta.task_id
1542: AND jt.source_object_type_code = 'SR'

Line 1563: cs_incidents_all_b csi,

1559: jt.source_object_type_code,
1560: csi.incident_location_type
1561: FROM JTF_TASK_ASSIGNMENTS jta,
1562: jtf_tasks_b jt,
1563: cs_incidents_all_b csi,
1564: hz_locations lc
1565: WHERE jta.task_assignment_id = p_task_assignment_id
1566: AND jt.task_id = jta.task_id
1567: AND jt.source_object_type_code = 'SR'