[Home] [Help]
667: d.attribute15, d.attribute16, d.attribute17, d.attribute18,
668: d.attribute19, d.attribute20, d.attribute21, d.attribute22,
669: d.attribute23, d.attribute24, d.attribute25, d.attribute26,
670: d.attribute27, d.attribute28, d.attribute29, d.attribute30
671: FROM fm_rout_dtl d, gmd_operations_vl o
672: WHERE d.routing_id = p_routing_id
673: AND d.oprn_id = o.oprn_id ;
674: --END BUG#2330056
675:
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
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 */
1289: ra.attribute21, ra.attribute22, ra.attribute23, ra.attribute24,
1290: ra.attribute25, ra.attribute26, ra.attribute27, ra.attribute28,
1291: ra.attribute29, ra.attribute30, 1 recipe_override
1292: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,
1293: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm
1294: WHERE ra.recipe_id = p_recipe_id
1295: AND d.routingstep_id = ra.routingstep_id
1296: AND d.oprn_id = o.oprn_id
1297: AND a.activity = fm.activity
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
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
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