Basic Oracle Inventory Scripts-INV0001

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