[Home] [Help]
597: BEGIN
598: SELECT a.formula_id INTO l_tpformula_id
599: FROM
600: (SELECT a.formula_id
601: FROM Fm_form_mst a, fm_matl_dtl b, gmd_technical_data_hdr g
602: WHERE b.item_id = l_formula_rec.item_id
603: AND a.formula_id = b.formula_id
604: AND g.item_id = b.item_id
605: AND g.formula_id = a.formula_id