VIEW: APPS.WF_FND_RESP_ROLES_VL

Source

View Text - Preformatted

SELECT 'FND_RESP'||rtl.application_id||':'||rtl.responsibility_id,
 RTL.RESPONSIBILITY_NAME, RTL.DESCRIPTION, RTL.LANGUAGE, RTL.SOURCE_LANG,
 'FND_RESP'||rtl.application_id, RTL.RESPONSIBILITY_ID from
 FND_RESPONSIBILITY_TL RTL, FND_LANGUAGES L where L.INSTALLED_FLAG = 'I'
 and RTL.LANGUAGE = L.LANGUAGE_CODE

   

View Text - HTML Formatted

SELECT 'FND_RESP'||RTL.APPLICATION_ID||':'||RTL.RESPONSIBILITY_ID
, RTL.RESPONSIBILITY_NAME
, RTL.DESCRIPTION
, RTL.LANGUAGE
, RTL.SOURCE_LANG
, 'FND_RESP'||RTL.APPLICATION_ID
, RTL.RESPONSIBILITY_ID FROM FND_RESPONSIBILITY_TL RTL
, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG = 'I'
AND RTL.LANGUAGE = L.LANGUAGE_CODE