Query to get Supplier Sourcing Rules

SELECT msr.sourcing_rule_name
      ,mas.assignment_set_name
      ,mas.description assignment_desc
      ,msra.entity_name item_code
      ,v.segment1 vendor_code
      ,v.vendor_name
      ,msso.vendor_site_id
      ,vs.vendor_site_code
      ,msso.source_type
      ,msso.allocation_percent
      ,msso.RANK
  FROM apps.mrp_sr_assignments_v msra
      ,mrp_assignment_sets mas
      ,mrp_sourcing_rules msr
      ,mrp_sr_source_org msso
      ,po_vendors v
      ,po_vendor_sites_all vs
      ,mrp_sr_receipt_org sro
      ,mtl_interorg_ship_methods sm
 WHERE msr.sourcing_rule_id = msra.sourcing_rule_id
   AND msra.assignment_set_id = mas.assignment_set_id
   AND mas.assignment_set_id = 23
   AND mas.assignment_set_name LIKE '%H%'
   AND v.vendor_id(+) = msso.vendor_id
   AND vs.vendor_site_id(+) = msso.vendor_site_id
   AND msr.sourcing_rule_id = sro.sourcing_rule_id
   AND sm.to_organization_id(+) = sro.receipt_organization_id
   AND sro.sr_receipt_id = msso.sr_receipt_id
   AND msso.ship_method IS NULL

Output: