How To Check lookup

SELECT
(
SELECT application_short_name

FROM fnd_application

WHERE application_id = flvv.view_application_id
) application,

flvv.lookup_code,

flvv.meaning,

flvv.description,

flvv.tag,

flvv.start_date_active,

flvv.end_date_active,

flvv.enabled_flag,

flvv.lookup_type,

flvv.security_group_id,

flvv.territory_code,

(
SELECT user_name

FROM fnd_user fu

WHERE fu.user_id = flvv.created_by
) uname,

flvv.creation_date,

flvv.last_update_date,

flvv.last_updated_by,

flvv.last_update_login

FROM fnd_lookup_values_vl flvv

WHERE
(
SELECT application_short_name

FROM fnd_application

WHERE application_id = flvv.view_application_id
)
/*Pass Application Code e.g for order management ONT */

ORDER BY 1