Search This Blog

Friday, July 11, 2008

Query to get Concurrent program name and its parameter

Below query can be used to get concurrent program name and its parameter

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 par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name

Copyright (c) All rights reserved. Presented by Suresh Vaishya