Oracle R12 Expense Type Master Based On Operating Unit

SELECT
(
SELECT
hou.name
FROM
apps.hr_operating_units hou
WHERE
hou.organization_id = aerpa.org_id
) operating_unit,
aerpa.prompt expense_type,
aerpa.flex_description gl_description,
aerpa.flex_concactenated gl_code,
aerpa.category_code,
aerpa.end_date
FROM
apps.ap_expense_report_params_all aerpa
WHERE
aerpa.org_id IN (
382,
402,
393,
398
)
ORDER BY
1,
2