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