ERPstuff - Oracle EBS Community

Posted: **Thu Oct 30, 2008 9:13 am**

Hi,

how can i know item and their names from inventory.we are working on indian location.please tell how can i know the items and their name from backend,

which table will hold item name,number.....

please revert me back....

Regards
Roshan

Posted: **Sun Nov 02, 2008 8:50 pm**

Hi roshan, first at all excuse my english...
Ok, items and their names are saved in mtl_system_items_b table, the segment1 column is the user known item number but an identifier is added by oracle in column inventory_item_id, the item name is stored in description column, additionally items are organization-assigned, this relation is in the organization_id column.

Bye