[Home] [Help]
61: delete from msc_supplies_f
62: where plan_id = p_plan_id
63: and plan_run_id = p_plan_run_id
64: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
65: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);
66:
67: l_rowcount1 := l_rowcount1 + sql%rowcount;
68: msc_phub_util.log('msc_supplies_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
69: commit;
71: delete from msc_item_wips_f
72: where plan_id = p_plan_id
73: and plan_run_id = p_plan_run_id
74: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
75: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);
76:
77: l_rowcount2 := l_rowcount2 + sql%rowcount;
78: msc_phub_util.log('msc_item_wips_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
79: commit;
404: or ( p_plan_id = -1
405: and ms.sr_instance_id = l_sr_instance_id
406: and (l_refresh_mode = 1
407: or (l_refresh_mode = 2 and (p_plan_id, ms.sr_instance_id, ms.organization_id, ms.inventory_item_id) in
408: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )
409: and trunc(nvl(ms.firm_date,ms.new_schedule_date)) between l_plan_start_date and l_plan_cutoff_date
410: )
411: )
412: and ms.transaction_id=pg.transaction_id(+)
547: or ( p_plan_id = -1
548: and ms.sr_instance_id = l_sr_instance_id
549: and (l_refresh_mode = 1
550: or (l_refresh_mode = 2 and (p_plan_id, ms.sr_instance_id, ms.organization_id, ms.inventory_item_id) in
551: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid) ) )
552: and trunc(nvl(nvl(ms.new_wip_start_date,ms.first_unit_start_date),l_plan_start_date)) between l_plan_start_date and l_plan_cutoff_date
553: )
554: )
555: group by