APPS.GMD_AUTO_STEP_CALC dependencies on GMD_RECIPES

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 1342: gmd_recipes_b r

1338: /* Get all formulaline information */
1339: CURSOR Cur_get_formulaline_info IS
1340: SELECT d.*
1341: FROM fm_matl_dtl d ,
1342: gmd_recipes_b r
1343: WHERE r.recipe_id = P_parent_id
1344: AND r.formula_id = d.formula_id
1345: ORDER BY d.line_type, d.line_no;
1346:

Line 1350: FROM fm_form_mst f, gmd_recipes r

1346:
1347: -- NPD Conv. Get the formula owner orgn id
1348: CURSOR get_formula_owner_orgn_id IS
1349: SELECT f.owner_organization_id
1350: FROM fm_form_mst f, gmd_recipes r
1351: WHERE r.recipe_id = P_parent_id
1352: AND f.formula_id = r.formula_id;
1353:
1354: l_orgn_id NUMBER;

Line 1724: FROM gmd_recipes_b

1720: /* Cursor Definitions.
1721: =====================*/
1722: CURSOR Cur_get_recipe_details IS
1723: SELECT formula_id, routing_id
1724: FROM gmd_recipes_b
1725: WHERE recipe_id = P_check.parent_id;
1726:
1727: CURSOR Cur_get_rout_details (V_routing_id NUMBER) IS
1728: SELECT 1

Line 2079: gmd_recipes_b r,

2075: CURSOR Cur_get_step_mat_recipes (p_formulaline_id NUMBER, p_routingstep_id NUMBER) IS
2076: SELECT m.recipe_id,
2077: r.recipe_status
2078: FROM gmd_recipe_step_materials m,
2079: gmd_recipes_b r,
2080: gmd_status_b s
2081: WHERE s.status_code = r.recipe_status
2082: AND r.recipe_id = m.recipe_id
2083: AND ((p_formulaline_id is not null and m.formulaline_id = P_formulaline_id)