[Home] [Help]
285: l_qid1 number;
286:
287: cursor c_highest_cur is
288: select distinct mis.highest_item_id
289: from msc_system_items msi,
290: msc_plans mp,
291: msc_item_substitutes mis,
292: msc_system_items msi2
293: where mp.plan_id = p_plan
288: select distinct mis.highest_item_id
289: from msc_system_items msi,
290: msc_plans mp,
291: msc_item_substitutes mis,
292: msc_system_items msi2
293: where mp.plan_id = p_plan
294: and msi.plan_id = mp.plan_id
295: and msi.sr_instance_id = mp.sr_instance_id
296: and msi.inventory_item_id = p_item
310: l_level number :=0;
311:
312: cursor c_grouped_items_cur is
313: select distinct msi2.inventory_item_id
314: from msc_system_items msi,
315: msc_system_items msi2
316: where msi.plan_id = p_plan
317: and msi.inventory_item_id = p_item
318: and msi.group_id is not null
311:
312: cursor c_grouped_items_cur is
313: select distinct msi2.inventory_item_id
314: from msc_system_items msi,
315: msc_system_items msi2
316: where msi.plan_id = p_plan
317: and msi.inventory_item_id = p_item
318: and msi.group_id is not null
319: and msi2.plan_id = msi.plan_id
1289: msiv.MAX_USAGE_FACTOR,
1290: msc_get_name.lookup_meaning('SYS_YES_NO', nvl(msiv.INTERMITTENT_DEMAND,2)) INTERMITTENT_DEMAND,
1291: msiv.sr_instance_id,
1292: msiv.inventory_item_id
1293: from msc_system_items_sc_v msiv,
1294: msc_form_query mfq, --items
1295: msc_form_query mfq1 --orgs
1296: where plan_id = p_plan_id
1297: and category_set_id = l_category_set_id
1450: msc_get_name.lookup_meaning('MSC_EXCEPTION_GROUP', 10) exception_type_text,
1451: count(*) excp_all_count,
1452: 0 excp_no_count
1453: from msc_supplies ms,
1454: msc_system_items msi,
1455: msc_form_query mfq, --items
1456: msc_form_query mfq1 --orgs
1457: where ms.plan_id = p_plan_id
1458: and ms.inventory_item_id = mfq.number2