DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on MTL_CATEGORY_SETS_VL

Line 145: SELECT category_set_id INTO l_id FROM mtl_category_sets_vl

141: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers
142: WHERE manufacturer_name = l_pk1;
143: WHEN G_CATEGORY_SET THEN
144: l_pk1 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);
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

Line 225: FROM mtl_category_sets_vl

221: WHERE manufacturer_id = l_pk1;
222: WHEN G_CATEGORY_SET THEN
223: l_pk1 := ID_COL_VALUE('cat_set_id',p_pk_col_name_val_pairs);
224: SELECT category_set_name INTO l_code
225: FROM mtl_category_sets_vl
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