APPS.HZ_PURGE_GEN dependencies on CS_INCIDENTS_ALL_B

Line 2799: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id

2795: if(regid_proc = true) then
2796: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where
2797:
2798:
2799: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2800: )
2801:
2802: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2803: and (CONTACT_TYPE <> 'EMPLOYEE'))

Line 2824: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id

2820: else
2821: delete from hz_purge_gt temp where
2822:
2823:
2824: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2825: )
2826:
2827: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2828: and (CONTACT_TYPE <> 'EMPLOYEE'))

Line 5110: --CS_INCIDENTS_ALL_B;SITE_ID

5106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5107: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5108: );
5109: end if;
5110: --CS_INCIDENTS_ALL_B;SITE_ID
5111: appid:=170;
5112: if(regid_proc = true) then
5113: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5114:

Line 5119: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B

5115: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5116: xx
5117: where (nvl(STATUS, 'A') in ('A','I'))
5118: and xx.PARTY_SITE_ID
5119: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
5120: yy
5121: ));
5122: else
5123: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5128: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B

5124: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5125: xx
5126: where (nvl(STATUS, 'A') in ('A','I'))
5127: and xx.PARTY_SITE_ID
5128: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
5129: yy
5130: ));
5131: end if;
5132: --CS_INCIDENTS_AUDIT_B;SITE_ID

Line 5154: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID

5150: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
5151: yy
5152: ));
5153: end if;
5154: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID
5155: appid:=170;
5156: if(regid_proc = true) then
5157: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5158:

Line 5163: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B

5159: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5160: xx
5161: where (nvl(STATUS, 'A') in ('A','I'))
5162: and xx.PARTY_SITE_ID
5163: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
5164: yy
5165: ));
5166: else
5167: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5172: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B

5168: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5169: xx
5170: where (nvl(STATUS, 'A') in ('A','I'))
5171: and xx.PARTY_SITE_ID
5172: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
5173: yy
5174: ));
5175: end if;
5176: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID

Line 5176: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID

5172: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
5173: yy
5174: ));
5175: end if;
5176: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID
5177: appid:=170;
5178: if(regid_proc = true) then
5179: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5180:

Line 5185: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B

5181: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5182: xx
5183: where (nvl(STATUS, 'A') in ('A','I'))
5184: and xx.PARTY_SITE_ID
5185: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
5186: yy
5187: ));
5188: else
5189: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5194: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B

5190: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5191: xx
5192: where (nvl(STATUS, 'A') in ('A','I'))
5193: and xx.PARTY_SITE_ID
5194: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
5195: yy
5196: ));
5197: end if;
5198: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID

Line 5198: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID

5194: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
5195: yy
5196: ));
5197: end if;
5198: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID
5199: appid:=170;
5200: if(regid_proc = true) then
5201: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5202:

Line 5207: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B

5203: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5204: xx
5205: where (nvl(STATUS, 'A') in ('A','I'))
5206: and xx.PARTY_SITE_ID
5207: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
5208: yy
5209: ));
5210: else
5211: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5216: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B

5212: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5213: xx
5214: where (nvl(STATUS, 'A') in ('A','I'))
5215: and xx.PARTY_SITE_ID
5216: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
5217: yy
5218: ));
5219: end if;
5220: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID

Line 5232: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID

5228: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5229: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5230: );
5231: end if;
5232: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID
5233: appid:=170;
5234: if(regid_proc = true) then
5235: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5236:

Line 5237: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

5233: appid:=170;
5234: if(regid_proc = true) then
5235: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5236:
5237: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5238: );
5239: else
5240: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5241: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

Line 5241: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

5237: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5238: );
5239: else
5240: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5241: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5242: );
5243: end if;
5244: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID
5245: appid:=170;

Line 5244: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID

5240: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5241: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5242: );
5243: end if;
5244: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID
5245: appid:=170;
5246: if(regid_proc = true) then
5247: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5248:

Line 5249: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

5245: appid:=170;
5246: if(regid_proc = true) then
5247: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5248:
5249: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5250: );
5251: else
5252: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5253: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

Line 5253: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

5249: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5250: );
5251: else
5252: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5253: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5254: );
5255: end if;
5256: --CS_CHG_SUB_RESTRICTIONS;VALUE_OBJECT_ID
5257: appid:=170;

Line 5268: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID

5264: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5265: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5266: );
5267: end if;
5268: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID
5269: appid:=170;
5270: if(regid_proc = true) then
5271: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5272:

Line 5273: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

5269: appid:=170;
5270: if(regid_proc = true) then
5271: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5272:
5273: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5274: );
5275: else
5276: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5277: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

Line 5277: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

5273: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5274: );
5275: else
5276: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5277: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5278: );
5279: end if;
5280: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID
5281: appid:=170;

Line 5280: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID

5276: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5277: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5278: );
5279: end if;
5280: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID
5281: appid:=170;
5282: if(regid_proc = true) then
5283: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5284:

Line 5285: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

5281: appid:=170;
5282: if(regid_proc = true) then
5283: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5284:
5285: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5286: );
5287: else
5288: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5289: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

Line 5289: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

5285: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5286: );
5287: else
5288: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5289: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5290: );
5291: end if;
5292: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID
5293: appid:=170;

Line 5292: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID

5288: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5289: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5290: );
5291: end if;
5292: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID
5293: appid:=170;
5294: if(regid_proc = true) then
5295: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5296:

Line 5301: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B

5297: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5298: xx
5299: where (nvl(STATUS, 'A') in ('A','I'))
5300: and xx.PARTY_SITE_ID
5301: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5302: yy
5303: ));
5304: else
5305: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5310: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B

5306: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5307: xx
5308: where (nvl(STATUS, 'A') in ('A','I'))
5309: and xx.PARTY_SITE_ID
5310: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5311: yy
5312: ));
5313: end if;
5314: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID

Line 5314: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID

5310: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5311: yy
5312: ));
5313: end if;
5314: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID
5315: appid:=170;
5316: if(regid_proc = true) then
5317: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5318:

Line 5323: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B

5319: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5320: xx
5321: where (nvl(STATUS, 'A') in ('A','I'))
5322: and xx.PARTY_SITE_ID
5323: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5324: yy
5325: ));
5326: else
5327: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5332: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B

5328: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5329: xx
5330: where (nvl(STATUS, 'A') in ('A','I'))
5331: and xx.PARTY_SITE_ID
5332: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5333: yy
5334: ));
5335: end if;
5336: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID

Line 5336: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID

5332: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5333: yy
5334: ));
5335: end if;
5336: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID
5337: appid:=170;
5338: if(regid_proc = true) then
5339: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5340:

Line 5345: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B

5341: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5342: xx
5343: where (nvl(STATUS, 'A') in ('A','I'))
5344: and xx.PARTY_SITE_ID
5345: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5346: yy
5347: ));
5348: else
5349: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5354: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B

5350: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5351: xx
5352: where (nvl(STATUS, 'A') in ('A','I'))
5353: and xx.PARTY_SITE_ID
5354: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5355: yy
5356: ));
5357: end if;
5358: --ECX_TP_HEADERS;PARTY_SITE_ID