APPS.HZ_PURGE_GEN dependencies on OZF_RESALE_LINES_INT_ALL

Line 3118: --OZF_RESALE_LINES_INT_ALL;SHIP_FROM_CONTACT_PARTY_ID

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

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

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

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

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

Line 3130: --OZF_RESALE_LINES_INT_ALL;SOLD_FROM_CONTACT_PARTY_ID

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

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

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

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

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

Line 3142: --OZF_RESALE_LINES_INT_ALL;BILL_TO_PARTY_ID

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

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

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

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

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

Line 3154: --OZF_RESALE_LINES_INT_ALL;BILL_TO_CONTACT_PARTY_ID

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

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

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

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

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

Line 3166: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_PARTY_ID

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

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

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

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

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

Line 3178: --OZF_RESALE_LINES_INT_ALL;SHIP_TO_CONTACT_PARTY_ID

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

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

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

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

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

Line 3190: --OZF_RESALE_LINES_INT_ALL;END_CUST_PARTY_ID

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

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

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

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

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

Line 3202: --OZF_RESALE_LINES_INT_ALL;END_CUST_CONTACT_PARTY_ID

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

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

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

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

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