Item Extract with sourcing rule and purchasing category

select distinct msi.segment1 "ITEM_NUMBER", 
msi.description,
ood.organization_code,
papf.full_name "BUYER",
msi.planner_code,
msa.sourcing_rule_name,
msi.list_price_per_unit,
mcv.description "PURCHASING_CATEGORY",
--mcv.structure_name,
msi.inventory_item_status_code,
msi.preprocessing_lead_time,
msi.full_lead_time,
msi.postprocessing_lead_time
from mtl_system_items_b msi,
org_organization_definitions ood,
per_all_people_f papf,
mrp_sr_assignments_v msa,
mtl_item_categories mic,
mtl_categories_v mcv
where msi.organization_id = ood.organization_id
and msi.buyer_id = papf.person_id (+)
and msi.inventory_item_id = msa.inventory_item_id(+)
and msi.organization_id = msa.organization_id(+)
and mic.organization_id=msi.organization_id
and mic.inventory_item_id = msi.inventory_item_id
and mic.category_id = mcv.category_id
and mcv.structure_name ='ENVS PO Categories'
and msi.inventory_item_status_code ='Active';
--and msi.segment1 ='08180813';