View: MSD_UOM_CONVERSIONS_V

Product:	MSD - Demand Planning
Description:	This API specifies the Conversion Rate between two UOM's.
Implementation/DBA Data:	APPS.MSD_UOM_CONVERSIONS_V

View Text

SELECT /* ITEM SPECIFIC CONVERSION */ U.FROM_UOM_CLASS
, U.TO_UOM_CLASS
, U.FROM_UOM_CODE
, U.TO_UOM_CODE
, U.BASE_UOM_FLAG
, U.CONVERSION_RATE
, LV.LEVEL_PK
, LV.LEVEL_VALUE
, U.INSTANCE
, U.LAST_REFRESH_NUM
, U.CREATED_BY_REFRESH_NUM
, U.ACTION_CODE
FROM MSD_UOM_CONVERSIONS U
, MSD_LEVEL_VALUES LV
WHERE LV.SR_LEVEL_PK = TO_CHAR(U.SR_ITEM_PK)
AND LV.LEVEL_ID = 1
AND LV.INSTANCE = U.INSTANCE UNION /* NULL SR_ITEM_PK IS OKAY FOR SAME CLASS CONVERSIONS */ SELECT U.FROM_UOM_CLASS
, U.TO_UOM_CLASS
, U.FROM_UOM_CODE
, U.TO_UOM_CODE
, U.BASE_UOM_FLAG
, U.CONVERSION_RATE
, TO_NUMBER(NULL)
, U.ITEM
, U.INSTANCE
, U.LAST_REFRESH_NUM
, U.CREATED_BY_REFRESH_NUM
, U.ACTION_CODE
FROM MSD_UOM_CONVERSIONS U
WHERE U.SR_ITEM_PK IS NULL
AND U.FROM_UOM_CLASS = U.TO_UOM_CLASS UNION /* SWITCH
FROM AND TO FOR THE REVERSE CONVERSION */ SELECT U.TO_UOM_CLASS
, U.FROM_UOM_CLASS
, U.TO_UOM_CODE
, U.FROM_UOM_CODE
, U.BASE_UOM_FLAG
, 1/U.CONVERSION_RATE
, LV.LEVEL_PK
, LV.LEVEL_VALUE
, U.INSTANCE
, U.LAST_REFRESH_NUM
, U.CREATED_BY_REFRESH_NUM
, U.ACTION_CODE
FROM MSD_UOM_CONVERSIONS U
, MSD_LEVEL_VALUES LV
WHERE LV.SR_LEVEL_PK = TO_CHAR(U.SR_ITEM_PK)
AND LV.LEVEL_ID = 1
AND LV.INSTANCE = U.INSTANCE UNION /* REVERSE RATES FOR SAME CLASS CONVERSIONS WITHOUT AN ITEM REFERENCE */ SELECT U.TO_UOM_CLASS
, U.FROM_UOM_CLASS
, U.TO_UOM_CODE
, U.FROM_UOM_CODE
, U.BASE_UOM_FLAG
, 1/U.CONVERSION_RATE
, TO_NUMBER(NULL)
, U.ITEM
, U.INSTANCE
, U.LAST_REFRESH_NUM
, U.CREATED_BY_REFRESH_NUM
, U.ACTION_CODE
FROM MSD_UOM_CONVERSIONS U
WHERE U.SR_ITEM_PK IS NULL
AND U.FROM_UOM_CLASS = U.TO_UOM_CLASS

Columns