APPS.GMD_RECIPE_MIGRATION dependencies on FM_FORM_MST_B

Line 22: fm_form_mst_b h

18: e.routing_id,
19: e.formula_id,
20: h.formula_desc1
21: FROM fm_form_eff_bak e,
22: fm_form_mst_b h
23: WHERE NOT EXISTS ( SELECT 1
24: FROM gmd_recipe_eff_assoc
25: WHERE fmeff_id = e.fmeff_id )
26: AND e.formula_id = h.formula_id

Line 43: FROM fm_form_mst_b h,

39: SELECT i.item_no,
40: e.formula_id,
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

Line 754: FROM fm_form_mst_b

750: are inactive. Recipes and VRs that use this formula are also obsoleted */
751: UPDATE gmd_recipes_b
752: SET recipe_status = '1000'
753: WHERE formula_id IN (SELECT formula_id
754: FROM fm_form_mst_b
755: WHERE formula_Status = '1000');
756:
757: /* Obsolete Vrs that are based on obsoleted Recipes */
758: UPDATE gmd_recipe_validity_rules

Line 930: FROM fm_form_mst_b ffm,

926: PROCEDURE qty_update_fxd_scaling IS
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