[Home] [Help]
258:
259: begin
260: select h.plan_id, b.bkt_start_date
261: into l_plan_id, l_past_date
262: from msc_hp_row_dtls h, msc_hp_col_dtls b
263: where h.query_id = p_query_id
264: and h.data_flag = decode(p_summary, 1, h.data_flag, 3)
265: and h.plan_id = b.plan_id
266: and b.bucket_type = 0
324: to_number(null) total_resource_cost
325: from
326: msc_resource_requirements mrr,
327: msc_department_resources mdr,
328: msc_hp_col_dtls b,
329: msc_hp_row_dtls h
330: where h.query_id = p_query_id
331: and mrr.plan_id = h.plan_id
332: and mrr.sr_instance_id = h.sr_instance_id
363: to_number(null) total_resource_cost
364: from
365: msc_resource_requirements mrr,
366: msc_department_resources mdr,
367: msc_hp_col_dtls b,
368: msc_hp_row_dtls h
369: where h.query_id = p_query_id
370: and mrr.plan_id = h.plan_id
371: and mrr.sr_instance_id = h.sr_instance_id
404: to_number(null) work_order,
405: to_number(null) total_resource_cost
406: from
407: msc_net_resource_avail mra,
408: msc_hp_col_dtls b,
409: msc_hp_row_dtls h
410: where h.query_id = p_query_id
411: and mra.plan_id = h.plan_id
412: and mra.sr_instance_id = h.sr_instance_id
448: to_number(null) work_order,
449: to_number(null) total_resource_cost
450: from
451: msc_res_plan_updates a2,
452: msc_hp_col_dtls b,
453: msc_hp_row_dtls h
454: where h.query_id = p_query_id
455: and a2.query_id = h.query_id
456: and a2.plan_id = h.plan_id
498: msc_resource_requirements mrr,
499: msc_department_resources mdr,
500: msc_department_resources mdr2,
501: msc_supplies ms,
502: msc_hp_col_dtls b,
503: msc_hp_row_dtls h
504: where h.query_id = p_query_id
505: and mrr.plan_id = h.plan_id
506: and mrr.sr_instance_id = h.sr_instance_id
633: u.new_value
634: from
635: msc_hp_updates u,
636: msc_hp_row_dtls h,
637: msc_hp_col_dtls b
638: where h.query_id = p_query_id
639: and h.query_id = u.query_id
640: and h.row_index = u.row_index
641: and h.plan_id = b.plan_id