DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 604: from mtl_units_of_measure muom

600: Begin
601:
602: select muom.unit_of_measure_tl
603: into l_unit_of_measure
604: from mtl_units_of_measure muom
605: where sysdate < nvl(muom.disable_date,sysdate+1)
606: and muom.uom_code = p_uom_code;
607:
608: Return l_unit_of_measure ;

Line 1768: from MTL_UNITS_OF_MEASURE muom

1764: IF g_uom_class_tbl.EXISTS(l_hash_value) THEN
1765: l_uom_class :=g_uom_class_tbl(l_hash_value);
1766: ELSE
1767: select muom.uom_class into l_uom_class
1768: from MTL_UNITS_OF_MEASURE muom
1769: where muom.uom_code = p_uom_code;
1770: g_uom_class_tbl(l_hash_value) := l_uom_class;
1771: END IF;
1772: -- 8809951 end