APPS.HZ_PURGE_GEN dependencies on ASO_QUOTE_LINES_ALL

Line 3712: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_ID

3708: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3709: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3710: );
3711: end if;
3712: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_ID
3713: appid:=697;
3714: if(regid_proc = true) then
3715: 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
3716:

Line 3717: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3713: appid:=697;
3714: if(regid_proc = true) then
3715: 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
3716:
3717: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3718: );
3719: else
3720: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3721: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3721: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3717: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3718: );
3719: else
3720: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3721: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3722: );
3723: end if;
3724: --ASO_SHIPMENTS;SHIP_TO_PARTY_ID
3725: appid:=697;

Line 3758: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_SITE_ID

3754: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3755: yy
3756: ));
3757: end if;
3758: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_SITE_ID
3759: appid:=697;
3760: if(regid_proc = true) then
3761: 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
3762:

Line 3767: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3763: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3764: xx
3765: where (nvl(STATUS, 'A') in ('A','I'))
3766: and xx.PARTY_SITE_ID
3767: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3768: yy
3769: ));
3770: else
3771: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3776: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3772: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3773: xx
3774: where (nvl(STATUS, 'A') in ('A','I'))
3775: and xx.PARTY_SITE_ID
3776: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3777: yy
3778: ));
3779: end if;
3780: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_CUST_PARTY_ID

Line 3814: --ASO_QUOTE_LINES_ALL;INVOICE_TO_CUST_PARTY_ID

3810: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3811: yy
3812: ));
3813: end if;
3814: --ASO_QUOTE_LINES_ALL;INVOICE_TO_CUST_PARTY_ID
3815: appid:=697;
3816: if(regid_proc = true) then
3817: 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
3818:

Line 3819: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3815: appid:=697;
3816: if(regid_proc = true) then
3817: 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
3818:
3819: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3820: );
3821: else
3822: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3823: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3823: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3819: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3820: );
3821: else
3822: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3823: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3824: );
3825: end if;
3826: --ASO_SHIPMENTS;SHIP_TO_CUST_PARTY_ID
3827: appid:=697;

Line 3884: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_PARTY_ID

3880: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3881: yy
3882: ));
3883: end if;
3884: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_PARTY_ID
3885: appid:=697;
3886: if(regid_proc = true) then
3887: 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
3888:

Line 3889: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3885: appid:=697;
3886: if(regid_proc = true) then
3887: 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
3888:
3889: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3890: );
3891: else
3892: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3893: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3893: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3889: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3890: );
3891: else
3892: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3893: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3894: );
3895: end if;
3896: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_CUST_PARTY_ID
3897: appid:=697;

Line 3896: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_CUST_PARTY_ID

3892: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3893: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3894: );
3895: end if;
3896: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_CUST_PARTY_ID
3897: appid:=697;
3898: if(regid_proc = true) then
3899: 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
3900:

Line 3901: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3897: appid:=697;
3898: if(regid_proc = true) then
3899: 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
3900:
3901: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3902: );
3903: else
3904: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3905: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3905: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3901: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3902: );
3903: else
3904: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3905: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3906: );
3907: end if;
3908: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_PARTY_SITE_ID
3909: appid:=697;

Line 3908: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_PARTY_SITE_ID

3904: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3905: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3906: );
3907: end if;
3908: --ASO_QUOTE_LINES_ALL;END_CUSTOMER_PARTY_SITE_ID
3909: appid:=697;
3910: if(regid_proc = true) then
3911: 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
3912:

Line 3917: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3913: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3914: xx
3915: where (nvl(STATUS, 'A') in ('A','I'))
3916: and xx.PARTY_SITE_ID
3917: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3918: yy
3919: ));
3920: else
3921: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3926: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3922: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3923: xx
3924: where (nvl(STATUS, 'A') in ('A','I'))
3925: and xx.PARTY_SITE_ID
3926: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3927: yy
3928: ));
3929: end if;
3930: --OKE_POOL_PARTIES;PARTY_ID