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.CS_SR_DUP_CHK_PVT dependencies on HZ_LOCATIONS

Line 342: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

338:
339: -- Fixed bug 3509580, added UNION for party_site_id stored in incident_location_id where incident_location_type is 'HZ_PARTY_SITE'
340: CURSOR l_IncidentId_withAddr_csr IS
341: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
342: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
343: WHERE sr.INCIDENT_LOCATION_ID = loc.LOCATION_ID AND
344: sr.incident_location_type = 'HZ_LOCATION' AND
345: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =
346: nvl(upper(l_incident_address.incident_address), 'Not Filled') AND

Line 362: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

358: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
359: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
360: UNION
361: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
362: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
363: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
364: sr.incident_location_type = 'HZ_PARTY_SITE' AND
365: sites.location_id = loc.location_id AND
366: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =

Line 425: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

421:
422: -- Fixed bug 3509580, added UNION for party_site_id stored in incident_location_id where incident_location_type is 'HZ_PARTY_SITE'
423: CURSOR l_IncidentId_withAddrUpd_csr IS
424: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
425: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
426: WHERE sr.INCIDENT_LOCATION_ID = loc.LOCATION_ID AND
427: sr.incident_location_type = 'HZ_LOCATION' AND
428: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =
429: nvl(upper(l_incident_address.incident_address), 'Not Filled') AND

Line 446: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

442: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
443: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
444: UNION
445: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
446: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
447: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
448: sr.incident_location_type = 'HZ_PARTY_SITE' AND
449: sites.location_id = loc.location_id AND
450: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =