VIEW: APPS.MSD_LEGAL_ENTITIES_V

Source

View Text - Preformatted

SELECT o.organization_id id, o.name value from hr_all_organization_units o, hr_organization_information o2, hr_organization_information o3 WHERE o.organization_id = o2.organization_id and o.organization_id = o3.organization_id (+) and o2.org_information_context||'' = 'CLASS' and o3.org_information_context (+) || '' = 'Legal Entity Accounting' and o2.org_information1 = 'HR_LEGAL' and o2.org_information2 = 'Y'

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID ID
, O.NAME VALUE
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID (+)
AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND O3.ORG_INFORMATION_CONTEXT (+) || '' = 'LEGAL ENTITY ACCOUNTING'
AND O2.ORG_INFORMATION1 = 'HR_LEGAL'
AND O2.ORG_INFORMATION2 = 'Y'