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 915: gmd_operation_activities a, cr_rsrc_dtl d

911: AND max_capacity = V_max_capacity
912: UNION
913: SELECT r.resources
914: FROM fm_rout_dtl d, gmd_operation_resources r,
915: gmd_operation_activities a, cr_rsrc_dtl d
916: WHERE d.routingstep_id = V_routingstep_id
917: AND d.oprn_id = a.oprn_id
918: AND a.oprn_line_id = r.oprn_line_id
919: AND r.resources = d.resources

Line 926: gmd_operation_activities a, cr_rsrc_mst m

922: AND capacity_constraint = 1
923: UNION
924: SELECT r.resources
925: FROM fm_rout_dtl d, gmd_operation_resources r,
926: gmd_operation_activities a, cr_rsrc_mst m
927: WHERE d.routingstep_id = V_routingstep_id
928: AND d.oprn_id = a.oprn_id
929: AND a.oprn_line_id = r.oprn_line_id
930: AND r.resources = m.resources

Line 1293: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm

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

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

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
1502: AND d.routing_id = r.routing_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 1702: gmd_operation_activities act , gmd_operation_resources res

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