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.MTL_ITEM_UOMS_VIEW

Source

View Text - Preformatted


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

View Text - HTML Formatted

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