1730: , gmd_status gs
1731: , fm_matl_dtl fmd
1732: , fm_form_mst_b ffm /*fm_form_mst ffm bug# 4916871*/
1733: , gmd_routings_b rout /*gmd_routings rout bug#4916871*/
1734: , gem_lookups gl
1735: , gem_lookups gl2
1736: WHERE rout.routing_id(+) = bh.routing_id
1737: AND rvr.recipe_validity_rule_id = bh.recipe_validity_rule_id
1738: AND rvr.recipe_id = gr.recipe_id
1731: , fm_matl_dtl fmd
1732: , fm_form_mst_b ffm /*fm_form_mst ffm bug# 4916871*/
1733: , gmd_routings_b rout /*gmd_routings rout bug#4916871*/
1734: , gem_lookups gl
1735: , gem_lookups gl2
1736: WHERE rout.routing_id(+) = bh.routing_id
1737: AND rvr.recipe_validity_rule_id = bh.recipe_validity_rule_id
1738: AND rvr.recipe_id = gr.recipe_id
1739: AND ffm.formula_id = bh.formula_id