APPS.HZ_PURGE_GEN dependencies on CS_INCIDENTS_ALL_B

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

2702: if(regid_proc = true) then
2703: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where
2704:
2705:
2706: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2707: )
2708:
2709: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2710: and (CONTACT_TYPE <> 'EMPLOYEE'))

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

2727: else
2728: delete from hz_purge_gt temp where
2729:
2730:
2731: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2732: )
2733:
2734: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2735: and (CONTACT_TYPE <> 'EMPLOYEE'))

Line 4890: --CS_INCIDENTS_ALL_B;SITE_ID

4886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4888: );
4889: end if;
4890: --CS_INCIDENTS_ALL_B;SITE_ID
4891: appid:=170;
4892: if(regid_proc = true) then
4893: 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
4894:

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

4895: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4896: xx
4897: where (nvl(STATUS, 'A') in ('A','I'))
4898: and xx.PARTY_SITE_ID
4899: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
4900: yy
4901: ));
4902: else
4903: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4904: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4905: xx
4906: where (nvl(STATUS, 'A') in ('A','I'))
4907: and xx.PARTY_SITE_ID
4908: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
4909: yy
4910: ));
4911: end if;
4912: --CS_INCIDENTS_AUDIT_B;SITE_ID

Line 4934: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID

4930: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
4931: yy
4932: ));
4933: end if;
4934: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID
4935: appid:=170;
4936: if(regid_proc = true) then
4937: 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
4938:

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

4939: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4940: xx
4941: where (nvl(STATUS, 'A') in ('A','I'))
4942: and xx.PARTY_SITE_ID
4943: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
4944: yy
4945: ));
4946: else
4947: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4948: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4949: xx
4950: where (nvl(STATUS, 'A') in ('A','I'))
4951: and xx.PARTY_SITE_ID
4952: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
4953: yy
4954: ));
4955: end if;
4956: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID

Line 4956: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID

4952: in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
4953: yy
4954: ));
4955: end if;
4956: --CS_INCIDENTS_ALL_B;SHIP_TO_SITE_ID
4957: appid:=170;
4958: if(regid_proc = true) then
4959: 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
4960:

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

4961: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4962: xx
4963: where (nvl(STATUS, 'A') in ('A','I'))
4964: and xx.PARTY_SITE_ID
4965: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
4966: yy
4967: ));
4968: else
4969: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4970: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4971: xx
4972: where (nvl(STATUS, 'A') in ('A','I'))
4973: and xx.PARTY_SITE_ID
4974: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
4975: yy
4976: ));
4977: end if;
4978: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID

Line 4978: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID

4974: in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
4975: yy
4976: ));
4977: end if;
4978: --CS_INCIDENTS_ALL_B;INSTALL_SITE_ID
4979: appid:=170;
4980: if(regid_proc = true) then
4981: 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
4982:

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

4983: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4984: xx
4985: where (nvl(STATUS, 'A') in ('A','I'))
4986: and xx.PARTY_SITE_ID
4987: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
4988: yy
4989: ));
4990: else
4991: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4992: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4993: xx
4994: where (nvl(STATUS, 'A') in ('A','I'))
4995: and xx.PARTY_SITE_ID
4996: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
4997: yy
4998: ));
4999: end if;
5000: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID

Line 5012: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID

5008: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5009: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5010: );
5011: end if;
5012: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID
5013: appid:=170;
5014: if(regid_proc = true) then
5015: 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
5016:

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

5013: appid:=170;
5014: if(regid_proc = true) then
5015: 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
5016:
5017: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5018: );
5019: else
5020: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5021: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

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

5017: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5018: );
5019: else
5020: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5021: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5022: );
5023: end if;
5024: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID
5025: appid:=170;

Line 5024: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID

5020: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5021: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5022: );
5023: end if;
5024: --CS_INCIDENTS_ALL_B;SHIP_TO_PARTY_ID
5025: appid:=170;
5026: if(regid_proc = true) then
5027: 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
5028:

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

5025: appid:=170;
5026: if(regid_proc = true) then
5027: 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
5028:
5029: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5030: );
5031: else
5032: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5033: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx

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

5029: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5030: );
5031: else
5032: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5033: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5034: );
5035: end if;
5036: --CS_CHG_SUB_RESTRICTIONS;VALUE_OBJECT_ID
5037: appid:=170;

Line 5048: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID

5044: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5045: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5046: );
5047: end if;
5048: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID
5049: appid:=170;
5050: if(regid_proc = true) then
5051: 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
5052:

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

5049: appid:=170;
5050: if(regid_proc = true) then
5051: 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
5052:
5053: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5054: );
5055: else
5056: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5057: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

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

5053: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5054: );
5055: else
5056: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5057: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5058: );
5059: end if;
5060: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID
5061: appid:=170;

Line 5060: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID

5056: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5057: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5058: );
5059: end if;
5060: --CS_INCIDENTS_ALL_B;SHIP_TO_CONTACT_ID
5061: appid:=170;
5062: if(regid_proc = true) then
5063: 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
5064:

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

5061: appid:=170;
5062: if(regid_proc = true) then
5063: 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
5064:
5065: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5066: );
5067: else
5068: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5069: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx

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

5065: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5066: );
5067: else
5068: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5069: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5070: );
5071: end if;
5072: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID
5073: appid:=170;

Line 5072: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID

5068: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5069: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx
5070: );
5071: end if;
5072: --CS_INCIDENTS_ALL_B;CUSTOMER_SITE_ID
5073: appid:=170;
5074: if(regid_proc = true) then
5075: 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
5076:

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

5077: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5078: xx
5079: where (nvl(STATUS, 'A') in ('A','I'))
5080: and xx.PARTY_SITE_ID
5081: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5082: yy
5083: ));
5084: else
5085: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

5086: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5087: xx
5088: where (nvl(STATUS, 'A') in ('A','I'))
5089: and xx.PARTY_SITE_ID
5090: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5091: yy
5092: ));
5093: end if;
5094: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID

Line 5094: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID

5090: in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
5091: yy
5092: ));
5093: end if;
5094: --CS_INCIDENTS_ALL_B;INSTALL_SITE_USE_ID
5095: appid:=170;
5096: if(regid_proc = true) then
5097: 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
5098:

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

5099: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5100: xx
5101: where (nvl(STATUS, 'A') in ('A','I'))
5102: and xx.PARTY_SITE_ID
5103: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5104: yy
5105: ));
5106: else
5107: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

5108: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5109: xx
5110: where (nvl(STATUS, 'A') in ('A','I'))
5111: and xx.PARTY_SITE_ID
5112: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5113: yy
5114: ));
5115: end if;
5116: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID

Line 5116: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID

5112: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
5113: yy
5114: ));
5115: end if;
5116: --CS_INCIDENTS_ALL_B;INCIDENT_LOCATION_ID
5117: appid:=170;
5118: if(regid_proc = true) then
5119: 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
5120:

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

5121: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5122: xx
5123: where (nvl(STATUS, 'A') in ('A','I'))
5124: and xx.PARTY_SITE_ID
5125: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5126: yy
5127: ));
5128: else
5129: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

5130: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5131: xx
5132: where (nvl(STATUS, 'A') in ('A','I'))
5133: and xx.PARTY_SITE_ID
5134: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5135: yy
5136: ));
5137: end if;
5138: --ECX_TP_HEADERS;PARTY_SITE_ID