APPS.INV_EBI_ITEM_HELPER dependencies on MTL_CATEGORIES_KFV

Line 169: SELECT category_id INTO l_id FROM mtl_categories_kfv mck,mtl_category_sets_vl mcs

165: WHERE category_set_name = l_pk1;
166: WHEN G_CATEGORY THEN
167: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
168: l_pk2 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);
169: SELECT category_id INTO l_id FROM mtl_categories_kfv mck,mtl_category_sets_vl mcs
170: where mcs.category_set_name = l_pk2
171: and mcs.structure_id = mck.structure_id
172: and mck.concatenated_segments = l_pk1;
173: END CASE;

Line 252: FROM mtl_categories_kfv

248: WHERE CATEGORY_SET_ID = l_pk1;
249: WHEN G_CATEGORY THEN
250: l_pk1 := ID_COL_VALUE('cat_id',p_pk_col_name_val_pairs);
251: SELECT concatenated_segments INTO l_code
252: FROM mtl_categories_kfv
253: WHERE CATEGORY_ID =l_pk1;
254: WHEN G_INVENTORY_ITEM THEN
255: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
256: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);