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_SR_UOM_CONVERSIONS_V

Source

View Text - Preformatted


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, muc.conversion_rate CONVERSION_RATE, 'N' base_uom_flag, muc.inventory_item_id SR_ITEM_PK, MSD_SR_UTIL.item(muc.inventory_item_id, null) ITEM FROM mtl_uom_conversions muc, mtl_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 /* To take into account inventory_item_id=0 */ union SELECT /**** The Item Independent conversion for the same Code ****/ muom.uom_class FROM_UOM_CLASS, muom.uom_class TO_UOM_CLASS, muom.uom_code FROM_UOM_CODE, muc.uom_code TO_UOM_CODE, muc.conversion_rate CONVERSION_RATE, muom.base_uom_flag, 0 SR_ITEM_PK, null ITEM from mtl_uom_conversions muc, mtl_units_of_measure muom WHERE muom.base_uom_flag = 'Y' AND muc.uom_code <> muom.uom_code /*zia: changed = to <> - same code conv doesn't make sense*/ AND muc.uom_class = muom.uom_class AND muc.inventory_item_id = 0 /* For Item based UOM Conversion across the classes */ union SELECT distinct from_uom_class FROM_UOM_CLASS, to_uom_class TO_UOM_CLASS, from_uom_code FROM_UOM_CODE, to_uom_code TO_UOM_CODE, conversion_rate CONVERSION_RATE, 'Y' base_uom_flag, mucc.inventory_item_id SR_ITEM_PK, MSD_SR_UTIL.item(mucc.inventory_item_id, null) ITEM from mtl_uom_class_conversions mucc WHERE mucc.from_uom_code <> mucc.to_uom_code AND mucc.from_uom_class <> mucc.to_uom_class AND mucc.inventory_item_id != 0 /* We do not take into account item_id = 0*/

View Text - HTML Formatted

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
, MUC.CONVERSION_RATE CONVERSION_RATE
, 'N' BASE_UOM_FLAG
, MUC.INVENTORY_ITEM_ID SR_ITEM_PK
, MSD_SR_UTIL.ITEM(MUC.INVENTORY_ITEM_ID
, NULL) ITEM
FROM MTL_UOM_CONVERSIONS MUC
, MTL_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 /* TO TAKE INTO ACCOUNT INVENTORY_ITEM_ID=0 */ UNION SELECT /**** THE ITEM INDEPENDENT CONVERSION FOR THE SAME CODE ****/ MUOM.UOM_CLASS FROM_UOM_CLASS
, MUOM.UOM_CLASS TO_UOM_CLASS
, MUOM.UOM_CODE FROM_UOM_CODE
, MUC.UOM_CODE TO_UOM_CODE
, MUC.CONVERSION_RATE CONVERSION_RATE
, MUOM.BASE_UOM_FLAG
, 0 SR_ITEM_PK
, NULL ITEM
FROM MTL_UOM_CONVERSIONS MUC
, MTL_UNITS_OF_MEASURE MUOM
WHERE MUOM.BASE_UOM_FLAG = 'Y'
AND MUC.UOM_CODE <> MUOM.UOM_CODE /*ZIA: CHANGED = TO <> - SAME CODE CONV DOESN'T MAKE SENSE*/
AND MUC.UOM_CLASS = MUOM.UOM_CLASS
AND MUC.INVENTORY_ITEM_ID = 0 /* FOR ITEM BASED UOM CONVERSION ACROSS THE CLASSES */ UNION SELECT DISTINCT FROM_UOM_CLASS FROM_UOM_CLASS
, TO_UOM_CLASS TO_UOM_CLASS
, FROM_UOM_CODE FROM_UOM_CODE
, TO_UOM_CODE TO_UOM_CODE
, CONVERSION_RATE CONVERSION_RATE
, 'Y' BASE_UOM_FLAG
, MUCC.INVENTORY_ITEM_ID SR_ITEM_PK
, MSD_SR_UTIL.ITEM(MUCC.INVENTORY_ITEM_ID
, NULL) ITEM
FROM MTL_UOM_CLASS_CONVERSIONS MUCC
WHERE MUCC.FROM_UOM_CODE <> MUCC.TO_UOM_CODE
AND MUCC.FROM_UOM_CLASS <> MUCC.TO_UOM_CLASS
AND MUCC.INVENTORY_ITEM_ID != 0 /* WE DO NOT TAKE INTO ACCOUNT ITEM_ID = 0*/