217: p_plan_type number, p_aggr_type number, p_category_set_id number) is
218: begin
219: if p_category_set_id is not null then
220: if p_plan_type = 10 then
221: insert into msc_hub_query(
222: query_id,
223: number1, -- plan_id
224: number2, -- plan_run_id
225: number3, -- owning_inst_id
243: and f.inventory_item_id = ic.inventory_item_id(+)
244: and ic.category_set_id(+) = p_category_set_id;
245:
246: else
247: insert into msc_hub_query(
248: query_id,
249: number1, -- plan_id
250: number2, -- plan_run_id
251: number3, -- sr_instance_id