Query To Get FND Messages in Oracle Fusion

   SELECT
         fa.application_short_name,  fm.message_name, fm.message_text 
        FROM
            fnd_new_messages          fm,
            fnd_application    fa
        WHERE
                1 = 1
            AND fm.application_id = fa.application_id
            AND language_code = 'US'