APPS.GMD_COMMON_VAL dependencies on FM_MATL_DTL

Line 999: FROM fm_matl_dtl

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

Line 1014: FROM fm_matl_dtl

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

Line 2653: FROM fm_matl_dtl

2649: CURSOR get_formula_lines (vformula_id NUMBER) IS
2650: SELECT line_no, line_type, inventory_item_id, qty, DETAIL_UOM, scale_type,
2651: contribute_yield_ind, scale_multiple, scale_rounding_variance,
2652: rounding_direction , prod_percent
2653: FROM fm_matl_dtl
2654: WHERE formula_id = p_formula_id
2655: AND contribute_yield_ind = 'Y' /* Added in Bug No.6314028 */
2656: ORDER BY line_type;
2657:

Line 2875: UPDATE fm_matl_dtl

2871: ELSE
2872: l_temp_qty := l_one_prodqty;
2873: END IF;
2874:
2875: UPDATE fm_matl_dtl
2876: SET qty = ROUND (l_temp_qty, 5),
2877: DETAIL_UOM = temp_prod_tbl1 (i).orig_uom
2878: WHERE formula_id = p_formula_id
2879: AND line_type = 1