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_NOTIFICATION_EVENT_PKG dependencies on HZ_LOCATIONS

Line 947: || NVL2(POSTAL_CODE,' '||POSTAL_CODE,'') ADDRESS from hz_locations where location_id= b_loc_id;

943: IS
944: select ADDRESS1 || NVL2(ADDRESS2,', '||ADDRESS2,'')
945: || NVL2(ADDRESS3,', '||ADDRESS3,'') || NVL2(ADDRESS4,', '||ADDRESS4,'')
946: || NVL2(CITY,', '||CITY,'') || NVL2(STATE,', '||STATE,'') || NVL2(COUNTRY,', '||COUNTRY,'')
947: || NVL2(POSTAL_CODE,' '||POSTAL_CODE,'') ADDRESS from hz_locations where location_id= b_loc_id;
948:
949: BEGIN
950: open c_location(p_loc_id);
951: fetch c_location INTO l_location;

Line 1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))

1087: INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name ,
1088: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr

Line 1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))

1115: INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name ,
1116: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1117: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1118: 'HZ_LOCATION',
1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr

Line 1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))

1173: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address,acc.INCIDENT_ID,INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name,
1174: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,
1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1181: WHERE acc.incident_id=b_inc_id