DBA Data[Home] [Help]

APPS.GMD_GME_INT dependencies on GMD_RECIPES_B

Line 60: FROM GMD_RECIPES_B C,

56: --MATL.ITEM_ID,
57: --MATL.FORMULALINE_ID
58: ,FM.OPRN_ID
59: ,FM.ROUTINGSTEP_ID
60: FROM GMD_RECIPES_B C,
61: FM_FORM_MST H,
62: fm_rout_dtl FM
63: --,FM_MATL_DTL MATL
64: WHERE

Line 77: from fm_matl_dtl md, gmd_Recipes_b r

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