APPS.GMD_COMMON_VAL dependencies on FM_FORM_MST_B

Line 603: FROM fm_form_mst_b

599: ORDER BY max_quantity;
600:
601: CURSOR get_total_qty_cur(vFormula_id NUMBER) IS
602: SELECT total_output_qty, yield_uom
603: FROM fm_form_mst_b
604: WHERE formula_id = vFormula_id;
605:
606: -- NPD Conv.
607: CURSOR Get_validity_cur (vValidity_Rule_Id NUMBER) IS

Line 1024: FROM fm_form_mst_b

1020: l_return_status VARCHAR2(10);
1021:
1022: CURSOR get_formula_owner_orgn_id(vformula_id NUMBER) IS
1023: SELECT owner_organization_id
1024: FROM fm_form_mst_b
1025: WHERE formula_id = vformula_id;
1026:
1027: BEGIN
1028:

Line 1205: from fm_form_mst_b form,

1201: form.total_output_qty recipe_qty,
1202: rout.routing_uom rout_uom,
1203: form.formula_id formula_id,
1204: form.yield_uom yield_typ_uom
1205: from fm_form_mst_b form,
1206: gmd_routings_b rout
1207: where form.formula_id = pformula_id and
1208: rout.routing_id = prouting_id ;
1209:

Line 1863: FROM fm_form_mst_b

1859: Status_cur Status_ref_cur;
1860:
1861: CURSOR get_formula_owner_orgn_id(vformula_id NUMBER) IS
1862: SELECT owner_organization_id
1863: FROM fm_form_mst_b
1864: WHERE formula_id = vformula_id;
1865: CURSOR get_recipe_owner_orgn_id(vrecipe_id NUMBER) IS
1866: SELECT owner_organization_id
1867: FROM gmd_recipes_b

Line 2191: UPDATE fm_form_mst_b

2187: FETCH Get_FmRout_id INTO l_formula_id, l_routing_id;
2188: CLOSE Get_FmRout_id;
2189:
2190: /* Update the formula and routing status */
2191: UPDATE fm_form_mst_b
2192: SET formula_status = '900'
2193: WHERE formula_id = l_formula_id
2194: AND to_number(formula_status) < 800;
2195:

Line 2888: UPDATE fm_form_mst_b

2884: /* Finally update the formula level product qty as prod qty + by product qty. */
2885: lhdrqty := lhdrqty + l_prod_fix_qty + NVL (l_by_product_qty, 0);
2886:
2887: -- Update formula Header also
2888: UPDATE fm_form_mst_b
2889: SET total_output_qty = lhdrqty
2890: WHERE formula_id = p_formula_id;
2891: /* Get the message count from the Message stack */
2892: END IF;

Line 3027: UPDATE fm_form_mst_b

3023: FETCH Get_FmRout_id INTO l_formula_id, l_routing_id;
3024: CLOSE Get_FmRout_id;
3025:
3026: /* Update the formula and routing status */
3027: UPDATE fm_form_mst_b
3028: SET formula_status = '900'
3029: WHERE formula_id = l_formula_id
3030: AND to_number(formula_status) < 800;
3031: