Supplier Sourcing Rule Query in Oracle Apps

Supplier Sourcing Rule Query in Oracle Apps

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 = 1
   AND mas.assignment_set_name  like '%ASSIGNMENT_SET%'
   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
   and v.segment1=:P_vendor_code   -- AB TOOLS PVT. LTD.