View: PER_ORGANIZATION_UNITS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_ORGANIZATION_UNITS_V

View Text

SELECT O.ORGANIZATION_ID
, O.ROWID
, O.BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID
, O.SOFT_CODING_KEYFLEX_ID
, O.DATE_FROM
, OTL.NAME
, O.COMMENTS
, O.DATE_TO
, O.INTERNAL_EXTERNAL_FLAG
, L2.MEANING
, O.INTERNAL_ADDRESS_LINE
, O.TYPE
, L.MEANING
, O.REQUEST_ID
, O.PROGRAM_APPLICATION_ID
, O.PROGRAM_ID
, O.PROGRAM_UPDATE_DATE
, O.ATTRIBUTE_CATEGORY
, O.ATTRIBUTE1
, O.ATTRIBUTE2
, O.ATTRIBUTE3
, O.ATTRIBUTE4
, O.ATTRIBUTE5
, O.ATTRIBUTE6
, O.ATTRIBUTE7
, O.ATTRIBUTE8
, O.ATTRIBUTE9
, O.ATTRIBUTE10
, O.ATTRIBUTE11
, O.ATTRIBUTE12
, O.ATTRIBUTE13
, O.ATTRIBUTE14
, O.ATTRIBUTE15
, O.ATTRIBUTE16
, O.ATTRIBUTE17
, O.ATTRIBUTE18
, O.ATTRIBUTE19
, O.ATTRIBUTE20
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.LAST_UPDATE_LOGIN
, O.CREATED_BY
, O.CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_LOOKUPS L
, HR_LOOKUPS L2
WHERE O.TYPE = L.LOOKUP_CODE (+)
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND L.LOOKUP_TYPE (+) = 'ORG_TYPE'
AND O.INTERNAL_EXTERNAL_FLAG = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'INTL_EXTL'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')

Columns