VIEW: APPS.MTL_LOT_UOM_CLASS_CONV_V

Source

View Text - Preformatted

SELECT A.CONVERSION_ID , A.LOT_NUMBER , A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.FROM_UNIT_OF_MEASURE , A.FROM_UOM_CODE , A.FROM_UOM_CLASS , A.TO_UNIT_OF_MEASURE , A.TO_UOM_CODE , A.TO_UOM_CLASS , A.CONVERSION_RATE , A.DISABLE_DATE , A.EVENT_SPEC_DISP_ID , A.CREATED_BY , A.CREATION_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_DATE , A.LAST_UPDATE_LOGIN , NULL , NULL , B.PRIMARY_UOM_CODE , B.SECONDARY_UOM_CODE , B.LOT_DIVISIBLE_FLAG , B.DUAL_UOM_DEVIATION_HIGH , B.DUAL_UOM_DEVIATION_LOW , B.SERIAL_NUMBER_CONTROL_CODE FROM MTL_LOT_UOM_CLASS_CONVERSIONS A , MTL_SYSTEM_ITEMS_B B WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID = B.ORGANIZATION_ID

View Text - HTML Formatted

SELECT A.CONVERSION_ID
, A.LOT_NUMBER
, A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.FROM_UNIT_OF_MEASURE
, A.FROM_UOM_CODE
, A.FROM_UOM_CLASS
, A.TO_UNIT_OF_MEASURE
, A.TO_UOM_CODE
, A.TO_UOM_CLASS
, A.CONVERSION_RATE
, A.DISABLE_DATE
, A.EVENT_SPEC_DISP_ID
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, NULL
, NULL
, B.PRIMARY_UOM_CODE
, B.SECONDARY_UOM_CODE
, B.LOT_DIVISIBLE_FLAG
, B.DUAL_UOM_DEVIATION_HIGH
, B.DUAL_UOM_DEVIATION_LOW
, B.SERIAL_NUMBER_CONTROL_CODE
FROM MTL_LOT_UOM_CLASS_CONVERSIONS A
, MTL_SYSTEM_ITEMS_B B
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID