APPS.GMD_COMMON_VAL dependencies on FM_FORM_MST

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 1732: FROM fm_form_mst

1728: END IF;
1729: IF (Entity = 'FORMULA') THEN
1730: SELECT delete_mark, formula_status
1731: INTO l_delete_mark, l_status_code
1732: FROM fm_form_mst
1733: WHERE formula_id = Entity_id;
1734: ELSIF (Entity = 'RECIPE') THEN
1735:
1736: SELECT delete_mark, recipe_status, owner_organization_id

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 1838: From fm_form_mst f, gmd_status s

1834: FETCH get_formula_owner_orgn_id INTO l_orgn_id;
1835: CLOSE get_formula_owner_orgn_id;
1836: OPEN Status_cur FOR
1837: Select f.formula_status, s.version_enabled
1838: From fm_form_mst f, gmd_status s
1839: Where f.formula_id = Entity_id
1840: And f.formula_status = s.status_code;
1841: FETCH Status_cur INTO l_status, l_version_enabled;
1842: ClOSE Status_cur;

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 2222: FROM fm_form_mst fm, mtl_parameters o

2218: --RLNAGARA start Bug 6982623 Added validation for formula item access
2219:
2220: CURSOR Cur_formula_own (p_formula_id NUMBER, p_inventory_item_id NUMBER) IS
2221: SELECT fm.formula_no, fm.formula_vers, organization_code
2222: FROM fm_form_mst fm, mtl_parameters o
2223: WHERE formula_id =p_formula_id
2224: AND fm.owner_organization_id = o.organization_id
2225: AND formula_status < 1000
2226: AND NOT EXISTS (SELECT 1

Line 2234: FROM fm_form_mst fm, mtl_parameters o

2230: AND m.organization_id = fm.owner_organization_id);
2231:
2232: CURSOR Cur_formula_own_revision (p_formula_id NUMBER, p_inventory_item_id NUMBER,p_revision VARCHAR2) IS
2233: SELECT fm.formula_no, fm.formula_vers, organization_code
2234: FROM fm_form_mst fm, mtl_parameters o
2235: WHERE formula_id =p_formula_id
2236: AND fm.owner_organization_id = o.organization_id
2237: AND formula_status < 1000
2238: AND NOT EXISTS (SELECT 1

Line 2587: FROM FM_FORM_MST

2583: -- Cursor Definitions
2584:
2585: CURSOR Cur_get_formula_org IS
2586: SELECT OWNER_ORGANIZATION_ID
2587: FROM FM_FORM_MST
2588: WHERE formula_id = p_formula_id;
2589:
2590: CURSOR get_formula_lines (vformula_id NUMBER) IS
2591: SELECT line_no, line_type, inventory_item_id, qty, DETAIL_UOM, scale_type,

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;