DBA Data[Home] [Help]

APPS.GMD_GME_INT dependencies on GMD_RECIPES_B

Line 59: FROM GMD_RECIPES_B C,

55: --MATL.ITEM_ID,
56: --MATL.FORMULALINE_ID
57: ,FM.OPRN_ID
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

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: