APPS.INV_EBI_ITEM_HELPER dependencies on MTL_MANUFACTURERS

Line 160: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers

156: SELECT category_id INTO l_id FROM fa_categories_b_kfv
157: WHERE concatenated_segments = l_pk1;
158: WHEN G_MANUFACTURER THEN
159: l_pk1 := ID_COL_VALUE('manufacturer_name',p_pk_col_name_val_pairs);
160: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers
161: WHERE manufacturer_name = l_pk1;
162: WHEN G_CATEGORY_SET THEN
163: l_pk1 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);
164: SELECT category_set_id INTO l_id FROM mtl_category_sets_vl

Line 242: FROM mtl_manufacturers

238: WHERE category_id = l_pk1 ;
239: WHEN G_MANUFACTURER THEN
240: l_pk1 := ID_COL_VALUE('manufacturer_id',p_pk_col_name_val_pairs);
241: SELECT manufacturer_name INTO l_code
242: FROM mtl_manufacturers
243: WHERE manufacturer_id = l_pk1;
244: WHEN G_CATEGORY_SET THEN
245: l_pk1 := ID_COL_VALUE('cat_set_id',p_pk_col_name_val_pairs);
246: SELECT category_set_name INTO l_code

Line 4092: FROM mtl_manufacturers

4088: LOOP
4089: l_mfg_part_num_obj := p_item.part_num_obj_tbl_type(i);
4090: 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
4091: SELECT COUNT(1) INTO l_manufacturer_count
4092: FROM mtl_manufacturers
4093: WHERE manufacturer_id = l_mfg_part_num_obj.manufacturer_id;
4094: END IF;
4095: IF(l_manufacturer_count > 0 ) THEN
4096: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_ITEM_HELPER.process_part_num_association');