APPS.GME_CREATE_BATCH_PVT dependencies on GMD_RECIPES

Line 265: l_recipe gmd_recipes%ROWTYPE;

261: l_in_material_details gme_common_pvt.material_details_tab;
262: l_material_details_in gme_material_details%ROWTYPE;
263: l_item_masters gme_common_pvt.item_masters_tab;
264: l_text_table gme_common_pvt.text_tab;
265: l_recipe gmd_recipes%ROWTYPE;
266: l_from_uom mtl_units_of_measure.uom_code%TYPE;
267: l_to_uom mtl_units_of_measure.uom_code%TYPE;
268: l_prim_item_um mtl_units_of_measure.uom_code%TYPE;
269: l_prim_prod_um mtl_units_of_measure.uom_code%TYPE;

Line 358: FROM gmd_recipes

354:
355: CURSOR recipe_cursor (v_recipe_id NUMBER)
356: IS
357: SELECT *
358: FROM gmd_recipes
359: WHERE recipe_id = v_recipe_id;
360:
361: CURSOR formula_details_cursor (v_recipe_id NUMBER)
362: IS

Line 364: FROM fm_matl_dtl a, gmd_recipes_b b

360:
361: CURSOR formula_details_cursor (v_recipe_id NUMBER)
362: IS
363: SELECT a.*
364: FROM fm_matl_dtl a, gmd_recipes_b b
365: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
366: ORDER BY line_no;
367:
368: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)