APPS.GMD_AUTO_STEP_CALC dependencies on GMD_RECIPES_B

Line 534: FROM gmd_recipes_b

530: /* Cursor Definitions.
531: =====================*/
532: CURSOR Cur_get_routing IS
533: SELECT routing_id
534: FROM gmd_recipes_b
535: WHERE recipe_id = P_parent_id;
536:
537: /* Gets all step no's that are dependent */
538: CURSOR Cur_get_steps IS

Line 1348: gmd_recipes_b r

1344: /* Get all formulaline information */
1345: CURSOR Cur_get_formulaline_info IS
1346: SELECT d.*
1347: FROM fm_matl_dtl d ,
1348: gmd_recipes_b r
1349: WHERE r.recipe_id = P_parent_id
1350: AND r.formula_id = d.formula_id
1351: ORDER BY d.line_type, d.line_no;
1352:

Line 1730: FROM gmd_recipes_b

1726: /* Cursor Definitions.
1727: =====================*/
1728: CURSOR Cur_get_recipe_details IS
1729: SELECT formula_id, routing_id
1730: FROM gmd_recipes_b
1731: WHERE recipe_id = P_check.parent_id;
1732:
1733: CURSOR Cur_get_rout_details (V_routing_id NUMBER) IS
1734: SELECT 1

Line 2087: gmd_recipes_b r,

2083: CURSOR Cur_get_step_mat_recipes (p_formulaline_id NUMBER, p_routingstep_id NUMBER) IS
2084: SELECT m.recipe_id,
2085: r.recipe_status
2086: FROM gmd_recipe_step_materials m,
2087: gmd_recipes_b r,
2088: gmd_status_b s
2089: WHERE s.status_code = r.recipe_status
2090: AND r.recipe_id = m.recipe_id
2091: AND ((p_formulaline_id is not null and m.formulaline_id = P_formulaline_id)