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_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ROUTING_STEPS

Line 831: FROM gmd_recipe_routing_steps stp, fm_rout_dtl dtl, gmd_operations_vl oprn

827: stp.attribute17, stp.attribute18, stp.attribute19, stp.attribute20,
828: stp.attribute21, stp.attribute22, stp.attribute23, stp.attribute24,
829: stp.attribute25, stp.attribute26, stp.attribute27, stp.attribute28,
830: stp.attribute29, stp.attribute30
831: FROM gmd_recipe_routing_steps stp, fm_rout_dtl dtl, gmd_operations_vl oprn
832: WHERE l_auto_calc = 0
833: AND stp.recipe_id = p_recipe_id
834: AND dtl.routingstep_id = stp.routingstep_id
835: AND dtl.oprn_id = oprn.oprn_id

Line 890: gmd_recipe_routing_steps grrs /* Added in Bug No.8428182 */

886: nvl(grrs.attribute28,dtl.attribute28),
887: nvl(grrs.attribute29,dtl.attribute29),
888: nvl(grrs.attribute30,dtl.attribute30)
889: FROM fm_rout_dtl dtl, gmd_recipes_b recp , gmd_operations_vl oprn,
890: gmd_recipe_routing_steps grrs /* Added in Bug No.8428182 */
891: WHERE recp.recipe_id = p_recipe_id
892: AND grrs.recipe_id(+) = p_recipe_id /* Added in Bug No.8428182 */
893: AND grrs.routingstep_id(+) = dtl.routingstep_id /* Added in Bug No.8428182 */
894: AND dtl.routing_id = l_routing_id

Line 897: FROM gmd_recipe_routing_steps

893: AND grrs.routingstep_id(+) = dtl.routingstep_id /* Added in Bug No.8428182 */
894: AND dtl.routing_id = l_routing_id
895: AND oprn.oprn_id = dtl.oprn_id
896: AND dtl.routingstep_id NOT IN (SELECT routingstep_id
897: FROM gmd_recipe_routing_steps
898: WHERE recipe_id = p_recipe_id
899: AND l_auto_calc = 0)
900: ORDER BY routingstep_no;
901: