VIEW: APPS.MSC_ITEM_UOMS_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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