APPS.GMD_COMMON_VAL dependencies on FM_MATL_DTL

Line 998: FROM fm_matl_dtl

994: AND base_uom_flag = 'Y';
995:
996: CURSOR prod_um_cur(vFormula_id NUMBER) IS
997: SELECT detail_uom
998: FROM fm_matl_dtl
999: WHERE line_no = 1
1000: AND line_type = 1
1001: AND formula_id = vFormula_id;
1002:

Line 1013: FROM fm_matl_dtl

1009: CURSOR Get_formula_lines (vFormula_id NUMBER) IS
1010: SELECT line_no, line_type, inventory_item_id, qty, detail_uom, scale_type,
1011: contribute_yield_ind, scale_multiple, scale_rounding_variance,
1012: rounding_direction
1013: FROM fm_matl_dtl
1014: WHERE formula_id = vFormula_id
1015: ORDER BY line_type;
1016:
1017: -- NPD Conv.

Line 2546: l_uom fm_matl_dtl.item_um%TYPE;

2542: -- Definition of variables
2543: l_auto_calc VARCHAR2(1) := 'N';
2544: l_count NUMBER (5) DEFAULT 0;
2545: l_material_tab gmd_common_scale.scale_tab;
2546: l_uom fm_matl_dtl.item_um%TYPE;
2547: l_conv_uom VARCHAR2(30);
2548: l_temp_qty NUMBER := 0;
2549:
2550: l_ingredient_qty NUMBER := 0;

Line 2594: FROM fm_matl_dtl

2590: CURSOR get_formula_lines (vformula_id NUMBER) IS
2591: SELECT line_no, line_type, inventory_item_id, qty, DETAIL_UOM, scale_type,
2592: contribute_yield_ind, scale_multiple, scale_rounding_variance,
2593: rounding_direction , prod_percent
2594: FROM fm_matl_dtl
2595: WHERE formula_id = p_formula_id
2596: AND contribute_yield_ind = 'Y' /* Added in Bug No.6314028 */
2597: ORDER BY line_type;
2598:

Line 2801: UPDATE fm_matl_dtl

2797: ELSE
2798: l_temp_qty := l_one_prodqty;
2799: END IF;
2800:
2801: UPDATE fm_matl_dtl
2802: SET qty = ROUND (l_temp_qty, 5),
2803: DETAIL_UOM = temp_prod_tbl1 (i).orig_uom
2804: WHERE formula_id = p_formula_id
2805: AND line_type = 1