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 1023: FROM fm_form_mst_b

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

Line 1204: from fm_form_mst_b form,

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

Line 1805: FROM fm_form_mst_b

1801: Status_cur Status_ref_cur;
1802:
1803: CURSOR get_formula_owner_orgn_id(vformula_id NUMBER) IS
1804: SELECT owner_organization_id
1805: FROM fm_form_mst_b
1806: WHERE formula_id = vformula_id;
1807: CURSOR get_recipe_owner_orgn_id(vrecipe_id NUMBER) IS
1808: SELECT owner_organization_id
1809: FROM gmd_recipes_b

Line 2133: UPDATE fm_form_mst_b

2129: FETCH Get_FmRout_id INTO l_formula_id, l_routing_id;
2130: CLOSE Get_FmRout_id;
2131:
2132: /* Update the formula and routing status */
2133: UPDATE fm_form_mst_b
2134: SET formula_status = '900'
2135: WHERE formula_id = l_formula_id
2136: AND to_number(formula_status) < 800;
2137:

Line 2814: UPDATE fm_form_mst_b

2810: /* Finally update the formula level product qty as prod qty + by product qty. */
2811: lhdrqty := lhdrqty + l_prod_fix_qty + NVL (l_by_product_qty, 0);
2812:
2813: -- Update formula Header also
2814: UPDATE fm_form_mst_b
2815: SET total_output_qty = lhdrqty
2816: WHERE formula_id = p_formula_id;
2817: /* Get the message count from the Message stack */
2818: END IF;