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 FM_ROUT_DTL

Line 671: FROM fm_rout_dtl d, gmd_operations_vl o

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:

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 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 871: FROM fm_rout_dtl d, gmd_operation_resources r,

867: AND organization_id = P_organization_id
868: AND max_capacity = V_max_capacity
869: UNION
870: SELECT r.resources
871: FROM fm_rout_dtl d, gmd_operation_resources r,
872: gmd_operation_activities a, cr_rsrc_dtl d
873: WHERE d.routingstep_id = V_routingstep_id
874: AND d.oprn_id = a.oprn_id
875: AND a.oprn_line_id = r.oprn_line_id

Line 882: FROM fm_rout_dtl d, gmd_operation_resources r,

878: AND d.max_capacity = V_max_capacity
879: AND capacity_constraint = 1
880: UNION
881: SELECT r.resources
882: FROM fm_rout_dtl d, gmd_operation_resources r,
883: gmd_operation_activities a, cr_rsrc_mst m
884: WHERE d.routingstep_id = V_routingstep_id
885: AND d.oprn_id = a.oprn_id
886: AND a.oprn_line_id = r.oprn_line_id

Line 1247: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,

1243: ra.attribute17, ra.attribute18, ra.attribute19, ra.attribute20,
1244: ra.attribute21, ra.attribute22, ra.attribute23, ra.attribute24,
1245: ra.attribute25, ra.attribute26, ra.attribute27, ra.attribute28,
1246: ra.attribute29, ra.attribute30, 1 recipe_override
1247: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,
1248: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm
1249: WHERE ra.recipe_id = p_recipe_id
1250: AND d.routingstep_id = ra.routingstep_id
1251: AND d.oprn_id = o.oprn_id

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