Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Tuesday, 21 June 2016

Query to Get AOL Messages

SELECT
  CASE
    WHEN row_number() over(PARTITION BY app.application_name ORDER BY msg.message_name nulls LAST) = 1
    THEN app.application_name
    ELSE NULL
  END "Application" ,
  msg.message_name "Message Code" ,
  msg.language_code "Language" ,
  msg.message_text "Message" ,
  usr.user_name "Updated By" ,
  msg.last_update_date "Updated"
FROM fnd_new_messages msg ,
  fnd_application_vl app ,
  fnd_user usr
WHERE msg.last_updated_by = usr.user_id
AND msg.application_id    = app.application_id
AND app.application_name != 'XXEIS Custom Application'
AND app.application_name != 'Oracle Special Edition'
ORDER BY app.application_name,
  2 ASC
Share this article :

0 comments:

Post a Comment