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 340: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link

336:
337: -- Fixed bug 3509580, added UNION for party_site_id stored in incident_location_id where incident_location_type is 'HZ_PARTY_SITE'
338: CURSOR l_IncidentId_withAddr_csr IS
339: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
340: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link
341: WHERE sr.INCIDENT_LOCATION_ID = loc.LOCATION_ID AND
342: sr.incident_location_type = 'HZ_LOCATION' AND
343: 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') =
344: nvl(upper(l_incident_address.incident_address), 'Not Filled') AND

Line 358: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites

354: sr_link.end_date_active(+) is null and
355: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
356: UNION
357: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
358: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites
359: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
360: sr.incident_location_type = 'HZ_PARTY_SITE' AND
361: sites.location_id = loc.location_id AND
362: 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 415: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link

411:
412: -- Fixed bug 3509580, added UNION for party_site_id stored in incident_location_id where incident_location_type is 'HZ_PARTY_SITE'
413: CURSOR l_IncidentId_withAddrUpd_csr IS
414: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
415: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link
416: WHERE sr.INCIDENT_LOCATION_ID = loc.LOCATION_ID AND
417: sr.incident_location_type = 'HZ_LOCATION' AND
418: 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') =
419: nvl(upper(l_incident_address.incident_address), 'Not Filled') AND

Line 434: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites

430: sr_link.end_date_active(+) is null and
431: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
432: UNION
433: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
434: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites
435: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
436: sr.incident_location_type = 'HZ_PARTY_SITE' AND
437: sites.location_id = loc.location_id AND
438: 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') =