APPS.MSC_BI2EBS_PKG dependencies on MSC_SYSTEM_ITEMS

Line 107: select unique inventory_item_id from msc_system_items

103: where CATEGORY_NAME = p_category_name
104: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105:
106: cursor c_item_id(p_plan_id number,p_item_name varchar2) is
107: select unique inventory_item_id from msc_system_items
108: where item_name=p_item_name
109: and plan_id = p_plan_id;
110:
111: cursor c_res_id (p_plan_id number, p_res_name varchar2) is