View: BIL_DIMV_UOM

Product:	BIL - Sales Intelligence
Description:	Units of measure view
Implementation/DBA Data:	APPS.BIL_DIMV_UOM

View Text

SELECT UN.UNIT_OF_MEASURE
, UN.UOM_CODE
, UN.UOM_CLASS
, UN.DISABLE_DATE
, UN.DESCRIPTION
, UN.BASE_UOM_FLAG
, UN.UOM_CODE
, UN.UNIT_OF_MEASURE
FROM MTL_UNITS_OF_MEASURE_TL UN
WHERE LANGUAGE = USERENV('LANG') UNION (SELECT SUBSTR(FL.MEANING
, 1
, 25) UNIT_OF_MEASURE
, FL.LOOKUP_CODE UOM_CODE
, SUBSTR(FL.MEANING
, 1
, 10) UOM_CLASS
, FL.END_DATE_ACTIVE DISABLE_DATE
, FL.DESCRIPTION UOM_DESCRIPTION
, 'N' BASE_UOM_FLAG
, FL.LOOKUP_CODE ID
, SUBSTR(FL.MEANING
, 1
, 25) VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns