APPS.GMD_RECIPE_HEADER_PVT dependencies on FM_MATL_DTL

Line 397: FROM gmd_recipe_step_materials a, fm_matl_dtl b

393:
394: -- Cursor and declaration as per as Bug 5138316 KSHUKLA
395: CURSOR Cur_get_formula(vRecipe_id NUMBER, vFormula_id NUMBER) IS
396: SELECT 1
397: FROM gmd_recipe_step_materials a, fm_matl_dtl b
398: WHERE a.recipe_id = vRecipe_id
399: AND a.formulaline_id = b.formulaline_id
400: AND b.formula_id <>vFormula_id ;
401:

Line 407: from fm_matl_dtl

403: SELECT 1
404: FROM gmd_recipe_validity_rules a
405: WHERE a.recipe_id = vRecipe_id
406: AND item_id not in (select item_id
407: from fm_matl_dtl
408: where line_type = 1
409: and formula_id = vFormula_id);
410:
411: CURSOR Cur_check_routing(vRecipe_id NUMBER, vRouting_id NUMBER) IS