--List of different organizational material category differences
SELECT MSI1. SEGMENT1 Item_Number,
MSI1. DESCRIPTION,
MC1. DESCRIPTION Master_level,
FU1. DESCRIPTION user_name,
MIC1. Last_update_date,
MC2. DESCRIPTION Org_level,
FU2. DESCRIPTION user_name,
MIC2. Last_update_date
From Mtl_system_items_b MSI1,
Mtl_system_items_b MSI2,
Mtl_item_categories MIC1,
Mtl_item_categories MIC2,
Mtl_categories MC1,
Mtl_categories MC2,
Fnd_user FU1,
Fnd_user FU2
WHERE MSI1. inventory_item_id = MIC1. INVENTORY_ITEM_ID (+)
and msi1.organization_id = mic1.organization_id (+)
and MSI1. inventory_item_id = MSI2. inventory_item_id
and MSI2. inventory_item_id = MIC2. INVENTORY_ITEM_ID (+)
and msi2.organization_id = mic2.organization_id (+)
and MIC1. category_id = MC1. category_id
and MIC2. category_id = MC2. category_id
and mic1.organization_id = 204--A Organization ID
and mic2.organization_id = 706--b Organization ID
and MIC1. last_updated_by = FU1. user_id
and MIC2. last_updated_by = FU2. user_id
and MC1. category_id <> MC2. category_id
and UPPER (MSI1. Inventory_item_status_code) = ' ACTIVE '
ORDER by 1;
List of different organization item category differences