Query to get data from fnd_log_messages for a given concurrent request id

SELECT l.module , l.message_text message, l.*
FROM apps.fnd_log_messages l,
            apps.fnd_log_transaction_context r
WHERE r.transaction_id = <:p_request_id > -- Input request id here
AND r.transaction_type = 'REQUEST'
AND r.transaction_context_id = l.transaction_context_id
ORDER BY l.log_sequence;