APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_VL

Line 631: FROM mtl_categories_vl

627: --last_updated_by,
628: --creation_date,
629: --created_by,
630: --last_update_login
631: FROM mtl_categories_vl
632: WHERE category_id = p_category_id;
633:
634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
635: l_product_str_id NUMBER; -- Bug 5474569

Line 3066: l_description mtl_categories_vl.description%TYPE;

3062: -- to change i.e. for eg. X.6 to X.7.
3063: l_api_version CONSTANT NUMBER := 1.0;
3064: l_count NUMBER;
3065: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3066: l_description mtl_categories_vl.description%TYPE;
3067: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3068: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3070:

Line 3073: FROM mtl_categories_vl

3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3070:
3071: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS
3072: SELECT description
3073: FROM mtl_categories_vl
3074: WHERE category_id = cp_category_id;
3075:
3076: --Added for bug 5219692
3077: CURSOR c_get_items_in_cat (cp_category_id IN NUMBER