APPS.HZ_PURGE_GEN dependencies on PON_SUPPLIER_ACCESS

Line 4168: --PON_SUPPLIER_ACCESS;SUPPLIER_TRADING_PARTNER_ID

4164: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4165: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx
4166: );
4167: end if;
4168: --PON_SUPPLIER_ACCESS;SUPPLIER_TRADING_PARTNER_ID
4169: appid:=396;
4170: if(regid_proc = true) then
4171: 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
4172:

Line 4173: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx

4169: appid:=396;
4170: if(regid_proc = true) then
4171: 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
4172:
4173: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4174: );
4175: else
4176: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4177: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx

Line 4177: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx

4173: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4174: );
4175: else
4176: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4177: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4178: );
4179: end if;
4180: --PON_PARTY_LINE_EXCLUSIONS;TRADING_PARTNER_ID
4181: appid:=396;

Line 4312: --PON_SUPPLIER_ACCESS;BUYER_TP_CONTACT_ID

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;
4314: if(regid_proc = true) then
4315: 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
4316:

Line 4317: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx

4313: appid:=396;
4314: if(regid_proc = true) then
4315: 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
4316:
4317: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4318: );
4319: else
4320: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4321: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx

Line 4321: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx

4317: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4318: );
4319: else
4320: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4321: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4322: );
4323: end if;
4324: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID
4325: appid:=396;