How To get Flexfilds Application wise

SELECT
(
SELECT UNIQUE application_short_name

FROM fnd_application

WHERE application_id = fdfcv.application_id
) application,

fdfcv.descriptive_flex_context_code,

fdfcv.descriptive_flex_context_name,

fdfcv.description,

fdfcv.enabled_flag,

fdfcv.application_id,

fdfcv.descriptive_flexfield_name,

fdfcv.last_update_date,

fdfcv.last_updated_by,

fdfcv.last_update_login,

fdfcv.creation_date,

fdfcv.created_by,

fdfcv.global_flag,

fdfcv.row_id

FROM fnd_descr_flex_contexts_vl fdfcv

WHERE
(
SELECT UNIQUE application_short_name

FROM fnd_application

WHERE application_id = fdfcv.application_id
) = 'ONT'

-->ONT used For order management