SELECT sr.SOURCING_RULE_NAME,
sr.organization_id,
mp.organization_code ,
sso.SR_RECEIPT_ID,
sro.SOURCING_RULE_ID,
sso.ALLOCATION_PERCENT,
sso.CREATION_DATE,
sso.LAST_UPDATE_DATE,
sra.organization_id,
sra.category_set_id,
sra.inventory_item_id,
msi.segment1
FROM apps.MRP_SR_SOURCE_ORG_V sso,
apps.MRP_SR_RECEIPT_ORG sro,
apps.MRP_SOURCING_RULES sr,
apps.MRP_SR_ASSIGNMENTS_V sra,
apps.mtl_parameters mp,
apps.mtl_system_items_b msi
WHERE sso.ALLOCATION_PERCENT != 100
AND sso.ALLOCATION_PERCENT != 0
AND sso.SR_RECEIPT_ID = sro.SR_RECEIPT_ID
AND sro.SOURCING_RULE_ID = sr.SOURCING_RULE_ID
and sso.SOURCE_TYPE = 1
and sra.SOURCING_RULE_ID = sr.SOURCING_RULE_ID
and sr.organization_id = mp.organization_id
and msi.organization_id = 87
and msi.inventory_item_id(+) = sra.inventory_item_id
