VIEW: APPS.INL_ALLOCATION_BASIS_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'