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_COMMON_VAL dependencies on GMD_RECIPE_PROCESS_LOSS

Line 615: FROM gmd_recipe_process_loss

611: AND v.recipe_validity_rule_id = vValidity_Rule_Id;
612:
613: CURSOR Get_recipe_orgn_loss (vRecipe_id NUMBER, vOrgn_code_id VARCHAR2) IS
614: SELECT process_loss
615: FROM gmd_recipe_process_loss
616: WHERE recipe_id = vRecipe_id
617: AND organization_id = vOrgn_code_id;
618:
619: BEGIN

Line 2340: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o

2336:
2337: -- Cursors to get the recipe over rides for a recipe id
2338: CURSOR Cur_recipe_override(p_formula_id number, p_inventory_item_id number) IS
2339: select r.recipe_no, r.recipe_version, o.organization_code
2340: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2341: where r.recipe_id = rpl.recipe_id
2342: AND r.formula_id = p_formula_id
2343: AND r.owner_organization_id <> rpl.organization_id
2344: AND rpl.organization_id = o.organization_id

Line 2355: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o

2351:
2352: -- Bug 5237351 added
2353: CURSOR Cur_recipe_override_revision(p_formula_id number, p_inventory_item_id number,p_revision VARCHAR2) IS
2354: select r.recipe_no, r.recipe_version, o.organization_code
2355: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2356: where r.recipe_id = rpl.recipe_id
2357: AND r.formula_id = p_formula_id
2358: AND r.owner_organization_id <> rpl.organization_id
2359: AND rpl.organization_id = o.organization_id