APPS.GMD_RECIPE_MIGRATION dependencies on FM_MATL_DTL

Line 45: fm_matl_dtl m,

41: e.routing_id,
42: i.item_desc1
43: FROM fm_form_mst_b h,
44: fm_form_eff_bak e,
45: fm_matl_dtl m,
46: ic_item_mst i
47: WHERE NOT EXISTS ( SELECT 1
48: FROM gmd_recipe_eff_assoc
49: WHERE fmeff_id = e.fmeff_id )

Line 931: fm_matl_dtl fmd,

927: CURSOR fixed_scaling IS
928: SELECT grv.item_id, fmd.qty,fmd.item_um base_um, grv.std_qty, grv.item_um conv_um,
929: recipe_validity_rule_id rule_id, grv.min_qty, grv.max_qty
930: FROM fm_form_mst_b ffm,
931: fm_matl_dtl fmd,
932: gmd_recipes_b gr,
933: gmd_recipe_validity_rules grv
934: WHERE ffm.formula_id = fmd.formula_id
935: AND ffm.formula_id = gr.formula_id