I use:
SELECT
clt.lookup_type "Lookup ID",
CASE clt.is_active WHEN 1 THEN 'Yes' ELSE 'No' End "Active",
cnq.created_date "Created Date",
sr.full_name "Created By",
cnq.nsql_text "Query NSQL"
FROM
cmn_list_of_values clov, cmn_lookup_types clt, cmn_nsql_queries cnq, srm_resources sr
WHERE clt.lookup_type=clov.lookup_type_code
and cnq.id=clov.sql_text_id
and sr.user_id=cnq.created_by
The last field in the above SQL (aka cnq.nsql_text ) will contain the NSQL.