APPS.HZ_PURGE_GEN dependencies on ASO_SHIPMENTS

Line 901: (select 'Y' from ASO_SHIPMENTS

897: or exists (select 'Y' from HZ_PARTY_SITES
898: xx where xx.PARTY_ID = temp.party_id
899: and (nvl(STATUS, 'A') in ('A','I'))
900: and exists
901: (select 'Y' from ASO_SHIPMENTS
902: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
903: ))
904:
905: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

Line 946: (select 'Y' from ASO_SHIPMENTS

942: or exists (select 'Y' from HZ_PARTY_SITES
943: xx where xx.PARTY_ID = temp.party_id
944: and (nvl(STATUS, 'A') in ('A','I'))
945: and exists
946: (select 'Y' from ASO_SHIPMENTS
947: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
948: ))
949:
950: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

Line 3776: --ASO_SHIPMENTS;SHIP_TO_PARTY_ID

3772: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3773: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3774: );
3775: end if;
3776: --ASO_SHIPMENTS;SHIP_TO_PARTY_ID
3777: appid:=697;
3778: if(regid_proc = true) then
3779: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3780:

Line 3781: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx

3777: appid:=697;
3778: if(regid_proc = true) then
3779: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3780:
3781: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3782: );
3783: else
3784: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3785: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx

Line 3785: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx

3781: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3782: );
3783: else
3784: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3785: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3786: );
3787: end if;
3788: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_SITE_ID
3789: appid:=697;

Line 3878: --ASO_SHIPMENTS;SHIP_TO_CUST_PARTY_ID

3874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3875: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3876: );
3877: end if;
3878: --ASO_SHIPMENTS;SHIP_TO_CUST_PARTY_ID
3879: appid:=697;
3880: if(regid_proc = true) then
3881: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3882:

Line 3883: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx

3879: appid:=697;
3880: if(regid_proc = true) then
3881: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3882:
3883: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3884: );
3885: else
3886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx

Line 3887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx

3883: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3884: );
3885: else
3886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3888: );
3889: end if;
3890: --OKE_POOL_PARTIES;PARTY_ID
3891: appid:=777;