APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_BATCHES_ALL

Line 442: or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID = temp.party_id

438:
439: or exists (select 'Y' from OZF_CODE_CONVERSIONS_ALL xx where xx.PARTY_ID = temp.party_id
440: )
441:
442: or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID = temp.party_id
443: )
444:
445: or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID = temp.party_id
446: );

Line 475: or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID = temp.party_id

471:
472: or exists (select 'Y' from OZF_CODE_CONVERSIONS_ALL xx where xx.PARTY_ID = temp.party_id
473: )
474:
475: or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID = temp.party_id
476: )
477:
478: or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID = temp.party_id
479: );

Line 3422: --OZF_RESALE_BATCHES_ALL;PARTNER_CONTACT_PARTY_ID

3418: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3419: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx
3420: );
3421: end if;
3422: --OZF_RESALE_BATCHES_ALL;PARTNER_CONTACT_PARTY_ID
3423: appid:=682;
3424: if(regid_proc = true) then
3425: 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
3426:

Line 3427: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx

3423: appid:=682;
3424: if(regid_proc = true) then
3425: 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
3426:
3427: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx
3428: );
3429: else
3430: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3431: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx

Line 3431: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx

3427: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx
3428: );
3429: else
3430: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3431: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx
3432: );
3433: end if;
3434: --OZF_CLAIM_LINES_ALL;BUY_GROUP_PARTY_ID
3435: appid:=682;