View: GL_WF_ROLES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_WF_ROLES_V

View Text

SELECT USR.USER_NAME DISPLAY_NAME
, USR.USER_NAME NAME
, USR.DESCRIPTION DESCRIPTION
, 'FND_USR' ORIG_SYSTEM
, USR.USER_ID ORIG_SYSTEM_ID
, 'FND USER' TYPE
FROM FND_USER USR
WHERE NVL(USR.END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE) UNION ALL /*FND_RESPONSIBILITY */ SELECT R.RESPONSIBILITY_NAME DISPLAY_NAME
, 'FND_RESP'||R.APPLICATION_ID||':'||R.RESPONSIBILITY_ID NAME
, R.DESCRIPTION DESCRIPTION
, 'FND_RESP'||R.APPLICATION_ID ORIG_SYSTEM
, R.RESPONSIBILITY_ID ORIG_SYSTEM_ID
, 'FND RESPONSIBILITY' TYPE
FROM FND_RESPONSIBILITY_TL R
WHERE R.APPLICATION_ID IN (0
, 101
, 275)
AND R.LANGUAGE = USERENV('LANG')

Columns