VIEW: APPS.WF_FND_RESP_UR

Source

View Text - Preformatted

SELECT distinct U.USER_NAME, decode(u.employee_id,NULL,'FND_USR','PER'), decode(u.employee_id,NULL,U.USER_ID,u.employee_id), 'FND_RESP'||UR.RESPONSIBILITY_APPLICATION_ID||':'||R.RESPONSIBILITY_ID, 'FND_RESP'||UR.RESPONSIBILITY_APPLICATION_ID, R.RESPONSIBILITY_ID, to_date(NULL), to_date(NULL), NULL, 2 from FND_USER U, FND_USER_RESP_GROUPS UR, FND_RESPONSIBILITY R WHERE U.USER_ID = UR.USER_ID and UR.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID and UR.RESPONSIBILITY_APPLICATION_ID = R.APPLICATION_ID and trunc(sysdate) between UR.START_DATE and NVL(UR.END_DATE, sysdate + 1) and trunc(sysdate) between U.START_DATE and NVL(U.END_DATE, sysdate + 1) and trunc(sysdate) between R.START_DATE and NVL(R.END_DATE, sysdate + 1)

View Text - HTML Formatted

SELECT DISTINCT U.USER_NAME
, DECODE(U.EMPLOYEE_ID
, NULL
, 'FND_USR'
, 'PER')
, DECODE(U.EMPLOYEE_ID
, NULL
, U.USER_ID
, U.EMPLOYEE_ID)
, 'FND_RESP'||UR.RESPONSIBILITY_APPLICATION_ID||':'||R.RESPONSIBILITY_ID
, 'FND_RESP'||UR.RESPONSIBILITY_APPLICATION_ID
, R.RESPONSIBILITY_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 2
FROM FND_USER U
, FND_USER_RESP_GROUPS UR
, FND_RESPONSIBILITY R
WHERE U.USER_ID = UR.USER_ID
AND UR.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND UR.RESPONSIBILITY_APPLICATION_ID = R.APPLICATION_ID
AND TRUNC(SYSDATE) BETWEEN UR.START_DATE
AND NVL(UR.END_DATE
, SYSDATE + 1)
AND TRUNC(SYSDATE) BETWEEN U.START_DATE
AND NVL(U.END_DATE
, SYSDATE + 1)
AND TRUNC(SYSDATE) BETWEEN R.START_DATE
AND NVL(R.END_DATE
, SYSDATE + 1)