SELECT plan_id, sr_instance_id, inventory_item_id, item_name, description, organization_id, organization_code from msc_system_items WHERE bom_item_type in (1,2,5)
View Text - HTML Formatted
SELECT PLAN_ID , SR_INSTANCE_ID , INVENTORY_ITEM_ID , ITEM_NAME , DESCRIPTION , ORGANIZATION_ID , ORGANIZATION_CODE FROM MSC_SYSTEM_ITEMS WHERE BOM_ITEM_TYPE IN (1 , 2 , 5)