VIEW: APPS.PER_SECURITY_ORGANIZATIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')