DBA Data[Home] [Help]

APPS.GMD_RECIPE_FETCH_PUB dependencies on CR_RSRC_MST

Line 883: gmd_operation_activities a, cr_rsrc_mst m

879: AND capacity_constraint = 1
880: UNION
881: SELECT r.resources
882: FROM fm_rout_dtl d, gmd_operation_resources r,
883: gmd_operation_activities a, cr_rsrc_mst m
884: WHERE d.routingstep_id = V_routingstep_id
885: AND d.oprn_id = a.oprn_id
886: AND a.oprn_line_id = r.oprn_line_id
887: AND r.resources = m.resources

Line 1449: gmd_operation_resources res, cr_rsrc_mst_b m

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
1453: AND a.oprn_id = d.oprn_id

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