VIEW: APPS.FND_RESP_SEC_ROLES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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