DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 5418: -- (we query against MTL_UNITS_OF_MEASURE_TL because there is no _B table) --

5414: Debug_Msg('In Is_UOM_Valid, starting', 2);
5415:
5416: ------------------------------------------------------------------------------
5417: -- If there is a UOM, we see whether it's a member of the correct UOM class --
5418: -- (we query against MTL_UNITS_OF_MEASURE_TL because there is no _B table) --
5419: ------------------------------------------------------------------------------
5420: IF (px_attr_value_obj.ATTR_UNIT_OF_MEASURE IS NOT NULL) THEN
5421:
5422: BEGIN

Line 5425: FROM MTL_UNITS_OF_MEASURE_TL

5421:
5422: BEGIN
5423: SELECT 'X'
5424: INTO l_dummy
5425: FROM MTL_UNITS_OF_MEASURE_TL
5426: WHERE UOM_CLASS = p_attr_metadata_obj.UNIT_OF_MEASURE_CLASS
5427: AND UOM_CODE = px_attr_value_obj.ATTR_UNIT_OF_MEASURE
5428: AND ROWNUM = 1;
5429: EXCEPTION