orgs

select 
org.organization_id
,mp.organization_code
,org.name
,mp.CALENDAR_CODE
,mp.ATTRIBUTE6
--,mp.LPN_PREFIX
,org.creation_date
,org.DATE_FROM
,org.DATE_TO
,gl.currency_code
,org_def.operating_unit operating_unit_id
,org_def_ou.name operating_unit
,org_def.legal_entity legal_entity_ID,
xep.name                   "Legal Entity"
from apps.HR_ORGANIZATION_UNITS_V  org
,apps.MTL_PARAMETERS MP
,apps.org_organization_definitions org_def
,apps.HR_ORGANIZATION_UNITS_V org_def_ou
,apps.xle_entity_profiles xep
, apps.gl_ledgers gl
, apps.HR_ORGANIZATION_INFORMATION_V hoi
where  1=1
and org_def.ORGANIZATION_ID = hoi.ORGANIZATION_ID
and hoi.ORG_INFORMATION_CONTEXT = 'Accounting Information'
and hoi.ORG_INFORMATION1 = gl.LEDGER_ID
and xep.legal_entity_id = org_def.legal_entity
and org.organization_id = mp.organization_id(+)
and org_def.organization_id = mp.organization_id
and org_def_ou.organization_id(+) = org_def.operating_unit
--and org.DATE_TO is null
--and mp.organization_code in('W11','W12','W41','M01','M02','M03')
order by 1 asc