orgs
Description
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 |