177: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS
180: l_in_batch_header gme_batch_header%ROWTYPE;
181: l_formula_master fm_form_mst%ROWTYPE;
182: l_formula_material fm_matl_dtl%ROWTYPE;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_item_master mtl_system_items_kfv%ROWTYPE;
185: l_gme_material_detail gme_material_details%ROWTYPE;
2635: NULL,NULL)
2636: )
2637: )
2638: / (ffm.total_output_qty * frd.step_qty)
2639: FROM fm_form_mst ffm,
2640: fm_matl_dtl fmd,
2641: fm_rout_hdr frh,
2642: fm_rout_dtl frd,
2643: mtl_system_items iim,