APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMD_RECIPES

Line 229: FROM gmd_recipes_b gr,

225: gmd_operation_resources ores,
226: fm_rout_dtl rdtl,
227: gmd_routings_b rhdr,
228: (SELECT DISTINCT gr.routing_id
229: FROM gmd_recipes_b gr,
230: gmd_recipe_validity_rules grv,
231: gmd_status_b gs
232: WHERE gr.recipe_id = grv.recipe_id
233: AND grv.validity_rule_status = gs.status_code

Line 308: ||' FROM gmd_recipes grb, '

304: ||' grb.routing_id, gc.organization_id, '
305: ||' gc.routingstep_id, gc.oprn_line_id, gc.recipe_id, '
306: ||' gc.activity_factor, '
307: ||' gc.resources, gc.resource_usage, gc.process_qty '
308: ||' FROM gmd_recipes grb, '
309: ||' gmd_status_b gs, '
310: ||' ( '
311: ||' SELECT '
312: ||' gor.recipe_id, '

Line 430: ||' FROM gmd_recipes grb, '

426:
427: recipe_statement :=
428: ' SELECT grb.routing_id, grs.routingstep_id, grs.recipe_id, '
429: ||' grs.step_qty '
430: ||' FROM gmd_recipes grb, '
431: ||' gmd_status_b gs, '
432: ||' gmd_recipe_routing_steps grs '
433: ||' WHERE grb.recipe_id = grs.recipe_id '
434: ||' AND grb.delete_mark = 0 '

Line 676: FROM gmd_recipes

672: c_activity_factor := -1; -- Bug: 8736658
673:
674: OPEN cur_calc_step_qty FOR
675: SELECT calculate_step_quantity
676: FROM gmd_recipes
677: WHERE recipe_id = item_eff.recipe_id;
678:
679: FETCH cur_calc_step_qty INTO calc_step_qty_flag;
680: CLOSE cur_calc_step_qty;