View: ENG_ECO_DEPARTMENTS_VIEW

Product:	ENG - Engineering
Description:	All ECO departments in HR_ORGANIZATION_UNITS
Implementation/DBA Data:	APPS.ENG_ECO_DEPARTMENTS_VIEW

View Text

SELECT OU.ORGANIZATION_ID
, OU.BUSINESS_GROUP_ID
, OU.NAME
, OI.ORG_INFORMATION2
FROM HR_ALL_ORGANIZATION_UNITS OU
, HR_ORGANIZATION_INFORMATION OI
WHERE OU.ORGANIZATION_ID = OI.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND OI.ORG_INFORMATION1 = 'BOM_ECOD'

Columns