View: MTL_ITEM_UOMS_VIEW

Product:	INV - Inventory
Description:	Holds valid UOMs for items, considering the conversions that are defined
Implementation/DBA Data:	APPS.MTL_ITEM_UOMS_VIEW

View Text

SELECT DISTINCT MTLITM1.ORGANIZATION_ID
, MTLITM1.INVENTORY_ITEM_ID
, MTLITM1.ALLOWED_UNITS_LOOKUP_CODE
, MTLUOM2.UOM_CODE
, MTLUOM2.UNIT_OF_MEASURE
, MTLUOM2.UNIT_OF_MEASURE_TL
, MTLUOM2.DESCRIPTION
, MTLUOM2.UOM_CLASS
FROM MTL_SYSTEM_ITEMS_B MTLITM1
, MTL_UNITS_OF_MEASURE_VL MTLUOM2
, MTL_UOM_CONVERSIONS MTLUCV
WHERE ( ( MTLITM1.ALLOWED_UNITS_LOOKUP_CODE IN (1
, 3)
AND MTLUCV.INVENTORY_ITEM_ID = MTLITM1.INVENTORY_ITEM_ID OR ( MTLUCV.INVENTORY_ITEM_ID = 0
AND MTLUOM2.BASE_UOM_FLAG = 'Y'
AND MTLUOM2.UOM_CLASS = MTLUCV.UOM_CLASS
AND MTLUCV.UOM_CLASS IN ( SELECT MTLPRI1.UOM_CLASS
FROM MTL_UNITS_OF_MEASURE MTLPRI1
WHERE MTLPRI1.UOM_CODE = MTLITM1.PRIMARY_UOM_CODE)) OR (MTLUCV.INVENTORY_ITEM_ID = 0
AND MTLUCV.UOM_CODE IN (SELECT MTLUCC1.TO_UOM_CODE
FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC1
WHERE MTLUCC1.INVENTORY_ITEM_ID = MTLITM1.INVENTORY_ITEM_ID
AND NVL(MTLUCC1.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) ))) OR ( MTLITM1.ALLOWED_UNITS_LOOKUP_CODE IN (2
, 3)
AND MTLUCV.INVENTORY_ITEM_ID = 0
AND ( MTLUCV.UOM_CLASS IN (SELECT MTLUCC.TO_UOM_CLASS
FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC
WHERE MTLUCC.INVENTORY_ITEM_ID = MTLITM1.INVENTORY_ITEM_ID
AND NVL(MTLUCC.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) ) OR MTLUCV.UOM_CLASS = (SELECT MTLPRI.UOM_CLASS
FROM MTL_UNITS_OF_MEASURE MTLPRI
WHERE MTLPRI.UOM_CODE = MTLITM1.PRIMARY_UOM_CODE) ) ) )
AND NVL( MTLUCV.DISABLE_DATE
, TRUNC(SYSDATE)+1 ) > TRUNC(SYSDATE)
AND NVL( MTLUOM2.DISABLE_DATE
, TRUNC(SYSDATE)+1 ) > TRUNC(SYSDATE)
AND MTLUOM2.UOM_CODE = MTLUCV.UOM_CODE

Columns