View: FND_RESP_SEC_UR

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

View Text

SELECT U.USER_NAME USER_NAME
, DECODE(U.EMPLOYEE_ID
, NULL
, 'FND_USR'
, 'PER') USER_ORIG_SYSTEM
, DECODE(U.EMPLOYEE_ID
, NULL
, U.USER_ID
, U.EMPLOYEE_ID) USER_ORIG_SYSTEM_ID
, 'FND_RESP|'||A.APPLICATION_SHORT_NAME||'|'||REPLACE(R.RESPONSIBILITY_KEY
, ':'
, '%COL')||'|'||S.SECURITY_GROUP_KEY ROLE_NAME
, 'FND_RESP' ROLE_ORIG_SYSTEM
, R.RESPONSIBILITY_ID ROLE_ORIG_SYSTEM_ID
, UR.START_DATE START_DATE
, UR.END_DATE EXPIRATION_DATE
, UR.SECURITY_GROUP_ID SECURITY_GROUP_ID
, TO_NUMBER(NULL) PARTITION_ID
, UR.CREATED_BY CREATED_BY
, UR.CREATION_DATE CREATION_DATE
, UR.LAST_UPDATED_BY LAST_UPDATED_BY
, UR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, U.START_DATE USER_START_DATE
, U.END_DATE USER_END_DATE
, R.START_DATE ROLE_START_DATE
, R.END_DATE ROLE_END_DATE FROM FND_USER U
, FND_USER_RESP_GROUPS_OLD UR
, FND_RESPONSIBILITY R
, FND_APPLICATION A
, FND_SECURITY_GROUPS S WHERE U.USER_ID = UR.USER_ID AND UR.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID AND UR.RESPONSIBILITY_APPLICATION_ID = R.APPLICATION_ID AND R.APPLICATION_ID = A.APPLICATION_ID AND UR.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID UNION SELECT U.USER_NAME USER_NAME
, DECODE(U.EMPLOYEE_ID
, NULL
, 'FND_USR'
, 'PER') USER_ORIG_SYSTEM
, DECODE(U.EMPLOYEE_ID
, NULL
, U.USER_ID
, U.EMPLOYEE_ID) USER_ORIG_SYSTEM_ID
, 'FND_RESP'||UR.RESPONSIBILITY_APPLICATION_ID||':'||UR.RESPONSIBILITY_ID ROLE_NAME
, 'FND_RESP'||R.APPLICATION_ID ROLE_ORIG_SYSTEM
, R.RESPONSIBILITY_ID ROLE_ORIG_SYSTEM_ID
, UR.START_DATE START_DATE
, UR.END_DATE EXPIRATION_DATE
, UR.SECURITY_GROUP_ID SECURITY_GROUP_ID
, TO_NUMBER(NULL) PARTITION_ID
, UR.CREATED_BY CREATED_BY
, UR.CREATION_DATE CREATION_DATE
, UR.LAST_UPDATED_BY LAST_UPDATED_BY
, UR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, U.START_DATE USER_START_DATE
, U.END_DATE USER_END_DATE
, R.START_DATE ROLE_START_DATE
, R.END_DATE ROLE_END_DATE FROM FND_USER U
, FND_USER_RESP_GROUPS_OLD UR
, FND_RESPONSIBILITY R
, FND_APPLICATION A
, FND_SECURITY_GROUPS S WHERE U.USER_ID = UR.USER_ID AND UR.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID AND UR.RESPONSIBILITY_APPLICATION_ID = R.APPLICATION_ID AND R.APPLICATION_ID = A.APPLICATION_ID AND UR.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID