[Home] [Help]
1999: x_return_status OUT NOCOPY VARCHAR2)
2000: IS
2001: CURSOR get_primary_product_uom ( v_batch_id IN NUMBER )IS
2002: SELECT gm.dtl_um
2003: FROM gmd_recipe_validity_rules vr, gme_material_details gm, gme_batch_header bh
2004: WHERE bh.recipe_validity_rule_id = vr.recipe_validity_rule_id
2005: AND bh.batch_id = gm.batch_id
2006: AND vr.inventory_item_id = gm.inventory_item_id
2007: AND gm.line_type = 1 /*FPBug# 4684029 rework */