APPS.HZ_PURGE_GEN dependencies on ASO_SHIPMENTS

Line 1060: (select 'Y' from ASO_SHIPMENTS

1056: or exists (select 'Y' from HZ_PARTY_SITES
1057: xx where xx.PARTY_ID = temp.party_id
1058: and (nvl(STATUS, 'A') in ('A','I'))
1059: and exists
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

Line 1077: (select 'Y' from ASO_SHIPMENTS

1073: or exists (select 'Y' from HZ_PARTY_SITES
1074: xx where xx.PARTY_ID = temp.party_id
1075: and (nvl(STATUS, 'A') in ('A','I'))
1076: and exists
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

Line 3724: --ASO_SHIPMENTS;SHIP_TO_PARTY_ID

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;
3726: if(regid_proc = true) then
3727: 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
3728:

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

3725: appid:=697;
3726: if(regid_proc = true) then
3727: 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
3728:
3729: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3730: );
3731: else
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

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

3729: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3730: );
3731: else
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;

Line 3826: --ASO_SHIPMENTS;SHIP_TO_CUST_PARTY_ID

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;
3828: if(regid_proc = true) then
3829: 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
3830:

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

3827: appid:=697;
3828: if(regid_proc = true) then
3829: 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
3830:
3831: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3832: );
3833: else
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

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

3831: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx
3832: );
3833: else
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;