APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_LINES_ALL

Line 3262: --OZF_RESALE_LINES_ALL;SHIP_FROM_CONTACT_PARTY_ID

3258: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3259: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3260: );
3261: end if;
3262: --OZF_RESALE_LINES_ALL;SHIP_FROM_CONTACT_PARTY_ID
3263: appid:=682;
3264: if(regid_proc = true) then
3265: 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
3266:

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

3263: appid:=682;
3264: if(regid_proc = true) then
3265: 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
3266:
3267: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3268: );
3269: else
3270: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3271: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3274: --OZF_RESALE_LINES_ALL;SOLD_FROM_CONTACT_PARTY_ID

3270: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3271: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3272: );
3273: end if;
3274: --OZF_RESALE_LINES_ALL;SOLD_FROM_CONTACT_PARTY_ID
3275: appid:=682;
3276: if(regid_proc = true) then
3277: 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
3278:

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

3275: appid:=682;
3276: if(regid_proc = true) then
3277: 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
3278:
3279: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3280: );
3281: else
3282: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3283: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3286: --OZF_RESALE_LINES_ALL;BILL_TO_PARTY_ID

3282: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3283: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3284: );
3285: end if;
3286: --OZF_RESALE_LINES_ALL;BILL_TO_PARTY_ID
3287: appid:=682;
3288: if(regid_proc = true) then
3289: 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
3290:

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

3287: appid:=682;
3288: if(regid_proc = true) then
3289: 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
3290:
3291: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3292: );
3293: else
3294: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3295: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3298: --OZF_RESALE_LINES_ALL;BILL_TO_CONTACT_PARTY_ID

3294: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3295: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3296: );
3297: end if;
3298: --OZF_RESALE_LINES_ALL;BILL_TO_CONTACT_PARTY_ID
3299: appid:=682;
3300: if(regid_proc = true) then
3301: 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
3302:

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

3299: appid:=682;
3300: if(regid_proc = true) then
3301: 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
3302:
3303: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3304: );
3305: else
3306: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3307: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3310: --OZF_RESALE_LINES_ALL;SHIP_TO_PARTY_ID

3306: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3307: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3308: );
3309: end if;
3310: --OZF_RESALE_LINES_ALL;SHIP_TO_PARTY_ID
3311: appid:=682;
3312: if(regid_proc = true) then
3313: 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
3314:

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

3311: appid:=682;
3312: if(regid_proc = true) then
3313: 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
3314:
3315: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3316: );
3317: else
3318: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3319: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3322: --OZF_RESALE_LINES_ALL;SHIP_TO_CONTACT_PARTY_ID

3318: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3319: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx
3320: );
3321: end if;
3322: --OZF_RESALE_LINES_ALL;SHIP_TO_CONTACT_PARTY_ID
3323: appid:=682;
3324: if(regid_proc = true) then
3325: 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
3326:

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

3323: appid:=682;
3324: if(regid_proc = true) then
3325: 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
3326:
3327: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3328: );
3329: else
3330: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3331: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3334: --OZF_RESALE_LINES_ALL;END_CUST_PARTY_ID

3330: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3331: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3332: );
3333: end if;
3334: --OZF_RESALE_LINES_ALL;END_CUST_PARTY_ID
3335: appid:=682;
3336: if(regid_proc = true) then
3337: 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
3338:

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

3335: appid:=682;
3336: if(regid_proc = true) then
3337: 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
3338:
3339: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3340: );
3341: else
3342: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3343: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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

Line 3346: --OZF_RESALE_LINES_ALL;END_CUST_CONTACT_PARTY_ID

3342: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3343: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx
3344: );
3345: end if;
3346: --OZF_RESALE_LINES_ALL;END_CUST_CONTACT_PARTY_ID
3347: appid:=682;
3348: if(regid_proc = true) then
3349: 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
3350:

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

3347: appid:=682;
3348: if(regid_proc = true) then
3349: 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
3350:
3351: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx
3352: );
3353: else
3354: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3355: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx

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

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