APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1464: FROM mtl_item_categories b

1460: (SELECT category_id
1461: FROM mtl_category_set_valid_cats_v a
1462: WHERE a.category_id IN
1463: (SELECT DISTINCT b.category_id
1464: FROM mtl_item_categories b
1465: WHERE a.category_id = b.category_id
1466: and b.inventory_item_id =
1467: x_labor_time_tbl(TASK)
1468: .inventory_item_id

Line 13161: ',MTL_ITEM_CATEGORIES MIC ';

13157: elsif cur_rec.parameter_id IN (5006) then
13158: --Item Category
13159: if v_cat_flag = 'N' then
13160: g_Unreleased_SQL := g_Unreleased_SQL ||
13161: ',MTL_ITEM_CATEGORIES MIC ';
13162: g_WHERE_SQL := g_WHERE_SQL ||
13163: ' MIC.INVENTORY_ITEM_ID=WDD.INVENTORY_ITEM_ID AND ';
13164: end if;
13165: v_cat_flag := 'Y';

Line 13276: from mtl_item_categories mic

13272:
13273: -- For Item Category
13274: IF (g_item_category_id <> 0) THEN
13275: g_cond_SQL := g_Cond_SQL || ' and wdd.inventory_item_id in (select distinct inventory_item_id
13276: from mtl_item_categories mic
13277: where mic.category_id =:X_category_id) ' || '';
13278: END IF;
13279:
13280: -- Ajith Changed this part