eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_RECIPES

Line 1604: , gmd_recipes_b gr -- just need base table here not view

1600: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1601: , rout.routing_id, rout.routing_no, rout.routing_vers
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

Line 1649: FROM gmd_recipes r

1645: CURSOR c_recipe_id IS
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

Line 1676: FROM gmd_recipes r

1672: AND NVL( l_wip_vr.routing_id, 0) = rout.routing_id(+);/*changed in bug# 6278463 */
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

Line 1704: FROM gmd_recipes grec

1700: AND NVL( l_wip_vr.routing_id, 0) = rout.routing_id(+);/*added in bug #6278463 */
1701:
1702: CURSOR c_formula_id IS
1703: SELECT ffm.formula_no, ffm.formula_vers
1704: FROM gmd_recipes grec
1705: , fm_form_mst ffm
1706: , fm_matl_dtl fmd
1707: , gem_lookups gl
1708: , gmd_status s

Line 1724: FROM gmd_recipes grec

1720: AND ffm.formula_id = l_wip_vr.formula_id;
1721:
1722: CURSOR c_formula_no IS
1723: SELECT ffm.formula_id, ffm.formula_vers
1724: FROM gmd_recipes grec
1725: , fm_form_mst ffm
1726: , fm_matl_dtl fmd
1727: , gem_lookups gl
1728: , gmd_status s

Line 1764: FROM gmd_recipes grec

1760:
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

Line 1778: FROM gmd_recipes grec

1774: AND r.routing_id = l_wip_vr.routing_id;
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

Line 1827: FROM gmd_recipes r

1823: -- 8901257 start
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

Line 1848: FROM gmd_recipes r

1844: AND NVL( l_wip_vr.formula_id, r.formula_id) = r.formula_id;
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

Line 1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;

1873: dummy PLS_INTEGER;
1874: l_status_ctl VARCHAR2(1);
1875: l_lot_ctl NUMBER;
1876:
1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;

Line 1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;

1874: l_status_ctl VARCHAR2(1);
1875: l_lot_ctl NUMBER;
1876:
1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;

Line 1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;

1875: l_lot_ctl NUMBER;
1876:
1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;