View: HR_KR_ESTABLISHMENTS_V

Product:	PER - Human Resources
Description:	This view is used to validate PER_ALL_ASSIGNMENTS_F.ESTABLISHMENT_ID for Korea localization.
Implementation/DBA Data:	APPS.HR_KR_ESTABLISHMENTS_V

View Text

SELECT B.ORGANIZATION_ID
, TL.NAME
, B.BUSINESS_GROUP_ID
, B.DATE_FROM
, B.DATE_TO
FROM HR_ORGANIZATION_INFORMATION HOI
, HR_ALL_ORGANIZATION_UNITS_TL TL
, HR_ALL_ORGANIZATION_UNITS B
WHERE TL.ORGANIZATION_ID = B.ORGANIZATION_ID
AND TL.LANGUAGE = USERENV('LANG')
AND HOI.ORGANIZATION_ID = B.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = 'KR_BUSINESS_PLACE'
AND HOI.ORG_INFORMATION2 = 'Y'

Columns