DBA Data[Home] [Help]

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 2150: FROM mtl_item_categories

2146: SELECT 'x'
2147: FROM dual
2148: WHERE exists
2149: ( SELECT category_id
2150: FROM mtl_item_categories
2151: WHERE category_id = p_category_id
2152: );
2153:
2154: CURSOR default_category_exists(p_category_id NUMBER) IS

Line 2530: DELETE FROM mtl_item_categories

2526: /* IF (l_debug = 1) THEN
2527: mdebug('Delete_Category_Assignment: Tracing...1');
2528: END IF;
2529:
2530: DELETE FROM mtl_item_categories
2531: WHERE category_set_id = p_category_set_id
2532: AND organization_id = p_organization_id
2533: AND inventory_item_id = p_inventory_item_id
2534: AND category_id = p_category_id;

Line 3080: FROM mtl_item_categories item_cat

3076: --Added for bug 5219692
3077: CURSOR c_get_items_in_cat (cp_category_id IN NUMBER
3078: ,cp_category_set_id IN NUMBER) IS
3079: SELECT category_id
3080: FROM mtl_item_categories item_cat
3081: WHERE item_cat.category_id = cp_category_id
3082: AND item_cat.category_set_id = cp_category_set_id
3083: AND rownum = 1;
3084:

Line 3091: FROM mtl_item_categories item_cat

3087: SELECT valid_cats.category_id
3088: FROM mtl_category_set_valid_cats valid_cats
3089: WHERE EXISTS
3090: (SELECT 'X'
3091: FROM mtl_item_categories item_cat
3092: WHERE item_cat.category_id = valid_cats.category_id
3093: AND item_cat.category_set_id = cp_category_set_id
3094: )
3095: CONNECT BY PRIOR