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_ROUTINGS

Line 1568: , gmd_routings_b rout -- 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
1571: AND rvr.recipe_id = gr.recipe_id
1572: AND ffm.formula_id = bh.formula_id

Line 1605: , gmd_routings rout

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
1608: WHERE rout.routing_id(+) = r.routing_id
1609: AND ffm.formula_id = r.formula_id

Line 1631: , gmd_routings rout

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
1634: WHERE rout.routing_id(+) = r.routing_id
1635: AND ffm.formula_id = r.formula_id

Line 1717: , gmd_routings r

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
1721: AND NVL( l_wip_vr.formula_id, grec.formula_id) = grec.formula_id

Line 1731: , gmd_routings r

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
1735: AND NVL( l_wip_vr.formula_id, grec.formula_id) = grec.formula_id

Line 1784: l_routing_id GMD_ROUTINGS.ROUTING_ID%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;
1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;

Line 1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%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;
1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;

Line 1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%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;
1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1790: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;