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: GHR_GBX_ROLES

Product:	GHR - US Federal Human Resources
Description:	View for WF Bulk synchonization of Groupboxes
Implementation/DBA Data:	APPS.GHR_GBX_ROLES

View Text

SELECT GBX.NAME
, GBX.DISPLAY_NAME
, GBX.DESCRIPTION
, 'QUERY'
, NULL
, NULL
, NULL
, NULL
, 'GBX'
, GBX.GROUPBOX_ID
, TO_DATE(NULL)
, 'ACTIVE'
, TO_DATE(NULL)
, NULL
, 'N'
, 10
FROM GHR_GROUPBOXES GBX

Columns

Name
NAME
DISPLAY_NAME
DESCRIPTION
NOTIFICATION_PREFERENCE
LANGUAGE
TERRITORY
EMAIL_ADDRESS
FAX
ORIG_SYSTEM
ORIG_SYSTEM_ID
START_DATE
STATUS
EXPIRATION_DATE
SECURITY_GROUP_ID
USER_FLAG
_PARTITION_ID