To
Find Inventory Item Description
SELECT DISTINCT SEGMENT1, DESCRIPTION
FROM MTL_SYSTEM_ITEMS_B
WHERE SEGMENT1 = :ITEM_NUMBER
To Find Inventory Item Description & UOM
SELECT DISTINCT SEGMENT1, DESCRIPTION,PRIMARY_UNIT_OF_MEASURE
FROM MTL_SYSTEM_ITEMS_B
WHERE SEGMENT1 = :ITEM_NUMBER
To Find Inventory Item Description,UOM
& Assigned Organization Name
SELECT MTL.SEGMENT1, MTL.DESCRIPTION, MTL.PRIMARY_UNIT_OF_MEASURE,
OOD.ORGANIZATION_CODE
FROM
MTL_SYSTEM_ITEMS_B MTL,
ORG_ORGANIZATION_DEFINITIONS OOD
WHERE MTL.ORGANIZATION_ID = OOD.ORGANIZATION_ID AND SEGMENT1 = :ITEM_NUMBER
