APPS.GMD_COMMON_VAL dependencies on GMD_ROUTINGS_B

Line 582: From gmd_routings_b

578: Where recipe_id = vRecipe_id;
579:
580: Cursor Rout_hdr_cur(vRouting_id NUMBER) IS
581: Select Routing_class, Routing_qty, Process_loss, routing_uom
582: From gmd_routings_b
583: Where routing_id = vRouting_id
584: and delete_mark = 0;
585:
586: --Bug 6871738. Select ROUTING_CLASS_UOM instead of UOM.

Line 1206: gmd_routings_b rout

1202: rout.routing_uom rout_uom,
1203: form.formula_id formula_id,
1204: form.yield_uom yield_typ_uom
1205: from fm_form_mst_b form,
1206: gmd_routings_b rout
1207: where form.formula_id = pformula_id and
1208: rout.routing_id = prouting_id ;
1209:
1210: l_formula_id NUMBER;

Line 1871: FROM gmd_routings_b

1867: FROM gmd_recipes_b
1868: WHERE recipe_id = vrecipe_id;
1869: CURSOR get_routing_owner_orgn_id(vrouting_id NUMBER) IS
1870: SELECT owner_organization_id
1871: FROM gmd_routings_b
1872: WHERE routing_id = vrouting_id;
1873: CURSOR get_operation_owner_orgn_id(voprn_id NUMBER) IS
1874: SELECT owner_organization_id
1875: FROM gmd_operations_b

Line 2196: UPDATE gmd_routings_b

2192: SET formula_status = '900'
2193: WHERE formula_id = l_formula_id
2194: AND to_number(formula_status) < 800;
2195:
2196: UPDATE gmd_routings_b
2197: SET routing_status = '900'
2198: WHERE routing_id = l_routing_id
2199: AND to_number(routing_status) < 800;
2200:

Line 3032: UPDATE gmd_routings_b

3028: SET formula_status = '900'
3029: WHERE formula_id = l_formula_id
3030: AND to_number(formula_status) < 800;
3031:
3032: UPDATE gmd_routings_b
3033: SET routing_status = '900'
3034: WHERE routing_id = l_routing_id
3035: AND to_number(routing_status) < 800;
3036: