APPS.GME_CREATE_BATCH_PVT dependencies on GMD_RECIPES

Line 194: l_recipe gmd_recipes%ROWTYPE;

190: l_in_material_details gme_common_pvt.material_details_tab;
191: l_material_details_in gme_material_details%ROWTYPE;
192: l_item_masters gme_common_pvt.item_masters_tab;
193: l_text_table gme_common_pvt.text_tab;
194: l_recipe gmd_recipes%ROWTYPE;
195: l_from_uom mtl_units_of_measure.uom_code%TYPE;
196: l_to_uom mtl_units_of_measure.uom_code%TYPE;
197: l_prim_item_um mtl_units_of_measure.uom_code%TYPE;
198: l_prim_prod_um mtl_units_of_measure.uom_code%TYPE;

Line 278: FROM gmd_recipes

274:
275: CURSOR recipe_cursor (v_recipe_id NUMBER)
276: IS
277: SELECT *
278: FROM gmd_recipes
279: WHERE recipe_id = v_recipe_id;
280:
281: CURSOR formula_details_cursor (v_recipe_id NUMBER)
282: IS

Line 284: FROM fm_matl_dtl a, gmd_recipes_b b

280:
281: CURSOR formula_details_cursor (v_recipe_id NUMBER)
282: IS
283: SELECT a.*
284: FROM fm_matl_dtl a, gmd_recipes_b b
285: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
286: ORDER BY line_no;
287:
288: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)