APPS.GMD_COMMON_VAL dependencies on GMD_RECIPE_ROUTING_STEPS

Line 1382: FROM gmd_recipe_routing_steps

1378: ORDER BY dtl.routingStep_id;
1379:
1380: CURSOR Get_Recipe_Step_Details(vRecipe_id NUMBER, vRoutingStep_id NUMBER) IS
1381: SELECT step_qty, mass_qty, mass_std_uom, volume_qty, volume_std_uom
1382: FROM gmd_recipe_routing_steps
1383: WHERE recipe_id = vRecipe_id AND
1384: routingstep_id = vRoutingStep_id;
1385:
1386: BEGIN

Line 1431: /* Table gmd_recipe_routing_steps stores step qtys that are overridden */

1427: /* 2) As, mass qty in mass reference uom */
1428: /* 3) As, volume qty in volume reference uom */
1429:
1430: /* Check if the step qty has been overridden at recipe level */
1431: /* Table gmd_recipe_routing_steps stores step qtys that are overridden */
1432:
1433: /* This cursor should return only one row */
1434: FOR Get_Recipe_Step_rec IN
1435: Get_Recipe_Step_Details(Recipe_id, Step_qty_rec.routingStep_id) LOOP