APPS.GMD_COMMON_VAL dependencies on MTL_UNITS_OF_MEASURE

Line 988: l_um_type mtl_units_of_measure.uom_class%TYPE;

984: p_primaries IN VARCHAR2
985: ) IS
986:
987: l_temp_qty NUMBER := 0;
988: l_um_type mtl_units_of_measure.uom_class%TYPE;
989: /*Bug 5667857 - Change the column from unit_of_measure to uom_code */
990: CURSOR get_sy_std_um(pUm_type mtl_units_of_measure.uom_class%TYPE) IS
991: SELECT uom_code
992: FROM mtl_units_of_measure

Line 990: CURSOR get_sy_std_um(pUm_type mtl_units_of_measure.uom_class%TYPE) IS

986:
987: l_temp_qty NUMBER := 0;
988: l_um_type mtl_units_of_measure.uom_class%TYPE;
989: /*Bug 5667857 - Change the column from unit_of_measure to uom_code */
990: CURSOR get_sy_std_um(pUm_type mtl_units_of_measure.uom_class%TYPE) IS
991: SELECT uom_code
992: FROM mtl_units_of_measure
993: WHERE uom_class = pUm_type
994: AND base_uom_flag = 'Y';

Line 992: FROM mtl_units_of_measure

988: l_um_type mtl_units_of_measure.uom_class%TYPE;
989: /*Bug 5667857 - Change the column from unit_of_measure to uom_code */
990: CURSOR get_sy_std_um(pUm_type mtl_units_of_measure.uom_class%TYPE) IS
991: SELECT uom_code
992: FROM mtl_units_of_measure
993: WHERE uom_class = pUm_type
994: AND base_uom_flag = 'Y';
995:
996: CURSOR prod_um_cur(vFormula_id NUMBER) IS

Line 1214: l_uom mtl_units_of_measure.unit_of_measure%TYPE;

1210: l_routing_id NUMBER;
1211: l_calculate_step_qty NUMBER(5);
1212: l_product_qty NUMBER;
1213: l_ingredient_qty NUMBER;
1214: l_uom mtl_units_of_measure.unit_of_measure%TYPE;
1215: l_return_status VARCHAR2(1);
1216: l_msg_count NUMBER;
1217: l_msg_data VARCHAR2(2000);
1218: BEGIN

Line 2601: FROM mtl_units_of_measure

2597: ORDER BY line_type;
2598:
2599: CURSOR get_unit_of_measure(v_yield_type VARCHAR2) IS
2600: SELECT unit_of_measure
2601: FROM mtl_units_of_measure
2602: WHERE uom_class = v_yield_type
2603: AND base_uom_flag = 'Y';
2604:
2605: BEGIN

Line 2664: FROM mtl_units_of_measure

2660: IF l_material_tab(i).detail_uom IS NOT NULL THEN
2661: /* Get the common UOM class of the detail lines UOM */
2662: SELECT uom_class
2663: INTO l_uom_class
2664: FROM mtl_units_of_measure
2665: where uom_code = l_material_tab (i).detail_uom;
2666:
2667: /* If different UOM - get the yield type UOM for conversions. */
2668: IF NVL(l_common_uom_class,l_uom_class) <> l_uom_class THEN