View Suresh Vaishya's profile
On request here is the query to list concurrent program name with its parameter, values set and default value/type
SELECT fcpl.user_concurrent_program_name
, fcp.concurrent_program_name
, par.column_seq_num
, par.end_user_column_name
, par.form_left_prompt prompt
, par.enabled_flag
, par.required_flag
, par.display_flag
, par.flex_value_set_id
, ffvs.flex_value_set_name
, flv.meaning default_type
, par.DEFAULT_VALUE
FROM fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpl
, fnd_descr_flex_col_usage_vl par
, fnd_flex_value_sets ffvs
, fnd_lookup_values flv
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
AND ffvs.flex_value_set_id = par.flex_value_set_id
AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
AND flv.lookup_code(+) = par.default_type
AND flv.LANGUAGE(+) = USERENV ('LANG')
ORDER BY par.column_seq_num
11 Comments:
Hi..
This blog is very useful for oracle apps prof..
i have one doubt,
How can i find the valueset that has been attached to the various concurrent programs?
Thank u for ur consideration and i look forward to hearing from u.
Thanks and Regards,
Venkatesan.R
Hi.. my mail id is ,
byvenkat@gmail.com
Thanks and Regards,
Venkatesan.R
You can use same query with slight modification in it. Instead of taking concurrent program name as a parameter take value set name as a paramter.
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
, par.flex_value_set_id
, ffvs.flex_value_set_name
, flv.meaning default_type
, par.DEFAULT_VALUE
FROM fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpl
, fnd_descr_flex_col_usage_vl par
, fnd_flex_value_sets ffvs
, fnd_lookup_values flv
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
--AND fcpl.user_concurrent_program_name = :conc_prg_name
AND ffvs.flex_value_Set_name = :value_set_name
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
AND ffvs.flex_value_set_id = par.flex_value_set_id
AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
AND flv.lookup_code(+) = par.default_type
AND flv.LANGUAGE(+) = USERENV ('LANG')
Thank u Suresh for ur timely reply..
Thanks and Regards,
Venkatesan.R
Hi Suresh,
I have one doubt in payables.
How to create a credit/Debit memo and how to match it with invoice in oracle payables?
its very urgent..
if u have any screenshots regarding the credit/debit memo creation, plz send it to my mail.
my mail id is byvenkat@gmail.com
Waiting for ur reply.
Thanks and Regards,
Venkat
Dear Suresh,
Can we set a profile option values through PL/SQL?
Thanks and Regards,
Venkat
Check fnd_profile.save
I think using this you can set value at any level(site, user, resp, appln)
Thanks,
suresh
Dear Suresh,
Thanks much for ur prompt reply.
Thanks and Regards,
Venkat
Hi Suresh
Excellent info...
I have a one question for you..
How can we have the list of customized concurrent programs in a EBS instance
Now if you have followed standards while creating conc. prg like using custom application and putting your report file in custom directly etc. the list can be achieved by querying fnd_concurrent_programs table against that application.
Hi All,
Thanks...I have one question ..
par.DEFAULT_VALUE and
par.DEFAULT_type is coming null ...
In 11i it is happening...
Post a Comment