APPS.GMD_SPEC_VRS_GRP dependencies on GMD_STATUS

Line 1565: , gmd_status gs

1561: FROM gme_batch_header bh
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

Line 1603: , gmd_status s

1599: SELECT r.recipe_no, r.recipe_version
1600: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1601: , rout.routing_id, rout.routing_no, rout.routing_vers
1602: FROM gmd_recipes r
1603: , gmd_status s
1604: , gmd_recipe_validity_rules rvr
1605: , gmd_routings rout
1606: , fm_form_mst ffm
1607: , fm_matl_dtl fmd

Line 1629: , gmd_status s

1625:
1626: CURSOR c_recipe_no IS
1627: SELECT r.recipe_id, r.recipe_version
1628: FROM gmd_recipes r
1629: , gmd_status s
1630: , gmd_recipe_validity_rules rvr
1631: , gmd_routings rout
1632: , fm_form_mst ffm
1633: , fm_matl_dtl fmd

Line 1659: , gmd_status s

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
1662: AND gl.lookup_type = 'LINE_TYPE'
1663: AND grec.formula_id(+) = ffm.formula_id

Line 1679: , gmd_status s

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
1682: AND gl.lookup_type = 'LINE_TYPE'
1683: AND grec.formula_id(+) = ffm.formula_id

Line 1716: , gmd_status s

1712:
1713: CURSOR c_routing_id IS
1714: SELECT r.routing_no, r.routing_vers
1715: FROM gmd_recipes grec
1716: , gmd_status s
1717: , gmd_routings r
1718: WHERE grec.routing_id(+) = r.routing_id
1719: AND s.status_code = r.routing_status
1720: AND NVL( l_wip_vr.recipe_id, grec.recipe_id) = grec.recipe_id

Line 1730: , gmd_status s

1726:
1727: CURSOR c_routing_no IS
1728: SELECT r.routing_id, r.routing_vers
1729: FROM gmd_recipes grec
1730: , gmd_status s
1731: , gmd_routings r
1732: WHERE grec.routing_id(+) = r.routing_id
1733: AND s.status_code = r.routing_status
1734: AND NVL( l_wip_vr.recipe_id, grec.recipe_id) = grec.recipe_id