Search 800 + Posts

Apr 7, 2014

Oracle OPM : Query to Retrieve Recipe and Recipe Validation Rule


Query to Retrive Recipe and Recipe Validation Rule


select recipe_no, recipe_version,grvr.orgn_code, grvr.item_id,grvr.min_qty, grvr.max_qty,grvr.std_qty,
grvr.recipe_validity_rule_id, grb.routing_id,
grb.formula_id, grb.recipe_id, grvr.organization_id,grb.owner_id,grb.owner_lab_type,grb.owner_organization_id
from gmd_recipes_b grb, gmd_recipe_validity_rules grvr
where 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

No comments:

Post a Comment