PL-SQL script to assign the items from one inventory org to another.
Tag: mtl_system_items_b
MTL_SYSTEM_ITEMS_B: Columns, Indexes & Few Tricks
MTL_SYSTEM_ITEMS_B: Table used by Oracle R12 for storing the Item information. Or in other words, it is R12 equivalent of EGP_SYSTEM_ITEMS_B table in Oracle Fusion. Slight difference is that MTL_SYSTEM_ITEMS_B table stores the item number in segment1 field. And since the item is defined at Inventory Org level, Combination of Inventory_item_Id and Organization_Id will give… Continue reading MTL_SYSTEM_ITEMS_B: Columns, Indexes & Few Tricks