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 1563: , gmd_recipes_b gr -- just need base table here not view

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

Line 1602: FROM gmd_recipes r

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

Line 1628: FROM gmd_recipes r

1624: AND NVL( l_wip_vr.routing_id, rout.routing_id) = rout.routing_id;
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

Line 1655: FROM gmd_recipes grec

1651: AND NVL( l_wip_vr.routing_id, rout.routing_id) = rout.routing_id;
1652:
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

Line 1675: FROM gmd_recipes grec

1671: AND ffm.formula_id = l_wip_vr.formula_id;
1672:
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

Line 1715: FROM gmd_recipes grec

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

Line 1729: FROM gmd_recipes grec

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

Line 1778: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;

1774: dummy PLS_INTEGER;
1775: l_status_ctl VARCHAR2(1);
1776: l_lot_ctl NUMBER;
1777:
1778: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1779: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1780: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1781: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1782: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;

Line 1779: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;

1775: l_status_ctl VARCHAR2(1);
1776: l_lot_ctl NUMBER;
1777:
1778: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1779: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1780: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1781: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1782: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1783: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;

Line 1780: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;

1776: l_lot_ctl NUMBER;
1777:
1778: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1779: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1780: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1781: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1782: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1783: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1784: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;