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.

[Home] [Help]

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 889: FROM fm_rout_dtl dtl, gmd_recipes_b recp , gmd_operations_vl oprn,

885: nvl(grrs.attribute27,dtl.attribute27),
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 */

Line 1146: FROM gmd_recipes_b

1142: --Sriram.S APS K Enhancements 03March2004 Bug# 3410379
1143: --Added chargable_ind column to the select statement
1144: FROM fm_rout_dep
1145: WHERE routing_id = (SELECT routing_id
1146: FROM gmd_recipes_b
1147: WHERE recipe_id = p_recipe_id) ;
1148:
1149:
1150: depd_rec fm_rout_dep%rowtype;

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

1311: a.attribute17, a.attribute18, a.attribute19, a.attribute20,
1312: a.attribute21, a.attribute22, a.attribute23, a.attribute24,
1313: a.attribute25, a.attribute26, a.attribute27, a.attribute28,
1314: a.attribute29, a.attribute30, 0 recipe_override
1315: FROM fm_rout_dtl d, gmd_recipes_b r , gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm
1316: WHERE r.recipe_id = p_recipe_id
1317: AND d.routing_id = r.routing_id
1318: AND o.oprn_id = d.oprn_id
1319: AND a.oprn_id = o.oprn_id

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

1493: ror.attribute25, ror.attribute26, ror.attribute27, ror.attribute28,
1494: ror.attribute29, ror.attribute30, 1 recipe_override,
1495: nvl(l.max_capacity,m.max_capacity)*(1+nvl(l.capacity_tolerance, m.capacity_tolerance)/100) max_calc_capacity,/*Added in bug13440294*/
1496: nvl(l.min_capacity, m.min_capacity)*(1-nvl(l.capacity_tolerance, m.capacity_tolerance)/100) min_calc_capacity /*Added in bug13440294*/
1497: FROM gmd_recipes_b r, fm_rout_dtl d,gmd_operations_vl o,
1498: gmd_operation_activities a, gmd_recipe_orgn_resources ror,
1499: gmd_operation_resources res, cr_rsrc_mst_b m
1500: , cr_rsrc_dtl l /*Added in bug13440294*/
1501: WHERE r.recipe_id = p_recipe_id

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

1544: res.attribute29, res.attribute30, 0 recipe_override,
1545: nvl(l.max_capacity,m.max_capacity)*(1+nvl(l.capacity_tolerance, m.capacity_tolerance)/100) max_calc_capacity,/*Added in bug13440294*/
1546: nvl(l.min_capacity, m.min_capacity)*(1-nvl(l.capacity_tolerance, m.capacity_tolerance)/100) min_calc_capacity /*Added in bug13440294*/
1547:
1548: FROM gmd_recipes_b r, fm_rout_dtl d, gmd_operations_vl o,gmd_operation_activities a,
1549: gmd_operation_resources res, cr_rsrc_mst_b m, cr_rsrc_dtl l
1550: WHERE r.recipe_id = p_recipe_id
1551: AND d.routing_id = r.routing_id
1552: AND d.oprn_id = o.oprn_id

Line 1701: FROM gmd_recipes_b rcp, fm_rout_dtl dtl,

1697: ) IS
1698:
1699: CURSOR Cur_get_recp_rsrc IS
1700: SELECT dtl.routingstep_id, dtl.routingstep_no, act.oprn_line_id, res.resources
1701: FROM gmd_recipes_b rcp, fm_rout_dtl dtl,
1702: gmd_operation_activities act , gmd_operation_resources res
1703: WHERE rcp.recipe_id = p_recipe_id
1704: AND dtl.routing_id = rcp.routing_id
1705: AND dtl.oprn_id = act.oprn_id

Line 1958: FROM gmd_recipes_b

1954:
1955: -- Cursor to fetch contiguous indicator at recipe level
1956: CURSOR get_recp_cont_ind( l_recp_id NUMBER) IS
1957: SELECT contiguous_ind
1958: FROM gmd_recipes_b
1959: WHERE recipe_id = l_recp_id;
1960:
1961: l_recipe_id NUMBER;
1962: l_orgn_id NUMBER;

Line 2068: FROM gmd_recipes_b

2064:
2065: -- Cursor to fetch enhanced PI flag at recipe level
2066: CURSOR get_pi_flag( l_recp_id NUMBER) IS
2067: SELECT enhanced_pi_ind
2068: FROM gmd_recipes_b
2069: WHERE recipe_id = l_recp_id;
2070:
2071: l_recipe_id NUMBER;
2072: l_pi_ind VARCHAR2(1);