APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 907: FROM gmd_recipe_orgn_resources

903: /*Added the following cursor to pass back the resource causing the charge on the step */
904:
905: CURSOR Cur_get_charge_resource (V_routingstep_id NUMBER, V_max_capacity NUMBER) IS
906: SELECT resources
907: FROM gmd_recipe_orgn_resources
908: WHERE routingstep_id = V_routingstep_id
909: AND recipe_id = p_recipe_id
910: AND organization_id = P_organization_id
911: AND max_capacity = V_max_capacity

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 1560: FROM gmd_recipe_orgn_resources ror

1556: AND m.resources = l.resources (+)
1557: AND l.organization_id (+) = p_organization_id
1558: AND (res.oprn_line_id, res.resources)
1559: NOT IN ( SELECT oprn_line_id, resources
1560: FROM gmd_recipe_orgn_resources ror
1561: WHERE recipe_id = p_recipe_id
1562: AND (p_organization_id IS NULL OR organization_id = p_organization_id)
1563: AND d.routingstep_id = ror.routingstep_id) -- Bug No.7652625
1564: --Added the order by for the bug 12613037.