Product: | INV - Inventory |
---|---|
Description: | Lot Specific UOM Conversions |
Implementation/DBA Data: | APPS.MTL_LOT_UOM_CLASS_CONV_V |
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