Fetch the roles base on Organizational Role

SELECT

br.name AS itr_or_br,
br.type AS itr_br_type,
it.name AS org_role_name,
it.type AS org_type

FROM identityiq.spt_bundle_children r
JOIN identityiq.spt_bundle it ON it.id = r.child
JOIN identityiq.spt_bundle br ON BR.ID = r.bundle

WHERE
it.name = 'ISC IT - Container';