View: OKX_ITEM_UOMS_V

Product:	OKX - Contracts Integration
Description:	Item unit of measure codes
Implementation/DBA Data:	APPS.OKX_ITEM_UOMS_V

View Text

SELECT MTLITM1.ORGANIZATION_ID ORGANIZATION_ID
, MTLITM1.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTLITM1.ALLOWED_UNITS_LOOKUP_CODE UOM_TYPE
, MTLUOM2.UOM_CODE UOM_CODE
, MTLUOM2.UNIT_OF_MEASURE UNIT_OF_MEASURE
, MTLUOM2.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE_TL
, MTLUOM2.UOM_CLASS UOM_CLASS
, MTLUOM2.DESCRIPTION DESCRIPTION
FROM MTL_SYSTEM_ITEMS_B MTLITM1
, MTL_UNITS_OF_MEASURE_TL 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 MTLUOM2.UOM_CODE = MTLUCV.UOM_CODE
AND MTLUOM2.LANGUAGE = USERENV('LANG')

Columns