APPS.HZ_PURGE_GEN dependencies on PON_SUPPLIER_ACTIVITIES

Line 4056: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_ID

4052: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4053: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARAMETER_VALUE from JTF_PERZ_QUERY_PARAM_V xx
4054: 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%' ));
4055: end if;
4056: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_ID
4057: appid:=396;
4058: if(regid_proc = true) then
4059: 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
4060:

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

4057: appid:=396;
4058: if(regid_proc = true) then
4059: 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
4060:
4061: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx
4062: );
4063: else
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

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

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

Line 4320: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID

4316: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4317: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx
4318: );
4319: end if;
4320: --PON_SUPPLIER_ACTIVITIES;TRADING_PARTNER_CONTACT_ID
4321: appid:=396;
4322: if(regid_proc = true) then
4323: 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
4324:

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

4321: appid:=396;
4322: if(regid_proc = true) then
4323: 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
4324:
4325: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4326: );
4327: else
4328: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4329: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx

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

4325: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4326: );
4327: else
4328: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4329: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx
4330: );
4331: end if;
4332: --PON_AUCTION_HEADERS_ALL;DRAFT_LOCKED_BY_CONTACT_ID
4333: appid:=396;