[Home] [Help]
View: WF_GBX_UR
Product: | FND - Application Object Library |
Description: | Bulk Sync Directory Service User Role View for Role Orig System GBX |
Implementation/DBA Data: |
APPS.WF_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
Name |
USER_NAME |
USER_ORIG_SYSTEM |
USER_ORIG_SYSTEM_ID |
ROLE_NAME |
ROLE_ORIG_SYSTEM |
ROLE_ORIG_SYSTEM_ID |
START_DATE |
EXPIRATION_DATE |
SECURITY_GROUP_ID |
PARTITION_ID |