eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_OPERATING_UNITS_V_R

Product:	PA - Projects
Description:	This view contains Operating Units defined in MO:Security Proifle and implemented Projects .
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
ORG_ID
OPERATING_UNIT