Need help Tuning Inventory SQL Script
Thanks in advance.
Leo
---------------------------------------------------------------------------------------------------------
SELECT msib.organization_id, msib.inventory_item_id, msib.segment1,
msib.description, msib.planning_make_buy_code, msib.buyer_id,
msib.planner_code, msib.primary_uom_code,
msib.safety_stock_bucket_days,
(SELECT NVL (cic.item_cost, 0)
FROM cst_item_costs cic, cst_cost_types cct