[Home] [Help]
View: FND_RESP_SEC_ROLES
View Text
SELECT
'FND_RESP'||R.APPLICATION_ID||':'||R.RESPONSIBILITY_ID NAME
,
T.RESPONSIBILITY_NAME||' :ANY SECURITY GROUP' DISPLAY_NAME
,
T.DESCRIPTION DESCRIPTION
,
'QUERY' NOTIFICATION_PREFERENCE
,
TO_CHAR(NULL) LANGUAGE
,
TO_CHAR(NULL) TERRITORY
,
TO_CHAR(NULL) EMAIL_ADDRESS
,
TO_CHAR(NULL)FAX
,
'FND_RESP'||R.APPLICATION_ID ORIG_SYSTEM
,
R.RESPONSIBILITY_ID ORIG_SYSTEM_ID
,
R.START_DATE START_DATE
,
DECODE(SUBSTR(TO_CHAR(NVL(R.END_DATE
, SYSDATE+1)-SYSDATE)
, 1
, 1)
, '-'
,
'INACTIVE'
, 'ACTIVE') STATUS
,
R.END_DATE EXPIRATION_DATE
,
TO_CHAR(NULL) SECURITY_GROUP_ID
,
'N' USER_FLAG
,
2 PARTITION_ID
,
R.CREATED_BY CREATED_BY
,
R.CREATION_DATE CREATION_DATE
,
R.LAST_UPDATED_BY LAST_UPDATED_BY
,
R.LAST_UPDATE_DATE LAST_UPDATE_DATE
,
R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FND_RESPONSIBILITY R
, FND_RESPONSIBILITY_TL T
, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG = 'B'
AND T.LANGUAGE = L.LANGUAGE_CODE
AND R.APPLICATION_ID = T.APPLICATION_ID
AND R.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID