View: INL_ALLOCATION_BASIS_VL

Product:	INL - Oracle Landed Cost Management
Description:	This view shows Allocation Basis information in a given language.
Implementation/DBA Data:	APPS.INL_ALLOCATION_BASIS_VL

View Text

SELECT -1 ALLOCATION_BASIS_ID
, LV.LOOKUP_CODE ALLOCATION_BASIS_CODE
, LV.MEANING ALLOCATION_BASIS_NAME
, UM.UOM_CLASS UOM_CLASS
, UM.UOM_CODE BASE_UOM_CODE
FROM MTL_UNITS_OF_MEASURE UM
, FND_LOOKUP_VALUES_VL LV
WHERE UM.UOM_CLASS (+) = DECODE(LV.LOOKUP_CODE
, 'QUANTITY'
, FND_PROFILE.VALUE('INL_QUANTITY_UOM_CLASS')
, 'VOLUME'
, FND_PROFILE.VALUE('INL_VOLUME_UOM_CLASS')
, 'WEIGHT'
, FND_PROFILE.VALUE('INL_WEIGHT_UOM_CLASS'))
AND UM.BASE_UOM_FLAG (+) = 'Y'
AND LV.LOOKUP_TYPE = 'PON_PE_ALLOCATION_BASIS'

Columns