[Home] [Help]
View: PER_SECURITY_ORGANIZATIONS_V
View Text
SELECT UTL.NAME
, PSO.ORGANIZATION_ID
, PSO.SECURITY_PROFILE_ID
, PSO.ENTRY_TYPE
, PSO.LAST_UPDATED_BY
, PSO.LAST_UPDATE_DATE
, PSO.LAST_UPDATE_LOGIN
, PSO.CREATED_BY
, PSO.CREATION_DATE
, PSO.SECURITY_ORGANIZATION_ID
, PSO.OBJECT_VERSION_NUMBER
FROM HR_ALL_ORGANIZATION_UNITS_TL UTL
, PER_SECURITY_ORGANIZATIONS PSO
WHERE UTL.ORGANIZATION_ID = PSO.ORGANIZATION_ID
AND UTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ORGANIZATION_NAME |
ORGANIZATION_ID |
SECURITY_PROFILE_ID |
ENTRY_TYPE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
SECURITY_ORGANIZATION_ID |
OBJECT_VERSION_NUMBER |