APPS.HZ_PURGE_GEN dependencies on PON_ACKNOWLEDGEMENTS

Line 4288: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_CONTACT_ID

4284: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4285: temp.party_id in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx
4286: );
4287: end if;
4288: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_CONTACT_ID
4289: appid:=396;
4290: if(regid_proc = true) then
4291: 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
4292:

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

4289: appid:=396;
4290: if(regid_proc = true) then
4291: 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
4292:
4293: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4294: );
4295: else
4296: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4297: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

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

4293: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4294: );
4295: else
4296: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4297: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4298: );
4299: end if;
4300: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID
4301: appid:=396;

Line 4300: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID

4296: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4297: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4298: );
4299: end if;
4300: --PON_ACKNOWLEDGEMENTS;SURROG_BID_ACK_TP_ID
4301: appid:=396;
4302: if(regid_proc = true) then
4303: 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
4304:

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

4301: appid:=396;
4302: if(regid_proc = true) then
4303: 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
4304:
4305: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4306: );
4307: else
4308: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4309: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx

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

4305: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4306: );
4307: else
4308: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4309: temp.party_id in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx
4310: );
4311: end if;
4312: --PON_SUPPLIER_ACCESS;BUYER_TP_CONTACT_ID
4313: appid:=396;

Line 4372: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID

4368: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4369: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4370: );
4371: end if;
4372: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID
4373: appid:=396;
4374: if(regid_proc = true) then
4375: 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
4376:

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

4373: appid:=396;
4374: if(regid_proc = true) then
4375: 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
4376:
4377: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4378: );
4379: else
4380: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4381: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx

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

4377: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4378: );
4379: else
4380: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4381: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4382: );
4383: end if;
4384: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID
4385: appid:=396;

Line 4384: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID

4380: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4381: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx
4382: );
4383: end if;
4384: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_ID
4385: appid:=396;
4386: if(regid_proc = true) then
4387: 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
4388:

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

4385: appid:=396;
4386: if(regid_proc = true) then
4387: 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
4388:
4389: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4390: );
4391: else
4392: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4393: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx

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

4389: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4390: );
4391: else
4392: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4393: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx
4394: );
4395: end if;
4396: --PON_AUCTION_SUMMARY;TRADING_PARTNER_CONTACT_ID
4397: appid:=396;