APPS.GMD_GME_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

   l_last_update_by                   NUMBER ;

Line: 52

  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
		;

Line: 74

    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