FND Design Data [Home] [Help]

View: GMS_OPERATING_UNITS_V

Product: GMS - Grants Accounting
Description: This view contains Operating Units defined in MO:Security Proifle and implemented Grants .
Implementation/DBA Data: ViewAPPS.GMS_OPERATING_UNITS_V
View Text

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

Columns

Name
ORG_ID
OPERATING_UNIT