APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_OPERATION_RESOURCES

Line 914: FROM fm_rout_dtl d, gmd_operation_resources r,

910: AND organization_id = P_organization_id
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

Line 925: FROM fm_rout_dtl d, gmd_operation_resources r,

921: AND d.max_capacity = V_max_capacity
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

Line 1499: gmd_operation_resources res, cr_rsrc_mst_b m

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
1503: AND d.oprn_id = o.oprn_id

Line 1549: gmd_operation_resources res, cr_rsrc_mst_b m, cr_rsrc_dtl l

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
1553: AND o.oprn_id = a.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;