VIEW: APPS.JTA_UM_MAIL_PREFERENCE_V

Source

View Text - Preformatted

SELECT substr(name,instr(name,'-')+1) code, substr(TEXT,1,40) Description
FROM WF_RESOURCES
WHERE NAME LIKE 'WFPREF_MAILP%'
AND LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT SUBSTR(NAME
, INSTR(NAME
, '-')+1) CODE
, SUBSTR(TEXT
, 1
, 40) DESCRIPTION FROM WF_RESOURCES WHERE NAME LIKE 'WFPREF_MAILP%' AND LANGUAGE = USERENV('LANG')