Display your Concurrent Program Details in Backend

SELECT fcpl.user_concurrent_program_name     ,
               fcp.concurrent_program_name     ,
               par.end_user_column_name     ,
               par.form_left_prompt prompt     ,
               par.enabled_flag     ,
               par.required_flag     ,
               par.display_flag
FROM   fnd_concurrent_programs fcp     ,
              fnd_concurrent_programs_tl fcpl     ,
              fnd_descr_flex_col_usage_vl par
WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id
     AND  fcpl.user_concurrent_program_name = :conc_prg_name
     AND  fcpl.LANGUAGE = 'US'
     AND  par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name


Output:-

USER CONCURRENT PROGRAM NAME	CONCURRENT PROGRAM NAME	END USER COLUMN NAME	PROMPT	ENABLED FLAG	REQUIRED FLAG	DISPLAY FLAG
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Invoice Number	Credit Note Number	Y	N	Y
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Prov. Invoice Number	Provisional Invoice Number	Y	N	Y
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Final Invoice Number	Final Invoice Number	Y	N	N
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Final Invoice Amount	Final Invoice Amount	Y	N	Y
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Additional Info	Additional Info	Y	N	Y
XXGL Credit Note Trading	XXGL_CREDIT_NOTE_TRADING	Narration	Narration	Y	N	Y