APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_LINES_INT_ALL

Line 3122: --OZF_RESALE_LINES_INT_ALL;SHIP_FROM_CONTACT_PARTY_ID

3118: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3119: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx
3120: );
3121: end if;
3122: --OZF_RESALE_LINES_INT_ALL;SHIP_FROM_CONTACT_PARTY_ID
3123: appid:=682;
3124: if(regid_proc = true) then
3125: 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
3126:

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

3123: appid:=682;
3124: if(regid_proc = true) then
3125: 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
3126:
3127: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3128: );
3129: else
3130: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3131: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3127: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3128: );
3129: else
3130: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3131: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3132: );
3133: end if;
3134: --OZF_RESALE_LINES_INT_ALL;SOLD_FROM_CONTACT_PARTY_ID
3135: appid:=682;

Line 3134: --OZF_RESALE_LINES_INT_ALL;SOLD_FROM_CONTACT_PARTY_ID

3130: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3131: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3132: );
3133: end if;
3134: --OZF_RESALE_LINES_INT_ALL;SOLD_FROM_CONTACT_PARTY_ID
3135: appid:=682;
3136: if(regid_proc = true) then
3137: 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
3138:

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

3135: appid:=682;
3136: if(regid_proc = true) then
3137: 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
3138:
3139: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3140: );
3141: else
3142: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3143: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3139: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3140: );
3141: else
3142: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3143: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3144: );
3145: end if;
3146: --OZF_RESALE_LINES_INT_ALL;BILL_TO_PARTY_ID
3147: appid:=682;

Line 3146: --OZF_RESALE_LINES_INT_ALL;BILL_TO_PARTY_ID

3142: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3143: temp.party_id in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3144: );
3145: end if;
3146: --OZF_RESALE_LINES_INT_ALL;BILL_TO_PARTY_ID
3147: appid:=682;
3148: if(regid_proc = true) then
3149: 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
3150:

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

3147: appid:=682;
3148: if(regid_proc = true) then
3149: 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
3150:
3151: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3152: );
3153: else
3154: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3155: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3151: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3152: );
3153: else
3154: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3155: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3156: );
3157: end if;
3158: --OZF_RESALE_LINES_INT_ALL;BILL_TO_CONTACT_PARTY_ID
3159: appid:=682;

Line 3158: --OZF_RESALE_LINES_INT_ALL;BILL_TO_CONTACT_PARTY_ID

3154: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3155: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3156: );
3157: end if;
3158: --OZF_RESALE_LINES_INT_ALL;BILL_TO_CONTACT_PARTY_ID
3159: appid:=682;
3160: if(regid_proc = true) then
3161: 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
3162:

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

3159: appid:=682;
3160: if(regid_proc = true) then
3161: 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
3162:
3163: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3164: );
3165: else
3166: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3167: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3163: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3164: );
3165: else
3166: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3167: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3168: );
3169: end if;
3170: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_PARTY_ID
3171: appid:=682;

Line 3170: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_PARTY_ID

3166: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3167: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3168: );
3169: end if;
3170: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_PARTY_ID
3171: appid:=682;
3172: if(regid_proc = true) then
3173: 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
3174:

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

3171: appid:=682;
3172: if(regid_proc = true) then
3173: 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
3174:
3175: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3176: );
3177: else
3178: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3179: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3175: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3176: );
3177: else
3178: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3179: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3180: );
3181: end if;
3182: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_CONTACT_PARTY_ID
3183: appid:=682;

Line 3182: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_CONTACT_PARTY_ID

3178: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3179: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3180: );
3181: end if;
3182: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_CONTACT_PARTY_ID
3183: appid:=682;
3184: if(regid_proc = true) then
3185: 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
3186:

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

3183: appid:=682;
3184: if(regid_proc = true) then
3185: 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
3186:
3187: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3188: );
3189: else
3190: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3191: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3187: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3188: );
3189: else
3190: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3191: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3192: );
3193: end if;
3194: --OZF_RESALE_LINES_INT_ALL;END_CUST_PARTY_ID
3195: appid:=682;

Line 3194: --OZF_RESALE_LINES_INT_ALL;END_CUST_PARTY_ID

3190: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3191: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3192: );
3193: end if;
3194: --OZF_RESALE_LINES_INT_ALL;END_CUST_PARTY_ID
3195: appid:=682;
3196: if(regid_proc = true) then
3197: 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
3198:

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

3195: appid:=682;
3196: if(regid_proc = true) then
3197: 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
3198:
3199: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3200: );
3201: else
3202: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3203: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx

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

3199: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3200: );
3201: else
3202: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3203: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3204: );
3205: end if;
3206: --OZF_RESALE_LINES_INT_ALL;END_CUST_CONTACT_PARTY_ID
3207: appid:=682;

Line 3206: --OZF_RESALE_LINES_INT_ALL;END_CUST_CONTACT_PARTY_ID

3202: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3203: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3204: );
3205: end if;
3206: --OZF_RESALE_LINES_INT_ALL;END_CUST_CONTACT_PARTY_ID
3207: appid:=682;
3208: if(regid_proc = true) then
3209: 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
3210:

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

3207: appid:=682;
3208: if(regid_proc = true) then
3209: 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
3210:
3211: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3212: );
3213: else
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

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

3211: temp.party_id in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx
3212: );
3213: else
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;