View: FND_USER_RESP_GROUPS

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_USER_RESP_GROUPS

View Text

SELECT U.USER_ID USER_ID
, WUR.ROLE_ORIG_SYSTEM_ID RESPONSIBILITY_ID
, FA.APPLICATION_ID RESPONSIBILITY_APPLICATION_ID
, FSG.SECURITY_GROUP_ID SECURITY_GROUP_ID
, FND_DATE.CANONICAL_TO_DATE ( '1000/01/01' ) START_DATE
, TO_DATE ( NULL ) END_DATE
, TO_CHAR ( NULL ) DESCRIPTION
, TO_NUMBER ( NULL ) CREATED_BY
, TO_DATE ( NULL ) CREATION_DATE
, TO_NUMBER ( NULL ) LAST_UPDATED_BY
, TO_DATE ( NULL ) LAST_UPDATE_DATE
, TO_NUMBER ( NULL ) LAST_UPDATE_LOGIN
FROM FND_USER U
, WF_USER_ROLE_ASSIGNMENTS_V WURA
, WF_USER_ROLES WUR
, FND_APPLICATION FA
, FND_SECURITY_GROUPS FSG
WHERE WURA.USER_NAME = U.USER_NAME
AND WUR.ROLE_ORIG_SYSTEM = 'FND_RESP'
AND WUR.PARTITION_ID = 2
AND WURA.ROLE_NAME = WUR.ROLE_NAME
AND WURA.USER_NAME = WUR.USER_NAME
AND FA.APPLICATION_SHORT_NAME =/* VAL BETWEEN 1 ST
AND 2 ND SEPARATOR */ REPLACE ( SUBSTR ( WURA.ROLE_NAME
, INSTR ( WURA.ROLE_NAME
, '|'
, 1
, 1 ) +1
, ( INSTR ( WURA.ROLE_NAME
, '|'
, 1
, 2 ) - INSTR ( WURA.ROLE_NAME
, '|'
, 1
, 1 ) -1 ) )
, '%COL'
, ':' )
AND FSG.SECURITY_GROUP_KEY =/* VAL AFTER 3 RD SEPARATOR */ REPLACE ( SUBSTR ( WURA.ROLE_NAME
, INSTR ( WURA.ROLE_NAME
, '|'
, 1
, 3 ) +1 )
, '%COL'
, ':' )