APPS.INV_EBI_ITEM_HELPER dependencies on MTL_CATEGORIES_KFV

Line 149: SELECT category_id INTO l_id FROM mtl_categories_kfv

145: SELECT category_set_id INTO l_id FROM mtl_category_sets_vl
146: WHERE category_set_name = l_pk1;
147: WHEN G_CATEGORY THEN
148: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
149: SELECT category_id INTO l_id FROM mtl_categories_kfv
150: WHERE concatenated_segments = l_pk1;
151: END CASE;
152: END IF;
153: RETURN l_id;

Line 230: FROM mtl_categories_kfv

226: WHERE CATEGORY_SET_ID = l_pk1;
227: WHEN G_CATEGORY THEN
228: l_pk1 := ID_COL_VALUE('cat_id',p_pk_col_name_val_pairs);
229: SELECT concatenated_segments INTO l_code
230: FROM mtl_categories_kfv
231: WHERE CATEGORY_ID =l_pk1;
232: WHEN G_INVENTORY_ITEM THEN
233: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
234: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);