APPS.HZ_PURGE_GEN dependencies on PON_SUPPLIER_ACTIVITIES

Line 4156: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_ID

4152: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4153: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARAMETER_VALUE from JTF_PERZ_QUERY_PARAM_V xx
4154: where (parameter_name in ('CUSTOMER_ID','SR_CUSTOMER_ID') and application_id = 514 and query_type like 'ADV_SEARCH_%' and profile_name like 'CSS_514%' ));
4155: end if;
4156: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_ID
4157: appid:=396;
4158: if(regid_proc = true) then
4159: 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
4160:

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

4157: appid:=396;
4158: if(regid_proc = true) then
4159: 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
4160:
4161: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx
4162: );
4163: else
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

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

4161: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx
4162: );
4163: else
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;

Line 4420: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID

4416: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4417: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4418: );
4419: end if;
4420: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID
4421: appid:=396;
4422: if(regid_proc = true) then
4423: 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
4424:

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

4421: appid:=396;
4422: if(regid_proc = true) then
4423: 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
4424:
4425: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4426: );
4427: else
4428: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4429: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx

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

4425: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4426: );
4427: else
4428: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4429: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4430: );
4431: end if;
4432: --PON_AUCTION_HEADERS_ALL;DRAFT_LOCKED_BY_CONTACT_ID
4433: appid:=396;