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 2282: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o

2278:
2279: -- Cursors to get the recipe over rides for a recipe id
2280: CURSOR Cur_recipe_override(p_formula_id number, p_inventory_item_id number) IS
2281: select r.recipe_no, r.recipe_version, o.organization_code
2282: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2283: where r.recipe_id = rpl.recipe_id
2284: AND r.formula_id = p_formula_id
2285: AND r.owner_organization_id <> rpl.organization_id
2286: AND rpl.organization_id = o.organization_id

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

2293:
2294: -- Bug 5237351 added
2295: CURSOR Cur_recipe_override_revision(p_formula_id number, p_inventory_item_id number,p_revision VARCHAR2) IS
2296: select r.recipe_no, r.recipe_version, o.organization_code
2297: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2298: where r.recipe_id = rpl.recipe_id
2299: AND r.formula_id = p_formula_id
2300: AND r.owner_organization_id <> rpl.organization_id
2301: AND rpl.organization_id = o.organization_id