[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: |
APPS.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 |