[Home] [Help]
133:
134: begin
135: select h.plan_id, b.bkt_start_date
136: into l_plan_id, l_past_date
137: from msc_hp_row_dtls h, msc_hp_col_dtls b
138: where h.query_id = p_query_id
139: and h.data_flag = decode(p_summary, 1, h.data_flag, 3)
140: and h.plan_id = b.plan_id
141: and b.bucket_type = 0
143: msc_phub_util.log('l_plan_id='||l_plan_id||', l_past_date='||l_past_date);
144:
145: select min(b.bkt_start_date), max(b.bkt_end_date)
146: into l_pre_start_date, l_plan_cutoff_date
147: from msc_hp_row_dtls h, msc_hp_col_dtls b
148: where h.query_id = p_query_id
149: and h.plan_id = b.plan_id;
150: msc_phub_util.log('l_pre_start_date='||l_pre_start_date||
151: ', l_plan_cutoff_date='||l_plan_cutoff_date);
232: to_number(null) other_demand,
233: to_number(null) safety_stock
234: from
235: msc_supplies ms,
236: msc_hp_col_dtls b,
237: msc_hp_row_dtls h
238: where h.query_id = p_query_id
239: and ms.plan_id = h.plan_id
240: and ms.sr_instance_id = h.sr_instance_id
297: to_number(null) other_demand,
298: to_number(null) safety_stock
299: from
300: msc_supplies ms,
301: msc_hp_col_dtls b,
302: msc_hp_row_dtls h
303: where h.query_id = p_query_id
304: and ms.plan_id = h.plan_id
305: and ms.sr_instance_id = h.sr_instance_id
364:
365: to_number(null) safety_stock
366: from
367: msc_demands md,
368: msc_hp_col_dtls b,
369: msc_hp_row_dtls h
370: where h.query_id = p_query_id
371: and md.plan_id = h.plan_id
372: and md.sr_instance_id = h.sr_instance_id
425: ss.plan_id,
426: ss.period_start_date
427: )
428: ) f,
429: msc_hp_col_dtls b
430: where f.plan_id = b.plan_id
431: and b.bkt_start_date between f.effective_date and f.expiry_date
432: group by
433: f.row_index,
535: u.new_value
536: from
537: msc_hp_updates u,
538: msc_hp_row_dtls h,
539: msc_hp_col_dtls b
540: where h.query_id = p_query_id
541: and h.query_id = u.query_id
542: and h.row_index = u.row_index
543: and h.plan_id = b.plan_id