APPS.GMD_RECIPE_FETCH_PUB dependencies on CR_RSRC_DTL

Line 872: gmd_operation_activities a, cr_rsrc_dtl d

868: AND max_capacity = V_max_capacity
869: UNION
870: SELECT r.resources
871: FROM fm_rout_dtl d, gmd_operation_resources r,
872: gmd_operation_activities a, cr_rsrc_dtl d
873: WHERE d.routingstep_id = V_routingstep_id
874: AND d.oprn_id = a.oprn_id
875: AND a.oprn_line_id = r.oprn_line_id
876: AND r.resources = d.resources

Line 1493: gmd_operation_resources res, cr_rsrc_mst_b m, cr_rsrc_dtl l

1489: res.attribute25, res.attribute26, res.attribute27, res.attribute28,
1490: res.attribute29, res.attribute30, 0 recipe_override
1491:
1492: FROM gmd_recipes_b r, fm_rout_dtl d, gmd_operations_vl o,gmd_operation_activities a,
1493: gmd_operation_resources res, cr_rsrc_mst_b m, cr_rsrc_dtl l
1494: WHERE r.recipe_id = p_recipe_id
1495: AND d.routing_id = r.routing_id
1496: AND d.oprn_id = o.oprn_id
1497: AND o.oprn_id = a.oprn_id

Line 1686: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c

1682:
1683: /* Parameters at the plant resource level */
1684: CURSOR Cur_get_plnt_rsrc (V_resources VARCHAR2, V_parameter_id NUMBER) IS
1685: SELECT p.*
1686: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c
1687: WHERE p.resource_id = c.resource_id
1688: AND organization_id = p_organization_id
1689: AND resources = V_resources
1690: AND parameter_id = V_parameter_id;