a guest Aug 10th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select haou.date_from,
- haou.attribute1 || ' ' || haou.name,
- 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'
RAW Paste Data