APPS.GMD_COMMON_VAL dependencies on MTL_UNITS_OF_MEASURE

Line 989: l_um_type mtl_units_of_measure.uom_class%TYPE;

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

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

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

Line 993: FROM mtl_units_of_measure

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

Line 1215: l_uom mtl_units_of_measure.unit_of_measure%TYPE;

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

Line 2660: FROM mtl_units_of_measure

2656: ORDER BY line_type;
2657:
2658: CURSOR get_unit_of_measure(v_yield_type VARCHAR2) IS
2659: SELECT uom_code
2660: FROM mtl_units_of_measure
2661: WHERE uom_class = v_yield_type
2662: AND base_uom_flag = 'Y';
2663:
2664: BEGIN

Line 2734: FROM mtl_units_of_measure

2730: -- IF l_material_tab(i).detail_uom IS NOT NULL THEN
2731: /* Get the common UOM class of the detail lines UOM */
2732: /* SELECT uom_class
2733: INTO l_uom_class
2734: FROM mtl_units_of_measure
2735: where uom_code = l_material_tab (i).detail_uom; */
2736:
2737: /* If different UOM - get the yield type UOM for conversions. */
2738: /* IF NVL(l_common_uom_class,l_uom_class) <> l_uom_class THEN