eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKX_ITEM_UOMS_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')