MATERIALIZED VIEW: MSC.MSC_SUPPLIER_TREE_MV

Source

select distinct mis.plan_id, mis.supplier_id, mis.supplier_site_id, mic.category_set_id, mtp.partner_name supplier_name, mtp.partner_type from msc_item_suppliers mis, msc_item_categories mic, msc_trading_partners mtp where mic.sr_instance_id = mis.sr_instance_id and mic.organization_id = mis.organization_id and mic.inventory_item_id = mis.inventory_item_id and mis.using_organization_id = -1 and mtp.partner_id = mis.supplier_id