View: WF_FND_RESP_UR

Product:	FND - Application Object Library
Description:	Bulk Sync Directory Service User Role View for Role Orig System FND_RESP
Implementation/DBA Data:	APPS.WF_FND_RESP_UR

View Text

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)

Columns