Oracle 消息定义查询 

 1 SELECT fa.application_short_name 应用简称,
 2        t.language_code           语言,
 3        t.message_number          编号,
 4        t.message_name            名称,
 5        t.message_text            消息文本
 6   FROM applsys.fnd_new_messages t,
 7        fnd_application          fa
 8  WHERE t.language_code = 'ZHS'
 9    AND t.application_id = fa.application_id
10    AND t.message_text LIKE '%终止日期%'

 

posted @ 2020-09-28 10:19  kiko_0926  阅读(127)  评论(0)  编辑  收藏  举报