DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on MTL_UNITS_OF_MEASURE_TL

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

4928: Debug_Msg('In Is_UOM_Valid, starting', 2);
4929:
4930: ------------------------------------------------------------------------------
4931: -- If there is a UOM, we see whether it's a member of the correct UOM class --
4932: -- (we query against MTL_UNITS_OF_MEASURE_TL because there is no _B table) --
4933: ------------------------------------------------------------------------------
4934: IF (px_attr_value_obj.ATTR_UNIT_OF_MEASURE IS NOT NULL) THEN
4935:
4936: BEGIN

Line 4939: FROM MTL_UNITS_OF_MEASURE_TL

4935:
4936: BEGIN
4937: SELECT 'X'
4938: INTO l_dummy
4939: FROM MTL_UNITS_OF_MEASURE_TL
4940: WHERE UOM_CLASS = p_attr_metadata_obj.UNIT_OF_MEASURE_CLASS
4941: AND UOM_CODE = px_attr_value_obj.ATTR_UNIT_OF_MEASURE
4942: AND ROWNUM = 1;
4943: EXCEPTION