DBA Data[Home] [Help]

APPS.GMD_FORMULA_IBOM dependencies on GMD_RECIPES_B

Line 26: FROM gmd_recipe_validity_rules fe, fm_form_mst fm, gmd_recipes_b r

22: -- BEGIN BUG#3616788
23: CURSOR IBOM_CUR IS
24: SELECT fm.formula_id, fm.formula_no, fm.formula_vers,fe.min_qty, fe.max_qty,
25: fe.std_qty, fe.detail_uom, fe.preference,fe.last_update_date
26: FROM gmd_recipe_validity_rules fe, fm_form_mst fm, gmd_recipes_b r
27: WHERE fe.inventory_item_id = V_item_id
28: AND fe.recipe_use = eff_type
29: AND fm.formula_status LIKE NVL(inact_status,'%')
30: AND TRUNC(fe.start_date) <= TRUNC(TO_DATE(eff_date,'DD-MM-RRRR'))