DBA Data[Home] [Help]

APPS.INV_3PL_SEEDED_SOURCES dependencies on MTL_UNITS_OF_MEASURE

Line 22: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%type := NULL;

18: END debug;
19:
20:
21: FUNCTION get_item_uom_code (p_uom_name VARCHAR2) RETURN VARCHAR2 IS
22: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%type := NULL;
23:
24: BEGIN
25:
26: SELECT uom_code

Line 28: FROM mtl_units_of_measure_vl

24: BEGIN
25:
26: SELECT uom_code
27: INTO l_uom_code
28: FROM mtl_units_of_measure_vl
29: WHERE unit_of_measure = p_uom_name;
30:
31: RETURN (l_uom_code);
32: