APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPE_STEP_MATERIALS

Line 77: FROM gmd_recipe_step_materials

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
79: AND EXISTS ( SELECT recipe_id
80: FROM gmd_recipes
81: WHERE formula_id = rm.formula_id

Line 148: FROM gmd_recipe_step_materials

144: Cursor check_step_mat_exists(v_recipe_id NUMBER, v_formulaline_id NUMBER) IS
145: SELECT 1
146: FROM sys.DUAL
147: WHERE EXISTS ( SELECT 1
148: FROM gmd_recipe_step_materials
149: WHERE recipe_id = v_recipe_id
150: AND formulaline_id = v_formulaline_id);
151:
152: /* Get all invalid validity rules */

Line 714: INSERT INTO gmd_recipe_step_materials

710: OPEN check_step_mat_exists(l_recipe_id,
711: recipe_material_rec.formulaline_id);
712: FETCH check_step_mat_exists INTO l_dummy_id;
713: IF (check_step_mat_exists%NOTFOUND) THEN
714: INSERT INTO gmd_recipe_step_materials
715: ( recipe_id,
716: routingstep_id,
717: formulaline_id,
718: creation_date,

Line 740: ,p_target_table => 'GMD_RECIPE_STEP_MATERIALS'

736: WHEN OTHERS
737: THEN
738: error_msg := SQLERRM;
739: insert_message (p_source_table => 'FM_ROUT_MTL'
740: ,p_target_table => 'GMD_RECIPE_STEP_MATERIALS'
741: ,p_source_id => recipe_material_rec.formulaline_id
742: ,p_target_id => recipe_material_rec.formulaline_id
743: ,p_message => error_msg
744: ,p_error_type => 'U');