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_EMAIL_QUERY_PKG dependencies on HZ_PARTIES

Line 833: hz_parties hzp,

829: jtf_task_assignments a,
830: jtf_tasks_b ct,
831: jtf_tasks_tl ctl,
832: cs_incidents_all_b cia,
833: hz_parties hzp,
834: jtf_task_statuses_b jts,
835: jtf_task_statuses_tl jtstl
836: WHERE res.user_id IN '|| l_user_lst || '
837: AND a.resource_id = res.resource_id

Line 875: hz_parties hzp,

871: FROM jtf_task_assignments a,
872: jtf_tasks_b ct,
873: jtf_tasks_tl ctl,
874: cs_incidents_all_b cia,
875: hz_parties hzp,
876: jtf_task_statuses_b jts,
877: jtf_task_statuses_tl jtstl,
878: jtf_rs_groups_tl gtl
879: WHERE a.resource_type_code = ''RS_GROUP''

Line 1455: hz_parties hzp,

1451: jtf_task_statuses_b ts,
1452: jtf_task_statuses_tl tstl,
1453: cs_incidents_all_b csb,
1454: cs_incidents_all_tl cstl,
1455: hz_parties hzp,
1456: hz_party_sites hzps,
1457: hz_locations hzloc
1458: WHERE tsk.task_number = p_task_number
1459: AND tsktl.task_id = tsk.task_id

Line 1654: hz_parties hzp

1650: cs_incident_severities isev,
1651: cs_incident_severities_tl isevtl,
1652: cs_incident_statuses ist,
1653: cs_incident_statuses_tl isttl,
1654: hz_parties hzp
1655: WHERE csb.incident_id = p_incident_id
1656: AND cstl.incident_id = csb.incident_id
1657: AND cstl.LANGUAGE = userenv('LANG')
1658: AND it.incident_type_id(+) = csb.incident_type_id