VIEW: APPS.GMS_OPERATING_UNITS_V

Source

View Text - Preformatted

SELECT hr.organization_id org_id ,hr.name operating_unit FROM hr_operating_units hr, gms_implementations_all imp WHERE mo_global.check_access(hr.organization_id) = 'Y' and Imp.org_id = hr.organization_id

View Text - HTML Formatted

SELECT HR.ORGANIZATION_ID ORG_ID
, HR.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS HR
, GMS_IMPLEMENTATIONS_ALL IMP
WHERE MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID) = 'Y'
AND IMP.ORG_ID = HR.ORGANIZATION_ID