View: MSC_ITEM_UOMS_VIEW

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_ITEM_UOMS_VIEW

View Text

SELECT DISTINCT MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID
, MSI.INVENTORY_ITEM_ID
, MUOM.UOM_CODE
, MUOM.UNIT_OF_MEASURE
, MUOM.DESCRIPTION
, MUOM.UOM_CLASS
FROM MSC_SYSTEM_ITEMS MSI
, MSC_UNITS_OF_MEASURE MUOM
, MSC_UOM_CONVERSIONS MUCV
WHERE ( ( MUCV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID OR ( MUCV.INVENTORY_ITEM_ID = 0
AND MUOM.BASE_UOM_FLAG = 'Y'
AND MUOM.UOM_CLASS = MUCV.UOM_CLASS
AND MUCV.UOM_CLASS IN ( SELECT MPRI1.UOM_CLASS
FROM MSC_UNITS_OF_MEASURE MPRI1
WHERE MPRI1.UOM_CODE = MSI.UOM_CODE)) OR (MUCV.INVENTORY_ITEM_ID = 0
AND MUCV.UOM_CODE IN (SELECT MUCC1.TO_UOM_CODE
FROM MSC_UOM_CLASS_CONVERSIONS MUCC1
WHERE MUCC1.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(MUCC1.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) ))) OR ( MUCV.INVENTORY_ITEM_ID = 0
AND ( MUCV.UOM_CLASS IN (SELECT MUCC.TO_UOM_CLASS
FROM MSC_UOM_CLASS_CONVERSIONS MUCC
WHERE MUCC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND NVL(MUCC.DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) ) OR MUCV.UOM_CLASS = (SELECT MPRI.UOM_CLASS
FROM MSC_UNITS_OF_MEASURE MPRI
WHERE MPRI.UOM_CODE = MSI.UOM_CODE) ) ) )
AND NVL( MUCV.DISABLE_DATE
, TRUNC(SYSDATE)+1 ) > TRUNC(SYSDATE)
AND MUOM.UOM_CODE = MUCV.UOM_CODE
AND MSI.PLAN_ID = -1

Columns