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
Tag: minimum order quantity
Item Detail Query in Oracle Fusion Finance
query to fetch the Item Details in Oracle Fusion Finance like Planner, Lead Time, status, minimum Order quantity, Unit Length, lot multiplier etc