Inventory Item Attributes, Categories, Vendor & Costs
Query to get safety stock Quantity of inventory items: select msib.segment1,c.INVENTORY_ITEM_ID,SAFETY_STOCK_QUANTITY from mtl_safety_stocks c, mtl_system_items_b msib where c.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID and c.ORGANIZATION_ID = msib.ORGANIZATION_ID and c.SAFETY_STOCK_QUANTITY <> 0 and msib.ORGANIZATION_ID = 12 and msib.segment1 in ('98765'); Query to get the inventory item vendor and costs : select msi.inventory_item_id "Item ID", msi.segment1 "Part Number", msi.description "Part Description - Internal", decode (msi.item_type,'XX_SUPPORT_ITEM','SUPPORT ITEM' ,'XX_BULK_ITEM','BULK ITEM' ,'P','PURCHAS...