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

Source

View Text - Preformatted


SELECT DISTINCT mucc.from_uom_class, mucc.to_uom_class, mucc.from_uom_code, mucc.to_uom_code, 'Y' base_uom_flag, mucc.conversion_rate, mlvb.level_pk item_id FROM msc_uom_class_conversions mucc, msd_level_values_lb mlvb WHERE mucc.from_uom_code <> mucc.to_uom_code AND mucc.from_uom_class <> mucc.to_uom_class AND mucc.inventory_item_id != 0 AND mlvb.level_id = 1 AND mlvb.plan_id = -1 AND mlvb.sr_level_pk = mucc.inventory_item_id UNION SELECT DISTINCT muom.uom_class FROM_UOM_CLASS, muom.uom_class TO_UOM_CLASS, muom.uom_code FROM_UOM_CODE, muc.uom_code TO_UOM_CODE, 'N' base_uom_flag, muc.conversion_rate CONVERSION_RATE, mlvb.level_pk item_id FROM msc_uom_conversions muc, msc_units_of_measure muom, msd_level_values_lb mlvb WHERE muom.base_uom_flag = 'Y' AND muc.uom_code <> muom.uom_code AND muc.uom_class = muom.uom_class AND muc.inventory_item_id != 0 AND muc.inventory_item_id = mlvb.sr_level_pk AND mlvb.level_id = 1 AND mlvb.plan_id = -1 UNION SELECT muom.uom_class FROM_UOM_CLASS, muom.uom_class TO_UOM_CLASS, muom.uom_code FROM_UOM_CODE, muc.uom_code TO_UOM_CODE, muom.base_uom_flag, muc.conversion_rate, to_number(null) FROM msc_uom_conversions muc, msc_units_of_measure muom WHERE muom.base_uom_flag = 'Y' AND muc.uom_code <> muom.uom_code AND muc.uom_class = muom.uom_class AND muc.inventory_item_id = 0 UNION /* Reverse */ SELECT DISTINCT mucc.to_uom_class, mucc.from_uom_class, mucc.to_uom_code, mucc.from_uom_code, 'Y' base_uom_flag, 1/mucc.conversion_rate, mlvb.level_pk item_id FROM msc_uom_class_conversions mucc, msd_level_values_lb mlvb WHERE mucc.from_uom_code <> mucc.to_uom_code AND mucc.from_uom_class <> mucc.to_uom_class AND mucc.inventory_item_id != 0 AND mlvb.level_id = 1 AND mlvb.plan_id = -1 AND mlvb.sr_level_pk = mucc.inventory_item_id UNION SELECT DISTINCT muom.uom_class TO_UOM_CLASS, muom.uom_class FROM_UOM_CLASS, muc.uom_code TO_UOM_CODE, muom.uom_code FROM_UOM_CODE, 'N' base_uom_flag, 1/muc.conversion_rate CONVERSION_RATE, mlvb.level_pk item_id FROM msc_uom_conversions muc, msc_units_of_measure muom, msd_level_values_lb mlvb WHERE muom.base_uom_flag = 'Y' AND muc.uom_code <> muom.uom_code AND muc.uom_class = muom.uom_class AND muc.inventory_item_id != 0 AND muc.inventory_item_id = mlvb.sr_level_pk AND mlvb.level_id = 1 AND mlvb.plan_id = -1 UNION SELECT muom.uom_class TO_UOM_CLASS, muom.uom_class FROM_UOM_CLASS, muc.uom_code TO_UOM_CODE, muom.uom_code FROM_UOM_CODE, muom.base_uom_flag, 1/muc.conversion_rate, to_number(null) FROM msc_uom_conversions muc, msc_units_of_measure muom WHERE muom.base_uom_flag = 'Y' AND muc.uom_code <> muom.uom_code AND muc.uom_class = muom.uom_class AND muc.inventory_item_id = 0

View Text - HTML Formatted

SELECT DISTINCT MUCC.FROM_UOM_CLASS
, MUCC.TO_UOM_CLASS
, MUCC.FROM_UOM_CODE
, MUCC.TO_UOM_CODE
, 'Y' BASE_UOM_FLAG
, MUCC.CONVERSION_RATE
, MLVB.LEVEL_PK ITEM_ID
FROM MSC_UOM_CLASS_CONVERSIONS MUCC
, MSD_LEVEL_VALUES_LB MLVB
WHERE MUCC.FROM_UOM_CODE <> MUCC.TO_UOM_CODE
AND MUCC.FROM_UOM_CLASS <> MUCC.TO_UOM_CLASS
AND MUCC.INVENTORY_ITEM_ID != 0
AND MLVB.LEVEL_ID = 1
AND MLVB.PLAN_ID = -1
AND MLVB.SR_LEVEL_PK = MUCC.INVENTORY_ITEM_ID UNION SELECT DISTINCT MUOM.UOM_CLASS FROM_UOM_CLASS
, MUOM.UOM_CLASS TO_UOM_CLASS
, MUOM.UOM_CODE FROM_UOM_CODE
, MUC.UOM_CODE TO_UOM_CODE
, 'N' BASE_UOM_FLAG
, MUC.CONVERSION_RATE CONVERSION_RATE
, MLVB.LEVEL_PK ITEM_ID
FROM MSC_UOM_CONVERSIONS MUC
, MSC_UNITS_OF_MEASURE MUOM
, MSD_LEVEL_VALUES_LB MLVB
WHERE MUOM.BASE_UOM_FLAG = 'Y'
AND MUC.UOM_CODE <> MUOM.UOM_CODE
AND MUC.UOM_CLASS = MUOM.UOM_CLASS
AND MUC.INVENTORY_ITEM_ID != 0
AND MUC.INVENTORY_ITEM_ID = MLVB.SR_LEVEL_PK
AND MLVB.LEVEL_ID = 1
AND MLVB.PLAN_ID = -1 UNION SELECT MUOM.UOM_CLASS FROM_UOM_CLASS
, MUOM.UOM_CLASS TO_UOM_CLASS
, MUOM.UOM_CODE FROM_UOM_CODE
, MUC.UOM_CODE TO_UOM_CODE
, MUOM.BASE_UOM_FLAG
, MUC.CONVERSION_RATE
, TO_NUMBER(NULL)
FROM MSC_UOM_CONVERSIONS MUC
, MSC_UNITS_OF_MEASURE MUOM
WHERE MUOM.BASE_UOM_FLAG = 'Y'
AND MUC.UOM_CODE <> MUOM.UOM_CODE
AND MUC.UOM_CLASS = MUOM.UOM_CLASS
AND MUC.INVENTORY_ITEM_ID = 0 UNION /* REVERSE */ SELECT DISTINCT MUCC.TO_UOM_CLASS
, MUCC.FROM_UOM_CLASS
, MUCC.TO_UOM_CODE
, MUCC.FROM_UOM_CODE
, 'Y' BASE_UOM_FLAG
, 1/MUCC.CONVERSION_RATE
, MLVB.LEVEL_PK ITEM_ID
FROM MSC_UOM_CLASS_CONVERSIONS MUCC
, MSD_LEVEL_VALUES_LB MLVB
WHERE MUCC.FROM_UOM_CODE <> MUCC.TO_UOM_CODE
AND MUCC.FROM_UOM_CLASS <> MUCC.TO_UOM_CLASS
AND MUCC.INVENTORY_ITEM_ID != 0
AND MLVB.LEVEL_ID = 1
AND MLVB.PLAN_ID = -1
AND MLVB.SR_LEVEL_PK = MUCC.INVENTORY_ITEM_ID UNION SELECT DISTINCT MUOM.UOM_CLASS TO_UOM_CLASS
, MUOM.UOM_CLASS FROM_UOM_CLASS
, MUC.UOM_CODE TO_UOM_CODE
, MUOM.UOM_CODE FROM_UOM_CODE
, 'N' BASE_UOM_FLAG
, 1/MUC.CONVERSION_RATE CONVERSION_RATE
, MLVB.LEVEL_PK ITEM_ID
FROM MSC_UOM_CONVERSIONS MUC
, MSC_UNITS_OF_MEASURE MUOM
, MSD_LEVEL_VALUES_LB MLVB
WHERE MUOM.BASE_UOM_FLAG = 'Y'
AND MUC.UOM_CODE <> MUOM.UOM_CODE
AND MUC.UOM_CLASS = MUOM.UOM_CLASS
AND MUC.INVENTORY_ITEM_ID != 0
AND MUC.INVENTORY_ITEM_ID = MLVB.SR_LEVEL_PK
AND MLVB.LEVEL_ID = 1
AND MLVB.PLAN_ID = -1 UNION SELECT MUOM.UOM_CLASS TO_UOM_CLASS
, MUOM.UOM_CLASS FROM_UOM_CLASS
, MUC.UOM_CODE TO_UOM_CODE
, MUOM.UOM_CODE FROM_UOM_CODE
, MUOM.BASE_UOM_FLAG
, 1/MUC.CONVERSION_RATE
, TO_NUMBER(NULL)
FROM MSC_UOM_CONVERSIONS MUC
, MSC_UNITS_OF_MEASURE MUOM
WHERE MUOM.BASE_UOM_FLAG = 'Y'
AND MUC.UOM_CODE <> MUOM.UOM_CODE
AND MUC.UOM_CLASS = MUOM.UOM_CLASS
AND MUC.INVENTORY_ITEM_ID = 0