Search 800 + Posts

Apr 7, 2014

Oracle OPM : Query to Connect Resources , Operations , Routing and Recipes


Oracle OPM : Query to Connect Resources , Operations , Routing and Recipes

SELECT grb.recipe_no,
grb.recipe_version,
gor.resources,
mp.organization_code,
grb.recipe_id,
grb.routing_id,
grb.formula_id
grvr.recipe_validity_rule_id
FROM gmd_operation_resources gor,
gmd_operation_activities goa,
gmd_operations_b gob,
gmd_recipes_b grb,
fm_rout_dtl frd,
gmd_recipe_validity_rules grvr,
mtl_parameters mp,
gmd_recipe_orgn_resources gror
WHERE gor.oprn_line_id = goa.oprn_line_id
AND goa.oprn_id = gob.oprn_id
AND gob.oprn_id = frd.oprn_id
AND frd.routing_id = grb.routing_id
AND grb.recipe_id = grvr.recipe_id
AND grb.delete_mark = 0
AND grvr.delete_mark = 0
AND grvr.recipe_use IN('0', '1')
AND grvr.validity_rule_status IN('100','700', '900')
AND nvl(grvr.end_date, (sysdate + 1)) > sysdate
AND grvr.organization_id = mp.organization_id (+)
AND gor.resources = gror.resources

No comments:

Post a Comment