AR Batch Source Status

select
haouv.name operating_unit,
rbsa.name batch_source,
rbsa.status,
rbsa.start_date,
rbsa.end_date,
rbsa.batch_source_id
from
hr_all_organization_units_vl haouv,
ra_batch_sources_all rbsa
where
1=1 and
haouv.organization_id=rbsa.org_id
order by
1,2

select haouv.name operating_unit, rbsa.name batch_source, rbsa.status, rbsa.start_date, rbsa.end_date, rbsa.batch_source_id from hr_all_organization_units_vl haouv, ra_batch_sources_all rbsa where 1=1 and haouv.organization_id=rbsa.org_id order by 1,2