View: MSD_SR_UOM_CONVERSIONS_V

Product:	MSD - Demand Planning
Description:	This is the Source View for UOM Conversions. This view would be applied to an Oracle Applications 11i instance from which the UOM Conversion information is to be retrieved.
Implementation/DBA Data:	APPS.MSD_SR_UOM_CONVERSIONS_V

View Text

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*/

Columns