[Home] [Help]
VIEW: APPS.OKL_ORG_UNITS_UV
Source
View Text - Preformatted
SELECT ou.organization_id org_id, ou.name operating_unit FROM HR_OPERATING_UNITS OU WHERE mo_global.check_access(ou.organization_id) = 'Y'
View Text - HTML Formatted
SELECT OU.ORGANIZATION_ID ORG_ID
, OU.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS OU
WHERE MO_GLOBAL.CHECK_ACCESS(OU.ORGANIZATION_ID) = 'Y'