How do I find which organization is master to which child organization?


SELECT p.organization_id clild_organization_id,
  p.organization_code clild_organization_code,
  c.organization_name child_organization_name,
  p.master_organization_id,
  m.organization_code master_organization_code,
  m.organization_name master_organization_name
FROM mtl_parameters p,
  org_organization_definitions m,
  org_organization_definitions c
WHERE p.master_organization_id = m.organization_id
AND p.organization_id = c.organization_id
ORDER BY p.organization_code

Leave a Reply