311: SELECT
312: CONVERSION_RATE
313: INTO CUR_RATE
314: FROM
315: MTL_UOM_CONVERSIONS_VIEW
316: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
317: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
318: AND PRIMARY_UOM_CODE = UOM
319: AND UOM_CODE = COUNT_UOM_CURRENT;
336: SELECT
337: CONVERSION_RATE
338: INTO PRIOR_RATE
339: FROM
340: MTL_UOM_CONVERSIONS_VIEW
341: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
342: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
343: AND PRIMARY_UOM_CODE = UOM
344: AND UOM_CODE = COUNT_UOM_PRIOR;
361: SELECT
362: CONVERSION_RATE
363: INTO FIRST_RATE
364: FROM
365: MTL_UOM_CONVERSIONS_VIEW
366: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
367: AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
368: AND PRIMARY_UOM_CODE = UOM
369: AND UOM_CODE = COUNT_UOM_FIRST;