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_OPERATION_ACTIVITIES

Line 872: gmd_operation_activities a, cr_rsrc_dtl d

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
876: AND r.resources = d.resources

Line 883: gmd_operation_activities a, cr_rsrc_mst m

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
887: AND r.resources = m.resources

Line 1248: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm

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
1252: AND a.activity = fm.activity

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 1448: gmd_operation_activities a, gmd_recipe_orgn_resources ror,

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
1452: AND d.oprn_id = o.oprn_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 1641: gmd_operation_activities act , gmd_operation_resources res

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
1645: AND act.oprn_line_id = res.oprn_line_id;