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_RECIPES_B

Line 116: FROM gmd_recipes_b

112: -- local cursor to fetch the routing_id from gmd_recipes table
113:
114: CURSOR get_rout IS
115: SELECT routing_id
116: FROM gmd_recipes_b
117: WHERE recipe_id = p_recipe_id OR
118: (recipe_no = p_recipe_no AND recipe_version = p_recipe_version);
119:
120:

Line 207: where routing_id = (select routing_id from gmd_recipes_b where recipe_id = p_recipe_id)

203: attribute19, attribute20, attribute21, attribute22,
204: attribute23, attribute24, attribute25, attribute26,
205: attribute27, attribute28, attribute29, attribute30
206: from fm_rout_hdr
207: where routing_id = (select routing_id from gmd_recipes_b where recipe_id = p_recipe_id)
208:
209: ORDER BY routing_id;
210:
211: begin

Line 337: from gmd_recipes_b

333: -- local cursor to fetch the formula_id from gmd_recipes table
334:
335: CURSOR get_form IS
336: select formula_id
337: from gmd_recipes_b
338: where recipe_id = p_recipe_id OR
339: (recipe_no = p_recipe_no and recipe_version = p_recipe_version);
340:
341: /*** local Variables ***/

Line 815: FROM gmd_recipes_b

811: l_orgn_code VARCHAR2(4);
812:
813: CURSOR Cur_get_recipe IS
814: SELECT routing_id, calculate_step_quantity
815: FROM gmd_recipes_b
816: WHERE recipe_id = p_recipe_id;
817:
818: CURSOR get_recipe_step (l_auto_calc NUMBER) IS
819: SELECT dtl.routingstep_no, oprn.oprn_id, oprn.oprn_no, oprn.oprn_desc, oprn.oprn_vers,

Line 849: FROM fm_rout_dtl dtl, gmd_recipes_b recp , gmd_operations_vl oprn

845: dtl.attribute17, dtl.attribute18, dtl.attribute19, dtl.attribute20,
846: dtl.attribute21, dtl.attribute22, dtl.attribute23, dtl.attribute24,
847: dtl.attribute25, dtl.attribute26, dtl.attribute27, dtl.attribute28,
848: dtl.attribute29, dtl.attribute30
849: FROM fm_rout_dtl dtl, gmd_recipes_b recp , gmd_operations_vl oprn
850: WHERE recp.recipe_id = p_recipe_id
851: AND dtl.routing_id = l_routing_id
852: AND oprn.oprn_id = dtl.oprn_id
853: AND dtl.routingstep_id NOT IN (SELECT routingstep_id

Line 1101: FROM gmd_recipes_b

1097: --Sriram.S APS K Enhancements 03March2004 Bug# 3410379
1098: --Added chargable_ind column to the select statement
1099: FROM fm_rout_dep
1100: WHERE routing_id = (SELECT routing_id
1101: FROM gmd_recipes_b
1102: WHERE recipe_id = p_recipe_id) ;
1103:
1104:
1105: depd_rec fm_rout_dep%rowtype;

Line 1270: FROM fm_rout_dtl d, gmd_recipes_b r , gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm

1266: a.attribute17, a.attribute18, a.attribute19, a.attribute20,
1267: a.attribute21, a.attribute22, a.attribute23, a.attribute24,
1268: a.attribute25, a.attribute26, a.attribute27, a.attribute28,
1269: a.attribute29, a.attribute30, 0 recipe_override
1270: FROM fm_rout_dtl d, gmd_recipes_b r , gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm
1271: WHERE r.recipe_id = p_recipe_id
1272: AND d.routing_id = r.routing_id
1273: AND o.oprn_id = d.oprn_id
1274: AND a.oprn_id = o.oprn_id

Line 1447: FROM gmd_recipes_b r, fm_rout_dtl d,gmd_operations_vl o,

1443: ror.attribute17, ror.attribute18, ror.attribute19, ror.attribute20,
1444: ror.attribute21, ror.attribute22,ror.attribute23, ror.attribute24,
1445: ror.attribute25, ror.attribute26, ror.attribute27, ror.attribute28,
1446: ror.attribute29, ror.attribute30, 1 recipe_override
1447: FROM gmd_recipes_b r, fm_rout_dtl d,gmd_operations_vl o,
1448: gmd_operation_activities a, gmd_recipe_orgn_resources ror,
1449: gmd_operation_resources res, cr_rsrc_mst_b m
1450: WHERE r.recipe_id = p_recipe_id
1451: AND d.routing_id = r.routing_id

Line 1492: FROM gmd_recipes_b r, fm_rout_dtl d, gmd_operations_vl o,gmd_operation_activities a,

1488: res.attribute21, res.attribute22,res.attribute23, res.attribute24,
1489: res.attribute25, res.attribute26, res.attribute27, res.attribute28,
1490: res.attribute29, res.attribute30, 0 recipe_override
1491:
1492: FROM gmd_recipes_b r, fm_rout_dtl d, gmd_operations_vl o,gmd_operation_activities a,
1493: gmd_operation_resources res, cr_rsrc_mst_b m, cr_rsrc_dtl l
1494: WHERE r.recipe_id = p_recipe_id
1495: AND d.routing_id = r.routing_id
1496: AND d.oprn_id = o.oprn_id

Line 1640: FROM gmd_recipes_b rcp, fm_rout_dtl dtl,

1636: ) IS
1637:
1638: CURSOR Cur_get_recp_rsrc IS
1639: SELECT dtl.routingstep_id, dtl.routingstep_no, act.oprn_line_id, res.resources
1640: FROM gmd_recipes_b rcp, fm_rout_dtl dtl,
1641: gmd_operation_activities act , gmd_operation_resources res
1642: WHERE rcp.recipe_id = p_recipe_id
1643: AND dtl.routing_id = rcp.routing_id
1644: AND dtl.oprn_id = act.oprn_id

Line 1897: FROM gmd_recipes_b

1893:
1894: -- Cursor to fetch contiguous indicator at recipe level
1895: CURSOR get_recp_cont_ind( l_recp_id NUMBER) IS
1896: SELECT contiguous_ind
1897: FROM gmd_recipes_b
1898: WHERE recipe_id = l_recp_id;
1899:
1900: l_recipe_id NUMBER;
1901: l_orgn_id NUMBER;

Line 2007: FROM gmd_recipes_b

2003:
2004: -- Cursor to fetch enhanced PI flag at recipe level
2005: CURSOR get_pi_flag( l_recp_id NUMBER) IS
2006: SELECT enhanced_pi_ind
2007: FROM gmd_recipes_b
2008: WHERE recipe_id = l_recp_id;
2009:
2010: l_recipe_id NUMBER;
2011: l_pi_ind VARCHAR2(1);