APPS.MSC_BI2EBS_PKG dependencies on MSC_SYSTEM_ITEMS

Line 117: select unique inventory_item_id from msc_system_items

113: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1')
114: and sr_instance_id = nvl(p_sr_instance_id, sr_instance_id);
115:
116: cursor c_item_id(p_plan_id number,p_item_name varchar2) is
117: select unique inventory_item_id from msc_system_items
118: where item_name=p_item_name
119: and plan_id = p_plan_id;
120:
121: cursor c_res_id (p_plan_id number, p_res_name varchar2) is