VIEW: APPS.QPR_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, null ITEM , muom.description FROM mtl_uom_conversions muc, mtl_units_of_measure_vl 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 ALL /* The Item Independent conversion(inventory_item_id=0) for the same Code */ 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, muc.conversion_rate CONVERSION_RATE, muom.base_uom_flag BASE_UOM_FLAG, 0 SR_ITEM_PK, null ITEM , muom.description FROM mtl_uom_conversions muc, mtl_units_of_measure_vl 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 ALL /* For Item based UOM Conversion across the classes */ /* We do not take into account item_id = 0*/ 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, null ITEM , muom.description FROM mtl_uom_class_conversions mucc , mtl_units_of_measure_vl muom 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 mucc.from_uom_code = muom.uom_code

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
, NULL ITEM
, MUOM.DESCRIPTION
FROM MTL_UOM_CONVERSIONS MUC
, MTL_UNITS_OF_MEASURE_VL 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 ALL /* THE ITEM INDEPENDENT CONVERSION(INVENTORY_ITEM_ID=0) FOR THE SAME CODE */ 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
, MUC.CONVERSION_RATE CONVERSION_RATE
, MUOM.BASE_UOM_FLAG BASE_UOM_FLAG
, 0 SR_ITEM_PK
, NULL ITEM
, MUOM.DESCRIPTION
FROM MTL_UOM_CONVERSIONS MUC
, MTL_UNITS_OF_MEASURE_VL 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 ALL /* FOR ITEM BASED UOM CONVERSION ACROSS THE CLASSES */ /* WE DO NOT TAKE INTO ACCOUNT ITEM_ID = 0*/ 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
, NULL ITEM
, MUOM.DESCRIPTION
FROM MTL_UOM_CLASS_CONVERSIONS MUCC
, MTL_UNITS_OF_MEASURE_VL MUOM
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 MUCC.FROM_UOM_CODE = MUOM.UOM_CODE