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 1205: gmd_routings_b rout

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

Line 1813: FROM gmd_routings_b

1809: FROM gmd_recipes_b
1810: WHERE recipe_id = vrecipe_id;
1811: CURSOR get_routing_owner_orgn_id(vrouting_id NUMBER) IS
1812: SELECT owner_organization_id
1813: FROM gmd_routings_b
1814: WHERE routing_id = vrouting_id;
1815: CURSOR get_operation_owner_orgn_id(voprn_id NUMBER) IS
1816: SELECT owner_organization_id
1817: FROM gmd_operations_b

Line 2138: UPDATE gmd_routings_b

2134: SET formula_status = '900'
2135: WHERE formula_id = l_formula_id
2136: AND to_number(formula_status) < 800;
2137:
2138: UPDATE gmd_routings_b
2139: SET routing_status = '900'
2140: WHERE routing_id = l_routing_id
2141: AND to_number(routing_status) < 800;
2142: