[Home] [Help]
1562: , gme_material_details md
1563: , gmd_recipes_b gr -- just need base table here not view
1564: , gmd_recipe_validity_rules rvr
1565: , gmd_status gs
1566: , fm_matl_dtl fmd
1567: , fm_form_mst_b ffm -- just need base table here not view
1568: , gmd_routings_b rout -- just need base table here not view
1569: WHERE rout.routing_id(+) = bh.routing_id
1570: AND rvr.recipe_validity_rule_id = bh.recipe_validity_rule_id
1603: , gmd_status s
1604: , gmd_recipe_validity_rules rvr
1605: , gmd_routings rout
1606: , fm_form_mst ffm
1607: , fm_matl_dtl fmd
1608: WHERE rout.routing_id(+) = r.routing_id
1609: AND ffm.formula_id = r.formula_id
1610: AND rvr.recipe_id = r.recipe_id
1611: AND (NVL( l_wip_vr.organization_id, rvr.organization_id) = rvr.organization_id OR rvr.organization_id IS NULL)
1629: , gmd_status s
1630: , gmd_recipe_validity_rules rvr
1631: , gmd_routings rout
1632: , fm_form_mst ffm
1633: , fm_matl_dtl fmd
1634: WHERE rout.routing_id(+) = r.routing_id
1635: AND ffm.formula_id = r.formula_id
1636: AND rvr.recipe_id = r.recipe_id
1637: AND (NVL( l_wip_vr.organization_id, rvr.organization_id) = rvr.organization_id OR rvr.organization_id IS NULL)
1653: CURSOR c_formula_id IS
1654: SELECT ffm.formula_no, ffm.formula_vers
1655: FROM gmd_recipes grec
1656: , fm_form_mst ffm
1657: , fm_matl_dtl fmd
1658: , gem_lookups gl
1659: , gmd_status s
1660: WHERE s.status_code = ffm.formula_status
1661: AND gl.lookup_code = fmd.line_type
1673: CURSOR c_formula_no IS
1674: SELECT ffm.formula_id, ffm.formula_vers
1675: FROM gmd_recipes grec
1676: , fm_form_mst ffm
1677: , fm_matl_dtl fmd
1678: , gem_lookups gl
1679: , gmd_status s
1680: WHERE s.status_code = ffm.formula_status
1681: AND gl.lookup_code = fmd.line_type
1693:
1694:
1695: CURSOR c_formulaline_id IS
1696: SELECT 1
1697: FROM fm_matl_dtl fmd
1698: WHERE fmd.inventory_item_id = p_spec.inventory_item_id
1699: AND fmd.formula_id = l_wip_vr.formula_id
1700: AND fmd.formulaline_id = l_wip_vr.formulaline_id;
1701: