APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_LINES_ALL

Line 3266: --OZF_RESALE_LINES_ALL;SHIP_FROM_CONTACT_PARTY_ID

3262: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3263: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3264: );
3265: end if;
3266: --OZF_RESALE_LINES_ALL;SHIP_FROM_CONTACT_PARTY_ID
3267: appid:=682;
3268: if(regid_proc = true) then
3269: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3270:

Line 3271: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3267: appid:=682;
3268: if(regid_proc = true) then
3269: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3270:
3271: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3272: );
3273: else
3274: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3275: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3275: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3271: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3272: );
3273: else
3274: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3275: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3276: );
3277: end if;
3278: --OZF_RESALE_LINES_ALL;SOLD_FROM_CONTACT_PARTY_ID
3279: appid:=682;

Line 3278: --OZF_RESALE_LINES_ALL;SOLD_FROM_CONTACT_PARTY_ID

3274: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3275: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3276: );
3277: end if;
3278: --OZF_RESALE_LINES_ALL;SOLD_FROM_CONTACT_PARTY_ID
3279: appid:=682;
3280: if(regid_proc = true) then
3281: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3282:

Line 3283: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3279: appid:=682;
3280: if(regid_proc = true) then
3281: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3282:
3283: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3284: );
3285: else
3286: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3287: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3287: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3283: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3284: );
3285: else
3286: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3287: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3288: );
3289: end if;
3290: --OZF_RESALE_LINES_ALL;BILL_TO_PARTY_ID
3291: appid:=682;

Line 3290: --OZF_RESALE_LINES_ALL;BILL_TO_PARTY_ID

3286: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3287: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3288: );
3289: end if;
3290: --OZF_RESALE_LINES_ALL;BILL_TO_PARTY_ID
3291: appid:=682;
3292: if(regid_proc = true) then
3293: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3294:

Line 3295: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

3291: appid:=682;
3292: if(regid_proc = true) then
3293: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3294:
3295: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3296: );
3297: else
3298: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3299: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3299: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

3295: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3296: );
3297: else
3298: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3299: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3300: );
3301: end if;
3302: --OZF_RESALE_LINES_ALL;BILL_TO_CONTACT_PARTY_ID
3303: appid:=682;

Line 3302: --OZF_RESALE_LINES_ALL;BILL_TO_CONTACT_PARTY_ID

3298: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3299: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3300: );
3301: end if;
3302: --OZF_RESALE_LINES_ALL;BILL_TO_CONTACT_PARTY_ID
3303: appid:=682;
3304: if(regid_proc = true) then
3305: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3306:

Line 3307: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3303: appid:=682;
3304: if(regid_proc = true) then
3305: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3306:
3307: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3308: );
3309: else
3310: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3311: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3311: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3307: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3308: );
3309: else
3310: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3311: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3312: );
3313: end if;
3314: --OZF_RESALE_LINES_ALL;SHIP_TO_PARTY_ID
3315: appid:=682;

Line 3314: --OZF_RESALE_LINES_ALL;SHIP_TO_PARTY_ID

3310: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3311: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3312: );
3313: end if;
3314: --OZF_RESALE_LINES_ALL;SHIP_TO_PARTY_ID
3315: appid:=682;
3316: if(regid_proc = true) then
3317: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3318:

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

3315: appid:=682;
3316: if(regid_proc = true) then
3317: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3318:
3319: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3320: );
3321: else
3322: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3323: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

3319: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3320: );
3321: else
3322: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3323: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3324: );
3325: end if;
3326: --OZF_RESALE_LINES_ALL;SHIP_TO_CONTACT_PARTY_ID
3327: appid:=682;

Line 3326: --OZF_RESALE_LINES_ALL;SHIP_TO_CONTACT_PARTY_ID

3322: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3323: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3324: );
3325: end if;
3326: --OZF_RESALE_LINES_ALL;SHIP_TO_CONTACT_PARTY_ID
3327: appid:=682;
3328: if(regid_proc = true) then
3329: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3330:

Line 3331: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3327: appid:=682;
3328: if(regid_proc = true) then
3329: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3330:
3331: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3332: );
3333: else
3334: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3335: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3335: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3331: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3332: );
3333: else
3334: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3335: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3336: );
3337: end if;
3338: --OZF_RESALE_LINES_ALL;END_CUST_PARTY_ID
3339: appid:=682;

Line 3338: --OZF_RESALE_LINES_ALL;END_CUST_PARTY_ID

3334: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3335: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3336: );
3337: end if;
3338: --OZF_RESALE_LINES_ALL;END_CUST_PARTY_ID
3339: appid:=682;
3340: if(regid_proc = true) then
3341: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3342:

Line 3343: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx

3339: appid:=682;
3340: if(regid_proc = true) then
3341: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3342:
3343: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3344: );
3345: else
3346: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3347: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3347: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx

3343: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3344: );
3345: else
3346: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3347: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3348: );
3349: end if;
3350: --OZF_RESALE_LINES_ALL;END_CUST_CONTACT_PARTY_ID
3351: appid:=682;

Line 3350: --OZF_RESALE_LINES_ALL;END_CUST_CONTACT_PARTY_ID

3346: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3347: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3348: );
3349: end if;
3350: --OZF_RESALE_LINES_ALL;END_CUST_CONTACT_PARTY_ID
3351: appid:=682;
3352: if(regid_proc = true) then
3353: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3354:

Line 3355: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3351: appid:=682;
3352: if(regid_proc = true) then
3353: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3354:
3355: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3356: );
3357: else
3358: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3359: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

Line 3359: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

3355: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3356: );
3357: else
3358: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3359: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3360: );
3361: end if;
3362: --OZF_REQUEST_HEADERS_ALL_B;END_CUST_PARTY_ID
3363: appid:=682;