APPS.GMD_SPEC_VRS_GRP dependencies on GMD_STATUS

Line 1606: , gmd_status gs

1602: FROM gme_batch_header bh
1603: , gme_material_details md
1604: , gmd_recipes_b gr -- just need base table here not view
1605: , gmd_recipe_validity_rules rvr
1606: , gmd_status gs
1607: , fm_matl_dtl fmd
1608: , fm_form_mst_b ffm -- just need base table here not view
1609: , gmd_routings_b rout -- just need base table here not view
1610: WHERE rout.routing_id(+) = bh.routing_id

Line 1650: , gmd_status s

1646: SELECT r.recipe_no, r.recipe_version
1647: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1648: , rout.routing_id, rout.routing_no, rout.routing_vers
1649: FROM gmd_recipes r
1650: , gmd_status s
1651: , gmd_recipe_validity_rules rvr
1652: , gmd_routings rout
1653: , fm_form_mst ffm
1654: , fm_matl_dtl fmd

Line 1677: , gmd_status s

1673:
1674: CURSOR c_recipe_no IS
1675: SELECT r.recipe_id, r.recipe_version
1676: FROM gmd_recipes r
1677: , gmd_status s
1678: , gmd_recipe_validity_rules rvr
1679: , gmd_routings rout
1680: , fm_form_mst ffm
1681: , fm_matl_dtl fmd

Line 1708: , gmd_status s

1704: FROM gmd_recipes grec
1705: , fm_form_mst ffm
1706: , fm_matl_dtl fmd
1707: , gem_lookups gl
1708: , gmd_status s
1709: WHERE s.status_code = ffm.formula_status
1710: AND gl.lookup_code = fmd.line_type
1711: AND gl.lookup_type = 'LINE_TYPE'
1712: AND grec.formula_id(+) = ffm.formula_id

Line 1728: , gmd_status s

1724: FROM gmd_recipes grec
1725: , fm_form_mst ffm
1726: , fm_matl_dtl fmd
1727: , gem_lookups gl
1728: , gmd_status s
1729: WHERE s.status_code = ffm.formula_status
1730: AND gl.lookup_code = fmd.line_type
1731: AND gl.lookup_type = 'LINE_TYPE'
1732: AND grec.formula_id(+) = ffm.formula_id

Line 1765: , gmd_status s

1761:
1762: CURSOR c_routing_id IS
1763: SELECT r.routing_no, r.routing_vers
1764: FROM gmd_recipes grec
1765: , gmd_status s
1766: , gmd_routings r
1767: WHERE grec.routing_id(+) = r.routing_id
1768: AND s.status_code = r.routing_status
1769: AND NVL( l_wip_vr.recipe_id, 0) = grec.recipe_id(+) /*changed in bug# 6278463 */

Line 1779: , gmd_status s

1775:
1776: CURSOR c_routing_no IS
1777: SELECT r.routing_id, r.routing_vers
1778: FROM gmd_recipes grec
1779: , gmd_status s
1780: , gmd_routings r
1781: WHERE grec.routing_id(+) = r.routing_id
1782: AND s.status_code = r.routing_status
1783: AND NVL( l_wip_vr.recipe_id, 0) = grec.recipe_id(+) /*changed in bug# 6278463 */

Line 1828: , gmd_status s

1824: CURSOR c_recipe_id_no_route IS
1825: SELECT r.recipe_no, r.recipe_version
1826: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1827: FROM gmd_recipes r
1828: , gmd_status s
1829: , gmd_recipe_validity_rules rvr
1830: , fm_form_mst ffm
1831: , fm_matl_dtl fmd
1832: WHERE ffm.formula_id = r.formula_id

Line 1849: , gmd_status s

1845:
1846: CURSOR c_recipe_no_no_route IS
1847: SELECT r.recipe_id, r.recipe_version
1848: FROM gmd_recipes r
1849: , gmd_status s
1850: , gmd_recipe_validity_rules rvr
1851: , fm_form_mst ffm
1852: , fm_matl_dtl fmd
1853: WHERE ffm.formula_id = r.formula_id