APPS.HZ_PURGE_GEN dependencies on PON_SUPPLIER_ACCESS

Line 4068: --PON_SUPPLIER_ACCESS;SUPPLIER_TRADING_PARTNER_ID

4064: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4065: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx
4066: );
4067: end if;
4068: --PON_SUPPLIER_ACCESS;SUPPLIER_TRADING_PARTNER_ID
4069: appid:=396;
4070: if(regid_proc = true) then
4071: 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
4072:

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

4069: appid:=396;
4070: if(regid_proc = true) then
4071: 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
4072:
4073: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4074: );
4075: else
4076: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4077: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx

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

4073: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4074: );
4075: else
4076: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4077: temp.party_id in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx
4078: );
4079: end if;
4080: --PON_PARTY_LINE_EXCLUSIONS;TRADING_PARTNER_ID
4081: appid:=396;

Line 4212: --PON_SUPPLIER_ACCESS;BUYER_TP_CONTACT_ID

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;
4214: if(regid_proc = true) then
4215: 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
4216:

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

4213: appid:=396;
4214: if(regid_proc = true) then
4215: 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
4216:
4217: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4218: );
4219: else
4220: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4221: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx

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

4217: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4218: );
4219: else
4220: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4221: temp.party_id in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx
4222: );
4223: end if;
4224: --PON_BIDDING_PARTIES;TRADING_PARTNER_CONTACT_ID
4225: appid:=396;