VIEW: APPS.GL_WF_ROLES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')