APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 864: FROM gmd_recipe_orgn_resources

860: /*Added the following cursor to pass back the resource causing the charge on the step */
861:
862: CURSOR Cur_get_charge_resource (V_routingstep_id NUMBER, V_max_capacity NUMBER) IS
863: SELECT resources
864: FROM gmd_recipe_orgn_resources
865: WHERE routingstep_id = V_routingstep_id
866: AND recipe_id = p_recipe_id
867: AND organization_id = P_organization_id
868: AND max_capacity = V_max_capacity

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 1504: FROM gmd_recipe_orgn_resources

1500: AND m.resources = l.resources (+)
1501: AND l.organization_id (+) = p_organization_id
1502: AND (res.oprn_line_id, res.resources)
1503: NOT IN ( SELECT oprn_line_id, resources
1504: FROM gmd_recipe_orgn_resources
1505: WHERE recipe_id = p_recipe_id
1506: AND (p_organization_id IS NULL OR organization_id = p_organization_id))
1507: ORDER BY recipeid, routing_step_no, oprnline_id ;
1508: