select haou.date_from,
       haou.attribute1 || ' ' || haou.name,
       haou.organization_id,
    uoepp.uoe_functions.uoe_get_college_org_code(haou.organization_id) L3,
     uoepp.uoe_functions.uoe_get_school_org_code(haou.organization_id) L4,
    (select listagg(organization_id, ',') within group (order by haou1.organization_id )from hr_all_organization_units haou1
    where haou1.attribute1 = haou.attribute1)
from hr_all_organization_units haou
where date_from = '01-AUG-2018 00.00.00'
order by uoepp.uoe_functions.uoe_get_college_org_code(haou.organization_id), uoepp.uoe_functions.uoe_get_school_org_code(haou.organization_id);


select * from hr_all_organization_units where attribute1 = 'P7V'