APPS.GMD_GME_INT dependencies on FM_MATL_DTL

Line 62: --,FM_MATL_DTL MATL

58: ,FM.ROUTINGSTEP_ID
59: FROM GMD_RECIPES_B C,
60: FM_FORM_MST H,
61: fm_rout_dtl FM
62: --,FM_MATL_DTL MATL
63: WHERE
64: C.ROUTING_ID= x_routing_id AND
65: C.RECIPE_ID = x_recipe_id AND
66: FM.ROUTINGSTEP_ID= x_routing_step_id and

Line 76: from fm_matl_dtl md, gmd_Recipes_b r

72:
73: Cursor C2 (p_recipe_id number) is
74: select distinct md.inventory_item_id,md.revision ----RLNAGARA B5389806 Added revision
75: ,md.formulaline_id ----SMALLURU B6379386 Added formulaline_id
76: from fm_matl_dtl md, gmd_Recipes_b r
77: where r.recipe_id = p_recipe_id
78: and r.formula_id = md.formula_id
79: and md.line_type <> 2; -- no byproducts
80: