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