Use this request to extract sourcing rules from R11i or R12 instances.
Here are the tables used in this query:
MRP_SR_SOURCE_ORG;
MRP_SOURCING_RULES;
MRP_SR_RECEIPT_ORG;
AP_VENDORS_V;
po_vendor_sites_all;
SELECT
MRP_SOURCING_RULES.SOURCING_RULE_ID,
org_organization_definitions.organization_code,
MRP_SOURCING_RULES.SOURCING_RULE_NAME,
MRP_SOURCING_RULES.DESCRIPTION,
MRP_SOURCING_RULES.STATUS,
MRP_SOURCING_RULES.SOURCING_RULE_TYPE,
MRP_SOURCING_RULES.PLANNING_ACTIVE,
AP_VENDORS_V.VENDOR_NAME,
po_vendor_sites_all.VENDOR_SITE_CODE,
MRP_SR_SOURCE_ORG.RANK,
MRP_SR_SOURCE_ORG.ALLOCATION_PERCENT
FROM MRP_SOURCING_RULES
LEFT JOIN MRP_SR_RECEIPT_ORG_V ON MRP_SR_RECEIPT_ORG_V.SOURCING_RULE_ID=MRP_SOURCING_RULES.SOURCING_RULE_ID
LEFT JOIN MRP_SR_SOURCE_ORG ON MRP_SR_SOURCE_ORG.SR_RECEIPT_ID=MRP_SR_RECEIPT_ORG_V.SR_RECEIPT_ID
LEFT JOIN AP_VENDORS_V ON AP_VENDORS_V.VENDOR_ID=MRP_SR_SOURCE_ORG.VENDOR_ID
LEFT JOIN po_vendor_sites_all ON po_vendor_sites_all.VENDOR_SITE_ID=MRP_SR_SOURCE_ORG.VENDOR_SITE_ID
LEFT JOIN org_organization_definitions ON org_organization_definitions.ORGANIZATION_ID=MRP_SOURCING_RULES.ORGANIZATION_ID
WHERE 1=1
AND MRP_SOURCING_RULES.ORGANIZATION_ID IN (select organization_id from org_organization_definitions where (organization_code = 'XXX' OR organization_code = 'XXY' ))
;