APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_ITEM_CATEGORIES

Line 248: FROM mtl_item_categories

244:
245: CURSOR c_check_item_assocs (cp_category_set_id IN NUMBER
246: ,cp_category_id IN NUMBER) IS
247: SELECT category_id
248: FROM mtl_item_categories
249: WHERE category_id = cp_category_id
250: AND category_set_id = cp_category_set_id
251: AND rownum = 1;
252:

Line 2169: FROM mtl_item_categories

2165: SELECT 'x'
2166: FROM dual
2167: WHERE exists
2168: ( SELECT category_id
2169: FROM mtl_item_categories
2170: WHERE category_id = p_category_id
2171: );
2172:
2173: CURSOR default_category_exists(p_category_id NUMBER) IS

Line 2578: DELETE FROM mtl_item_categories

2574: /* IF (l_debug = 1) THEN
2575: mdebug('Delete_Category_Assignment: Tracing...1');
2576: END IF;
2577:
2578: DELETE FROM mtl_item_categories
2579: WHERE category_set_id = p_category_set_id
2580: AND organization_id = p_organization_id
2581: AND inventory_item_id = p_inventory_item_id
2582: AND category_id = p_category_id;

Line 3159: FROM mtl_item_categories item_cat

3155: --Added for bug 5219692
3156: CURSOR c_get_items_in_cat (cp_category_id IN NUMBER
3157: ,cp_category_set_id IN NUMBER) IS
3158: SELECT category_id
3159: FROM mtl_item_categories item_cat
3160: WHERE item_cat.category_id = cp_category_id
3161: AND item_cat.category_set_id = cp_category_set_id
3162: AND rownum = 1;
3163:

Line 3170: FROM mtl_item_categories item_cat

3166: SELECT valid_cats.category_id
3167: FROM mtl_category_set_valid_cats valid_cats
3168: WHERE EXISTS
3169: (SELECT 'X'
3170: FROM mtl_item_categories item_cat
3171: WHERE item_cat.category_id = valid_cats.category_id
3172: AND item_cat.category_set_id = cp_category_set_id
3173: )
3174: CONNECT BY PRIOR