APPS.GMD_RECIPE_MIGRATION dependencies on FM_ROUT_MTL_BAK

Line 61: /* Extracts routing step and line information from fm_rout_mtl_bak table */

57: e.routing_id,
58: i.item_desc1
59: ORDER BY i.item_no;
60:
61: /* Extracts routing step and line information from fm_rout_mtl_bak table */
62: CURSOR recipe_material_cur
63: IS
64: SELECT rm.routingstep_no,
65: rm.formulaline_id,

Line 74: FROM fm_rout_mtl_bak rm

70: rm.created_by,
71: rm.last_update_date,
72: rm.creation_date,
73: rm.last_update_login
74: FROM fm_rout_mtl_bak rm
75: WHERE rm.routingstep_no IS NOT NULL
76: AND NOT EXISTS ( SELECT 1
77: FROM gmd_recipe_step_materials
78: WHERE formulaline_id = rm.formulaline_id

Line 678: fm_rout_mtl_bak table */

674: WHERE recipe_validity_rule_id = fmeff_id );
675:
676: /* Step 5 */
677: /* Migrate data into the Recipe Materials Step table from
678: fm_rout_mtl_bak table */
679: FOR recipe_material_rec IN recipe_material_cur
680: LOOP
681: BEGIN
682: IF ( recipe_material_rec.routing_id IS NOT NULL )