DBA Data[Home] [Help]

APPS.GMD_SUBSTITUTION_PUB dependencies on FM_FORM_MST_B

Line 23: FROM fm_form_mst_b

19: AND rownum = 1;
20:
21: CURSOR validate_formula(vFormula_id NUMBER) IS
22: SELECT 1
23: FROM fm_form_mst_b
24: WHERE formula_id = vformula_id
25: AND delete_mark = 0
26: AND formula_status <> 1000;
27:

Line 30: FRom fm_form_mst_b

26: AND formula_status <> 1000;
27:
28: CURSOR get_formula_no_vers(vFormula_id NUMBER) IS
29: SELECT formula_no, Formula_vers
30: FRom fm_form_mst_b
31: WHERE FORMULA_id = vFormula_id;
32:
33: Cursor get_item_info(vItem_id NUMBER) IS
34: SELECT concatenated_segments, primary_uom_code