The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_update_by NUMBER ;
SELECT C.OWNER_ORGANIZATION_ID, C.ROUTING_ID,
C.RECIPE_ID, C.FORMULA_ID,
C.ROUTING_ID
--MATL.ITEM_ID,
--MATL.FORMULALINE_ID
,FM.OPRN_ID
,FM.ROUTINGSTEP_ID
FROM GMD_RECIPES_B C,
FM_FORM_MST H,
fm_rout_dtl FM
--,FM_MATL_DTL MATL
WHERE
C.ROUTING_ID= x_routing_id AND
C.RECIPE_ID = x_recipe_id AND
FM.ROUTINGSTEP_ID= x_routing_step_id and
H.formula_id = C.Formula_id
AND FM.routing_id = C.routing_ID
--AND c.FORMULA_ID = MATL.FORMULA_ID
--AND h.FORMULA_ID = MATL.FORMULA_ID
;
select distinct md.inventory_item_id,md.revision ----RLNAGARA B5389806 Added revision
,md.formulaline_id ----SMALLURU B6379386 Added formulaline_id
from fm_matl_dtl md, gmd_Recipes_b r
where r.recipe_id = p_recipe_id
and r.formula_id = md.formula_id
and md.line_type <> 2; -- no byproducts
SELECT nvl(control_batch_step_ind,'N') FROM gmd_wip_spec_vrs
WHERE spec_vr_id = x_spec_vr_id_in;