APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMD_RECIPES

Line 225: FROM gmd_recipes_b gr,

221: gmd_operation_resources ores,
222: fm_rout_dtl rdtl,
223: gmd_routings_b rhdr,
224: (SELECT distinct gr.routing_id
225: FROM gmd_recipes_b gr,
226: gmd_recipe_validity_rules grv,
227: gmd_status_b gs
228: WHERE gr.recipe_id = grv.recipe_id
229: AND grv.validity_rule_status = gs.status_code

Line 304: ||' FROM gmd_recipes grb, '

300: ||' grb.routing_id, gc.organization_id, '
301: ||' gc.routingstep_id, gc.oprn_line_id, gc.recipe_id, '
302: ||' gc.activity_factor, '
303: ||' gc.resources, gc.resource_usage, gc.process_qty '
304: ||' FROM gmd_recipes grb, '
305: ||' gmd_status_b gs, '
306: ||' ( '
307: ||' SELECT '
308: ||' gor.recipe_id, '

Line 396: ||' FROM gmd_recipes grb, '

392:
393: recipe_statement :=
394: ' SELECT grb.routing_id, grs.routingstep_id, grs.recipe_id, '
395: ||' grs.step_qty '
396: ||' FROM gmd_recipes grb, '
397: ||' gmd_status_b gs, '
398: ||' gmd_recipe_routing_steps grs '
399: ||' WHERE grb.recipe_id = grs.recipe_id '
400: ||' AND grb.delete_mark = 0 '

Line 605: FROM gmd_recipes

601: orgn_step := 1;
602:
603: OPEN cur_calc_step_qty FOR
604: SELECT calculate_step_quantity
605: FROM gmd_recipes
606: WHERE recipe_id = item_eff.recipe_id;
607:
608: FETCH cur_calc_step_qty INTO calc_step_qty_flag;
609: CLOSE cur_calc_step_qty;