APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_HEADERS_ALL

Line 3214: --OZF_RESALE_HEADERS_ALL;BILL_TO_PARTY_ID

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

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

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

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

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

Line 3226: --OZF_RESALE_HEADERS_ALL;BILL_TO_CONTACT_PARTY_ID

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

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

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

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

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

Line 3238: --OZF_RESALE_HEADERS_ALL;SHIP_TO_PARTY_ID

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

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

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

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

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

Line 3250: --OZF_RESALE_HEADERS_ALL;SHIP_TO_CONTACT_PARTY_ID

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

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

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

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

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