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 CS_INCIDENTS_B_SEC

Line 324: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

320: l_DuplicateTimeInfo_rec c_DuplicateTimeInfo_csr%ROWTYPE;
321:
322: CURSOR l_IncidentId_NoAddr_csr IS
323: SELECT sr.incident_id, sr.incident_number, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
324: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
325: WHERE sr.INCIDENT_TYPE_ID = l_incident_type_id and
326: sr.incident_id = sr_link.subject_id(+) and
327: sr_link.subject_type(+) = 'SR' and
328: sr_link.link_type(+) = 'DUP' and

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 383: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

379: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
380: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
381: UNION
382: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
383: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
384: WHERE nvl(upper(incident_ADDRESS), 'Not Filled') = nvl(upper(l_incident_address.incident_address), 'Not Filled') AND
385: nvl(upper(incident_CITY), 'Not Filled') = nvl(upper(l_incident_address.incident_city), 'Not Filled') AND
386: nvl(upper(incident_STATE), 'Not Filled') = nvl(upper(l_incident_address.incident_state), 'Not Filled') AND
387: nvl(upper(incident_POSTAL_CODE), 'Not Filled') = nvl(upper(l_incident_address.incident_postal_Code), 'Not Filled') AND

Line 407: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

403:
404: -- Cursor to find SR when called from iSupport
405: CURSOR l_IncidentId_NoAddrUpd_csr IS
406: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
407: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
408: WHERE sr.INCIDENT_TYPE_ID = l_incident_type_id and
409: sr.incident_id <> l_incident_id and
410: sr.LAST_UPDATE_DATE > l_duplicate_date and
411: sr.incident_id = sr_link.subject_id(+) and

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') =

Line 468: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

464: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
465: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
466: UNION
467: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
468: FROM cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
469: WHERE nvl(upper(incident_ADDRESS), 'Not Filled') = nvl(upper(l_incident_address.incident_address), 'Not Filled') AND
470: nvl(upper(incident_CITY), 'Not Filled') = nvl(upper(l_incident_address.incident_city), 'Not Filled') AND
471: nvl(upper(incident_STATE), 'Not Filled') = nvl(upper(l_incident_address.incident_state), 'Not Filled') AND
472: nvl(upper(incident_POSTAL_CODE), 'Not Filled') = nvl(upper(l_incident_address.incident_postal_Code), 'Not Filled') AND

Line 906: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

902: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
903:
904: Cursor l_dup_sr_serialnum_csr is
905: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
906: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
907: where sr.incident_id = sr_link.subject_id(+) and
908: sr_link.subject_type(+) = 'SR' and
909: sr_link.link_type(+) = 'DUP' and
910: sr_link.end_date_active(+) is null and

Line 922: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

918: l_dup_sr_serialnum_rec l_dup_sr_serialnum_csr%rowtype;
919:
920: Cursor l_dup_sr_serialnumUpd_csr is
921: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
922: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
923: where sr.incident_id = sr_link.subject_id(+) and
924: sr_link.subject_type(+) = 'SR' and
925: sr_link.link_type(+) = 'DUP' and
926: sr_link.end_date_active(+) is null and

Line 939: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

935:
936:
937: Cursor l_dup_sr_InstSerNum_csr is
938: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
939: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
940: where sr.incident_id = sr_link.subject_id(+) and
941: sr_link.subject_type(+) = 'SR' and
942: sr_link.link_type(+) = 'DUP' and
943: sr_link.end_date_active(+) is null and

Line 956: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst ,cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

952: l_dup_sr_InstSerNum_rec l_dup_sr_InstSerNum_csr%rowtype;
953:
954: Cursor l_dup_sr_InstSerNumUpd_csr is
955: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
956: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst ,cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
957: where sr.incident_id = sr_link.subject_id(+) and
958: sr_link.subject_type(+) = 'SR' and
959: sr_link.link_type(+) = 'DUP' and
960: sr_link.end_date_active(+) is null and

Line 973: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

969: l_dup_sr_InstSerNumUpd_rec l_dup_sr_InstSerNumUpd_csr%rowtype;
970:
971: Cursor l_dup_sr_ItemSerNum_csr is
972: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
973: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
974: where sr.incident_id = sr_link.subject_id(+) and
975: sr_link.subject_type(+) = 'SR' and
976: sr_link.link_type(+) = 'DUP' and
977: sr_link.end_date_active(+) is null and

Line 988: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

984: l_dup_sr_ItemSerNum_rec l_dup_sr_ItemSerNum_csr%rowtype;
985:
986: Cursor l_dup_sr_ItemSerNumUpd_csr is
987: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
988: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
989: where sr.incident_id = sr_link.subject_id(+) and
990: sr_link.subject_type(+) = 'SR' and
991: sr_link.link_type(+) = 'DUP' and
992: sr_link.end_date_active(+) is null and

Line 1130: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1126: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1127:
1128: Cursor l_dup_sr_instance_csr is
1129: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1130: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1131: where sr.incident_id = sr_link.subject_id(+) and
1132: sr_link.link_type(+) = 'DUP' and
1133: sr_link.subject_type(+) = 'SR' and
1134: sr_link.end_date_active(+) is null and

Line 1147: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1143: l_dup_sr_instance_rec l_dup_sr_instance_csr%rowtype;
1144:
1145: Cursor l_dup_sr_instanceUpd_csr is
1146: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1147: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1148: where sr.incident_id = sr_link.subject_id(+) and
1149: sr_link.subject_type(+) = 'SR' and
1150: sr_link.link_type(+) = 'DUP' and
1151: sr_link.end_date_active(+) is null and

Line 1235: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1231: l_dup_counter number := 0;
1232:
1233: Cursor l_dup_sr_custprod_csr is
1234: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1235: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1236: where sr.incident_id = sr_link.subject_id(+) and
1237: sr_link.subject_type(+) = 'SR' and
1238: sr_link.link_type(+) = 'DUP' and
1239: sr_link.end_date_active(+) is null and

Line 1252: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1248: l_dup_sr_custprod_rec l_dup_sr_custprod_csr%rowtype;
1249:
1250: Cursor l_dup_sr_custprodUpd_csr is
1251: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1252: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1253: where sr.incident_id = sr_link.subject_id(+) and
1254: sr_link.subject_type(+) = 'SR' and
1255: sr_link.link_type(+) = 'DUP' and
1256: sr_link.end_date_active(+) is null and

Line 1343: from cs_incidents_b_sec sr, cs_incident_links sr_link, cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1339: l_dup_counter number := 0;
1340:
1341: Cursor l_dup_sr_custprodsr_csr is
1342: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1343: from cs_incidents_b_sec sr, cs_incident_links sr_link, cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1344: where sr.incident_id = sr_link.subject_id(+) and
1345: sr_link.subject_type(+) = 'SR' and
1346: sr_link.link_type(+) = 'DUP' and
1347: sr_link.end_date_active(+) is null and

Line 1361: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1357: l_dup_sr_custprodsr_rec l_dup_sr_custprodsr_csr%rowtype;
1358:
1359: Cursor l_dup_sr_custprodsrUpd_csr is
1360: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1361: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1362: where sr.incident_id = sr_link.subject_id(+) and
1363: sr_link.subject_type(+) = 'SR' and
1364: sr_link.link_type(+) = 'DUP' and
1365: sr_link.end_date_active(+) is null and

Line 1380: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1376: l_dup_sr_custprodsrupd_rec l_dup_sr_custprodsrUpd_csr%rowtype;
1377:
1378: Cursor l_dup_sr_CustProdInsSer_csr is
1379: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1380: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1381: where sr.incident_id = sr_link.subject_id(+) and
1382: sr_link.subject_type(+) = 'SR' and
1383: sr_link.link_type(+) = 'DUP' and
1384: sr_link.end_date_active(+) is null and

Line 1399: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1395: l_dup_sr_CustProdInsSer_rec l_dup_sr_CustProdInsSer_csr%rowtype;
1396:
1397: Cursor l_dup_sr_CustProdInsSerUpd_csr is
1398: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1399: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1400: where sr.incident_id = sr_link.subject_id(+) and
1401: sr_link.subject_type(+) = 'SR' and
1402: sr_link.link_type(+) = 'DUP' and
1403: sr_link.end_date_active(+) is null and

Line 1419: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1415: l_dup_sr_CustProdInsSerUpd_rec l_dup_sr_CustProdInsSerUpd_csr%rowtype;
1416:
1417: Cursor l_dup_sr_CustProdItmSer_csr is
1418: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1419: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1420: where sr.incident_id = sr_link.subject_id(+) and
1421: sr_link.subject_type(+) = 'SR' and
1422: sr_link.link_type(+) = 'DUP' and
1423: sr_link.end_date_active(+) is null and

Line 1436: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

1432: l_dup_sr_CustProdItmSer_rec l_dup_sr_CustProdItmSer_csr%rowtype;
1433:
1434: Cursor l_dup_sr_CustProdItmSerUpd_csr is
1435: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1436: from cs_incidents_b_sec sr, cs_incident_links sr_link , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
1437: where sr.incident_id = sr_link.subject_id(+) and
1438: sr_link.subject_type(+) = 'SR' and
1439: sr_link.link_type(+) = 'DUP' and
1440: sr_link.end_date_active(+) is null and