APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_HEADERS_ALL

Line 3218: --OZF_RESALE_HEADERS_ALL;BILL_TO_PARTY_ID

3214: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3215: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3216: );
3217: end if;
3218: --OZF_RESALE_HEADERS_ALL;BILL_TO_PARTY_ID
3219: appid:=682;
3220: if(regid_proc = true) then
3221: 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
3222:

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

3219: appid:=682;
3220: if(regid_proc = true) then
3221: 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
3222:
3223: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3224: );
3225: else
3226: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3227: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx

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

3223: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3224: );
3225: else
3226: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3227: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3228: );
3229: end if;
3230: --OZF_RESALE_HEADERS_ALL;BILL_TO_CONTACT_PARTY_ID
3231: appid:=682;

Line 3230: --OZF_RESALE_HEADERS_ALL;BILL_TO_CONTACT_PARTY_ID

3226: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3227: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3228: );
3229: end if;
3230: --OZF_RESALE_HEADERS_ALL;BILL_TO_CONTACT_PARTY_ID
3231: appid:=682;
3232: if(regid_proc = true) then
3233: 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
3234:

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

3231: appid:=682;
3232: if(regid_proc = true) then
3233: 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
3234:
3235: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3236: );
3237: else
3238: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3239: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx

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

3235: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3236: );
3237: else
3238: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3239: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3240: );
3241: end if;
3242: --OZF_RESALE_HEADERS_ALL;SHIP_TO_PARTY_ID
3243: appid:=682;

Line 3242: --OZF_RESALE_HEADERS_ALL;SHIP_TO_PARTY_ID

3238: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3239: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3240: );
3241: end if;
3242: --OZF_RESALE_HEADERS_ALL;SHIP_TO_PARTY_ID
3243: appid:=682;
3244: if(regid_proc = true) then
3245: 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
3246:

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

3243: appid:=682;
3244: if(regid_proc = true) then
3245: 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
3246:
3247: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3248: );
3249: else
3250: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3251: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx

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

3247: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3248: );
3249: else
3250: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3251: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3252: );
3253: end if;
3254: --OZF_RESALE_HEADERS_ALL;SHIP_TO_CONTACT_PARTY_ID
3255: appid:=682;

Line 3254: --OZF_RESALE_HEADERS_ALL;SHIP_TO_CONTACT_PARTY_ID

3250: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3251: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3252: );
3253: end if;
3254: --OZF_RESALE_HEADERS_ALL;SHIP_TO_CONTACT_PARTY_ID
3255: appid:=682;
3256: if(regid_proc = true) then
3257: 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
3258:

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

3255: appid:=682;
3256: if(regid_proc = true) then
3257: 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
3258:
3259: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3260: );
3261: else
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

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

3259: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx
3260: );
3261: else
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;