DBA Data[Home] [Help]

APPS.GMD_RECIPE_FETCH_PUB dependencies on CR_RSRC_DTL

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 1500: , cr_rsrc_dtl l /*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
1504: AND a.oprn_id = d.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 1747: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c

1743:
1744: /* Parameters at the plant resource level */
1745: CURSOR Cur_get_plnt_rsrc (V_resources VARCHAR2, V_parameter_id NUMBER) IS
1746: SELECT p.*
1747: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c
1748: WHERE p.resource_id = c.resource_id
1749: AND organization_id = p_organization_id
1750: AND resources = V_resources
1751: AND parameter_id = V_parameter_id;