VIEW: APPS.WF_FND_RESP_ROLES

Source

View Text - Preformatted

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

   

View Text - HTML Formatted

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