Follow us: Connect on YouTube 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 :

2 comments:

  1. Selamat Petang,


    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.


    how to apply refcursor in package with multiple insted of multple cursors in oracle?

    Give one example.
    Thank you very much and will look for more postings from you.


    Regards,

    ReplyDelete
  2. Hi Dayakar,

    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.

    how to apply refcursor in package with multiple insted of multple cursors in oracle?
    Give one example.

    Thank you very much and will look for more postings from you.

    Regards,
    Preethi.

    ReplyDelete