APPS.HZ_PURGE_GEN dependencies on PON_ACKNOWLEDGEMENTS

Line 4188: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_CONTACT_ID

4184: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4185: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx
4186: );
4187: end if;
4188: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_CONTACT_ID
4189: appid:=396;
4190: if(regid_proc = true) then
4191: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4192:

Line 4193: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

4189: appid:=396;
4190: if(regid_proc = true) then
4191: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4192:
4193: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4194: );
4195: else
4196: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4197: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

Line 4197: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

4193: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4194: );
4195: else
4196: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4197: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4198: );
4199: end if;
4200: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID
4201: appid:=396;

Line 4200: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID

4196: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4197: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4198: );
4199: end if;
4200: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID
4201: appid:=396;
4202: if(regid_proc = true) then
4203: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4204:

Line 4205: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx

4201: appid:=396;
4202: if(regid_proc = true) then
4203: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4204:
4205: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4206: );
4207: else
4208: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4209: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx

Line 4209: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx

4205: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4206: );
4207: else
4208: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4209: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4210: );
4211: end if;
4212: --PON_SUPPLIER_ACCESS;BUYER_TP_CONTACT_ID
4213: appid:=396;

Line 4272: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID

4268: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4269: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4270: );
4271: end if;
4272: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID
4273: appid:=396;
4274: if(regid_proc = true) then
4275: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4276:

Line 4277: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

4273: appid:=396;
4274: if(regid_proc = true) then
4275: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4276:
4277: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4278: );
4279: else
4280: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

Line 4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

4277: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4278: );
4279: else
4280: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4282: );
4283: end if;
4284: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID
4285: appid:=396;

Line 4284: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID

4280: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4281: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4282: );
4283: end if;
4284: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID
4285: appid:=396;
4286: if(regid_proc = true) then
4287: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4288:

Line 4289: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx

4285: appid:=396;
4286: if(regid_proc = true) then
4287: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4288:
4289: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4290: );
4291: else
4292: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4293: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx

Line 4293: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx

4289: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4290: );
4291: else
4292: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4293: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4294: );
4295: end if;
4296: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID
4297: appid:=396;