APPS.HZ_PURGE_GEN dependencies on ASO_QUOTE_HEADERS_ALL

Line 1053: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id

1049: if(regid_proc = true) then
1050: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where
1051:
1052:
1053: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
1054: )
1055:
1056: or exists (select 'Y' from HZ_PARTY_SITES
1057: xx where xx.PARTY_ID = temp.party_id

Line 1064: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

1060: (select 'Y' from ASO_SHIPMENTS
1061: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
1062: ))
1063:
1064: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
1065: );
1066: else
1067: delete from hz_purge_gt temp where
1068:

Line 1070: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id

1066: else
1067: delete from hz_purge_gt temp where
1068:
1069:
1070: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
1071: )
1072:
1073: or exists (select 'Y' from HZ_PARTY_SITES
1074: xx where xx.PARTY_ID = temp.party_id

Line 1081: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

1077: (select 'Y' from ASO_SHIPMENTS
1078: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
1079: ))
1080:
1081: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
1082: );
1083: end if;
1084:
1085:

Line 3700: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_ID

3696: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS
3697: yy
3698: ));
3699: end if;
3700: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_ID
3701: appid:=697;
3702: if(regid_proc = true) then
3703: 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
3704:

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

3701: appid:=697;
3702: if(regid_proc = true) then
3703: 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
3704:
3705: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3706: );
3707: else
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

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

3705: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3706: );
3707: else
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;

Line 3736: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_SITE_ID

3732: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3733: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3734: );
3735: end if;
3736: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_SITE_ID
3737: appid:=697;
3738: if(regid_proc = true) then
3739: 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
3740:

Line 3745: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3741: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3742: xx
3743: where (nvl(STATUS, 'A') in ('A','I'))
3744: and xx.PARTY_SITE_ID
3745: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3746: yy
3747: ));
3748: else
3749: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3754: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3750: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3751: xx
3752: where (nvl(STATUS, 'A') in ('A','I'))
3753: and xx.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

Line 3780: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_CUST_PARTY_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
3781: appid:=697;
3782: if(regid_proc = true) then
3783: 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
3784:

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

3781: appid:=697;
3782: if(regid_proc = true) then
3783: 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
3784:
3785: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3786: );
3787: else
3788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3789: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

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

3785: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3786: );
3787: else
3788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3789: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3790: );
3791: end if;
3792: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID
3793: appid:=697;

Line 3792: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID

3788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3789: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3790: );
3791: end if;
3792: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID
3793: appid:=697;
3794: if(regid_proc = true) then
3795: 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
3796:

Line 3801: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3797: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3798: xx
3799: where (nvl(STATUS, 'A') in ('A','I'))
3800: and xx.PARTY_SITE_ID
3801: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3802: yy
3803: ));
3804: else
3805: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3810: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3806: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3807: xx
3808: where (nvl(STATUS, 'A') in ('A','I'))
3809: and xx.PARTY_SITE_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

Line 3838: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_PARTY_ID

3834: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3835: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3836: );
3837: end if;
3838: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_PARTY_ID
3839: appid:=697;
3840: if(regid_proc = true) then
3841: 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
3842:

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

3839: appid:=697;
3840: if(regid_proc = true) then
3841: 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
3842:
3843: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3844: );
3845: else
3846: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3847: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

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

3843: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3844: );
3845: else
3846: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3847: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3848: );
3849: end if;
3850: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_CUST_PARTY_ID
3851: appid:=697;

Line 3850: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_CUST_PARTY_ID

3846: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3847: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3848: );
3849: end if;
3850: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_CUST_PARTY_ID
3851: appid:=697;
3852: if(regid_proc = true) then
3853: 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
3854:

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

3851: appid:=697;
3852: if(regid_proc = true) then
3853: 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
3854:
3855: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3856: );
3857: else
3858: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3859: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

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

3855: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3856: );
3857: else
3858: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3859: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3860: );
3861: end if;
3862: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_PARTY_SITE_ID
3863: appid:=697;

Line 3862: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_PARTY_SITE_ID

3858: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3859: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3860: );
3861: end if;
3862: --ASO_QUOTE_HEADERS_ALL;END_CUSTOMER_PARTY_SITE_ID
3863: appid:=697;
3864: if(regid_proc = true) then
3865: 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
3866:

Line 3871: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3867: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3868: xx
3869: where (nvl(STATUS, 'A') in ('A','I'))
3870: and xx.PARTY_SITE_ID
3871: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3872: yy
3873: ));
3874: else
3875: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3880: in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3876: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3877: xx
3878: where (nvl(STATUS, 'A') in ('A','I'))
3879: and xx.PARTY_SITE_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