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_CONC_REPLACE_PKG dependencies on GEM_LOOKUPS

Line 399: FROM Gem_lookups

395: -- Internal Functions
396: FUNCTION get_recipe_use(vRecipe_use VARCHAR2) Return VARCHAR2 IS
397: CURSOR recipe_use_meaning(vRecipe_use VARCHAR2) IS
398: SELECT meaning
399: FROM Gem_lookups
400: WHERE lookup_type = 'GMD_FORMULA_USE'
401: AND lookup_code = vRecipe_use;
402:
403: l_recipe_use VARCHAR2(100);

Line 479: FROM Gem_lookups

475: -- To retrieve the recipe_type
476: FUNCTION get_recipe_type(vRecipe_type VARCHAR2) Return VARCHAR2 IS
477: CURSOR recipe_type_meaning(vRecipe_type VARCHAR2) IS
478: SELECT meaning
479: FROM Gem_lookups
480: WHERE lookup_type = 'GMD_RECIPE_TYPE'
481: AND lookup_code = vRecipe_type;
482:
483: l_recipe_type VARCHAR2(100);