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.GMDFMVAL_PUB dependencies on GMD_RECIPES

Line 645: gmd_recipes_b rcp,

641: /* =================== */
642: CURSOR locked_val IS
643: SELECT rcp.formula_id
644: FROM gmd_recipe_validity_rules vr,
645: gmd_recipes_b rcp,
646: cm_cmpt_dtl cost
647: WHERE rcp.formula_id = pformula_id
648: AND vr.recipe_validity_rule_id = cost.fmeff_id
649: AND vr.recipe_id = rcp.recipe_id

Line 871: /* get the formula_id from gmd_recipes table */

867: END IF; /* End for formulaline condition */
868:
869: IF (pElement_name = 'RECIPE') THEN
870:
871: /* get the formula_id from gmd_recipes table */
872: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
873: -- get the formula id
874:
875: Select formula_id INTO l_formula_id

Line 876: From gmd_recipes

872: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
873: -- get the formula id
874:
875: Select formula_id INTO l_formula_id
876: From gmd_recipes
877: Where recipe_id = pRecord_in.Recipe_id;
878:
879: OPEN get_formula_no(l_formula_id);
880: FETCH get_formula_no

Line 933: /* get the formula_id from gmd_recipes table */

929: xReturn := 'S';
930:
931: IF (pElement_name = 'RECIPE') THEN
932:
933: /* get the formula_id from gmd_recipes table */
934: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
935: -- get the formula id
936:
937: SELECT formula_id INTO l_formula_id

Line 938: FROM gmd_recipes

934: IF (pRecord_in.Recipe_id IS NOT NULL) THEN
935: -- get the formula id
936:
937: SELECT formula_id INTO l_formula_id
938: FROM gmd_recipes
939: WHERE recipe_id = pRecord_in.Recipe_id;
940:
941: -- Call substitute item codeset, Bug 4479101
942: get_substitute_items(pFormula_id => l_formula_id,