APPS.INV_EBI_ITEM_HELPER dependencies on MTL_MANUFACTURERS

Line 141: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers

137: SELECT category_id INTO l_id FROM fa_categories_b_kfv
138: WHERE concatenated_segments = l_pk1;
139: WHEN G_MANUFACTURER THEN
140: l_pk1 := ID_COL_VALUE('manufacturer_name',p_pk_col_name_val_pairs);
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

Line 220: FROM mtl_manufacturers

216: WHERE category_id = l_pk1 ;
217: WHEN G_MANUFACTURER THEN
218: l_pk1 := ID_COL_VALUE('manufacturer_id',p_pk_col_name_val_pairs);
219: SELECT manufacturer_name INTO l_code
220: FROM mtl_manufacturers
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

Line 2670: FROM mtl_manufacturers

2666: LOOP
2667: l_mfg_part_num_obj := p_item.part_num_obj_tbl_type(i);
2668: IF(l_mfg_part_num_obj.manufacturer_id IS NOT NULL AND l_mfg_part_num_obj.manufacturer_id <> fnd_api.g_miss_num) THEN
2669: SELECT COUNT(1) INTO l_manufacturer_count
2670: FROM mtl_manufacturers
2671: WHERE manufacturer_id = l_mfg_part_num_obj.manufacturer_id;
2672: END IF;
2673: IF(l_manufacturer_count > 0 ) THEN
2674: process_part_num_association(