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

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
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 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 377: FROM cs_incidents_b_sec sr, cs_incident_links sr_link

373: sr_link.end_date_active(+) is null and
374: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
375: UNION
376: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
377: FROM cs_incidents_b_sec sr, cs_incident_links sr_link
378: WHERE nvl(upper(incident_ADDRESS), 'Not Filled') = nvl(upper(l_incident_address.incident_address), 'Not Filled') AND
379: nvl(upper(incident_CITY), 'Not Filled') = nvl(upper(l_incident_address.incident_city), 'Not Filled') AND
380: nvl(upper(incident_STATE), 'Not Filled') = nvl(upper(l_incident_address.incident_state), 'Not Filled') AND
381: nvl(upper(incident_POSTAL_CODE), 'Not Filled') = nvl(upper(l_incident_address.incident_postal_Code), 'Not Filled') AND

Line 399: FROM cs_incidents_b_sec sr, cs_incident_links sr_link

395:
396: -- Cursor to find SR when called from iSupport
397: CURSOR l_IncidentId_NoAddrUpd_csr IS
398: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
399: FROM cs_incidents_b_sec sr, cs_incident_links sr_link
400: WHERE sr.INCIDENT_TYPE_ID = l_incident_type_id and
401: sr.incident_id <> l_incident_id and
402: sr.LAST_UPDATE_DATE > l_duplicate_date and
403: sr.incident_id = sr_link.subject_id(+) and

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

Line 454: FROM cs_incidents_b_sec sr, cs_incident_links sr_link

450: sr_link.end_date_active(+) is null and
451: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
452: UNION
453: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
454: FROM cs_incidents_b_sec sr, cs_incident_links sr_link
455: WHERE nvl(upper(incident_ADDRESS), 'Not Filled') = nvl(upper(l_incident_address.incident_address), 'Not Filled') AND
456: nvl(upper(incident_CITY), 'Not Filled') = nvl(upper(l_incident_address.incident_city), 'Not Filled') AND
457: nvl(upper(incident_STATE), 'Not Filled') = nvl(upper(l_incident_address.incident_state), 'Not Filled') AND
458: nvl(upper(incident_POSTAL_CODE), 'Not Filled') = nvl(upper(l_incident_address.incident_postal_Code), 'Not Filled') AND

Line 890: from cs_incidents_b_sec sr, cs_incident_links sr_link

886: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
887:
888: Cursor l_dup_sr_serialnum_csr is
889: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
890: from cs_incidents_b_sec sr, cs_incident_links sr_link
891: where sr.incident_id = sr_link.subject_id(+) and
892: sr_link.subject_type(+) = 'SR' and
893: sr_link.link_type(+) = 'DUP' and
894: sr_link.end_date_active(+) is null and

Line 903: from cs_incidents_b_sec sr, cs_incident_links sr_link

899: l_dup_sr_serialnum_rec l_dup_sr_serialnum_csr%rowtype;
900:
901: Cursor l_dup_sr_serialnumUpd_csr is
902: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
903: from cs_incidents_b_sec sr, cs_incident_links sr_link
904: where sr.incident_id = sr_link.subject_id(+) and
905: sr_link.subject_type(+) = 'SR' and
906: sr_link.link_type(+) = 'DUP' and
907: sr_link.end_date_active(+) is null and

Line 918: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

914:
915:
916: Cursor l_dup_sr_InstSerNum_csr is
917: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
918: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
919: where sr.incident_id = sr_link.subject_id(+) and
920: sr_link.subject_type(+) = 'SR' and
921: sr_link.link_type(+) = 'DUP' and
922: sr_link.end_date_active(+) is null and

Line 933: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

929: l_dup_sr_InstSerNum_rec l_dup_sr_InstSerNum_csr%rowtype;
930:
931: Cursor l_dup_sr_InstSerNumUpd_csr is
932: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
933: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
934: where sr.incident_id = sr_link.subject_id(+) and
935: sr_link.subject_type(+) = 'SR' and
936: sr_link.link_type(+) = 'DUP' and
937: sr_link.end_date_active(+) is null and

Line 948: from cs_incidents_b_sec sr, cs_incident_links sr_link

944: l_dup_sr_InstSerNumUpd_rec l_dup_sr_InstSerNumUpd_csr%rowtype;
945:
946: Cursor l_dup_sr_ItemSerNum_csr is
947: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
948: from cs_incidents_b_sec sr, cs_incident_links sr_link
949: where sr.incident_id = sr_link.subject_id(+) and
950: sr_link.subject_type(+) = 'SR' and
951: sr_link.link_type(+) = 'DUP' and
952: sr_link.end_date_active(+) is null and

Line 961: from cs_incidents_b_sec sr, cs_incident_links sr_link

957: l_dup_sr_ItemSerNum_rec l_dup_sr_ItemSerNum_csr%rowtype;
958:
959: Cursor l_dup_sr_ItemSerNumUpd_csr is
960: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
961: from cs_incidents_b_sec sr, cs_incident_links sr_link
962: where sr.incident_id = sr_link.subject_id(+) and
963: sr_link.subject_type(+) = 'SR' and
964: sr_link.link_type(+) = 'DUP' and
965: sr_link.end_date_active(+) is null and

Line 1099: from cs_incidents_b_sec sr, cs_incident_links sr_link

1095: l_cs_sr_dup_link_rec sr_dupl_link_tbl;
1096:
1097: Cursor l_dup_sr_instance_csr is
1098: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1099: from cs_incidents_b_sec sr, cs_incident_links sr_link
1100: where sr.incident_id = sr_link.subject_id(+) and
1101: sr_link.link_type(+) = 'DUP' and
1102: sr_link.subject_type(+) = 'SR' and
1103: sr_link.end_date_active(+) is null and

Line 1113: from cs_incidents_b_sec sr, cs_incident_links sr_link

1109: l_dup_sr_instance_rec l_dup_sr_instance_csr%rowtype;
1110:
1111: Cursor l_dup_sr_instanceUpd_csr is
1112: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1113: from cs_incidents_b_sec sr, cs_incident_links sr_link
1114: where sr.incident_id = sr_link.subject_id(+) and
1115: sr_link.subject_type(+) = 'SR' and
1116: sr_link.link_type(+) = 'DUP' and
1117: sr_link.end_date_active(+) is null and

Line 1194: from cs_incidents_b_sec sr, cs_incident_links sr_link

1190: l_dup_counter number := 0;
1191:
1192: Cursor l_dup_sr_custprod_csr is
1193: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1194: from cs_incidents_b_sec sr, cs_incident_links sr_link
1195: where sr.incident_id = sr_link.subject_id(+) and
1196: sr_link.subject_type(+) = 'SR' and
1197: sr_link.link_type(+) = 'DUP' and
1198: sr_link.end_date_active(+) is null and

Line 1209: from cs_incidents_b_sec sr, cs_incident_links sr_link

1205: l_dup_sr_custprod_rec l_dup_sr_custprod_csr%rowtype;
1206:
1207: Cursor l_dup_sr_custprodUpd_csr is
1208: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1209: from cs_incidents_b_sec sr, cs_incident_links sr_link
1210: where sr.incident_id = sr_link.subject_id(+) and
1211: sr_link.subject_type(+) = 'SR' and
1212: sr_link.link_type(+) = 'DUP' and
1213: sr_link.end_date_active(+) is null and

Line 1295: from cs_incidents_b_sec sr, cs_incident_links sr_link

1291: l_dup_counter number := 0;
1292:
1293: Cursor l_dup_sr_custprodsr_csr is
1294: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1295: from cs_incidents_b_sec sr, cs_incident_links sr_link
1296: where sr.incident_id = sr_link.subject_id(+) and
1297: sr_link.subject_type(+) = 'SR' and
1298: sr_link.link_type(+) = 'DUP' and
1299: sr_link.end_date_active(+) is null and

Line 1311: from cs_incidents_b_sec sr, cs_incident_links sr_link

1307: l_dup_sr_custprodsr_rec l_dup_sr_custprodsr_csr%rowtype;
1308:
1309: Cursor l_dup_sr_custprodsrUpd_csr is
1310: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1311: from cs_incidents_b_sec sr, cs_incident_links sr_link
1312: where sr.incident_id = sr_link.subject_id(+) and
1313: sr_link.subject_type(+) = 'SR' and
1314: sr_link.link_type(+) = 'DUP' and
1315: sr_link.end_date_active(+) is null and

Line 1328: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

1324: l_dup_sr_custprodsrupd_rec l_dup_sr_custprodsrUpd_csr%rowtype;
1325:
1326: Cursor l_dup_sr_CustProdInsSer_csr is
1327: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1328: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
1329: where sr.incident_id = sr_link.subject_id(+) and
1330: sr_link.subject_type(+) = 'SR' and
1331: sr_link.link_type(+) = 'DUP' and
1332: sr_link.end_date_active(+) is null and

Line 1345: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst

1341: l_dup_sr_CustProdInsSer_rec l_dup_sr_CustProdInsSer_csr%rowtype;
1342:
1343: Cursor l_dup_sr_CustProdInsSerUpd_csr is
1344: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1345: from cs_incidents_b_sec sr, cs_incident_links sr_link, csi_item_instances inst
1346: where sr.incident_id = sr_link.subject_id(+) and
1347: sr_link.subject_type(+) = 'SR' and
1348: sr_link.link_type(+) = 'DUP' and
1349: sr_link.end_date_active(+) is null and

Line 1363: from cs_incidents_b_sec sr, cs_incident_links sr_link

1359: l_dup_sr_CustProdInsSerUpd_rec l_dup_sr_CustProdInsSerUpd_csr%rowtype;
1360:
1361: Cursor l_dup_sr_CustProdItmSer_csr is
1362: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1363: from cs_incidents_b_sec sr, cs_incident_links sr_link
1364: where sr.incident_id = sr_link.subject_id(+) and
1365: sr_link.subject_type(+) = 'SR' and
1366: sr_link.link_type(+) = 'DUP' and
1367: sr_link.end_date_active(+) is null and

Line 1378: from cs_incidents_b_sec sr, cs_incident_links sr_link

1374: l_dup_sr_CustProdItmSer_rec l_dup_sr_CustProdItmSer_csr%rowtype;
1375:
1376: Cursor l_dup_sr_CustProdItmSerUpd_csr is
1377: select sr.incident_id, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
1378: from cs_incidents_b_sec sr, cs_incident_links sr_link
1379: where sr.incident_id = sr_link.subject_id(+) and
1380: sr_link.subject_type(+) = 'SR' and
1381: sr_link.link_type(+) = 'DUP' and
1382: sr_link.end_date_active(+) is null and