Learning Oracle Application and Software Testing: SQL Queries Related to Oracle Application Messages

Monday, February 19, 2018

SQL Queries Related to Oracle Application Messages

SELECT    m.message_name,
                 m.message_text,

                 m.message_number,

                 a.application_short_name

FROM     FND_NEW_MESSAGES M,

                FND_APPLICATION a

WHERE  m.message_name LIKE '%&Enter_Message_Name%'

AND        m.language_code  = 'US'

AND        M.APPLICATION_ID = a.APPLICATION_ID;