View: GHR_GBX_UR

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

View Text

SELECT GBU.USER_NAME
, 'PER'
, U.EMPLOYEE_ID
, GBX.NAME
, 'GBX'
, GBX.GROUPBOX_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 10
FROM GHR_GROUPBOXES GBX
, GHR_GROUPBOX_USERS GBU
, FND_USER U
WHERE GBU.GROUPBOX_ID = GBX.GROUPBOX_ID
AND GBU.USER_NAME = U.USER_NAME
AND U.EMPLOYEE_ID IS NOT NULL

Columns