APPS.EDW_ITEMS_PKG dependencies on MTL_CATEGORIES_KFV

Line 25: l_item_category mtl_categories_kfv.category_id%TYPE;

21: p_instance_code in varchar2 DEFAULT null)
22: return VARCHAR2 IS
23:
24: l_instance_code edw_local_instance.instance_code%TYPE;
25: l_item_category mtl_categories_kfv.category_id%TYPE;
26:
27: cursor c1 is
28: select instance_code
29: from edw_local_instance;

Line 33: from mtl_categories_kfv

29: from edw_local_instance;
30:
31: cursor c2 is
32: select category_id
33: from mtl_categories_kfv
34: where concatenated_segments = p_item_category;
35:
36: BEGIN
37: