Search This Blog

Tuesday, March 10, 2009

Concurrent Program Name with Parameter, Value set

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:

Unknown said...

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

Unknown said...

Hi.. my mail id is ,


byvenkat@gmail.com

Thanks and Regards,
Venkatesan.R

Suresh Vaishya said...

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')

Unknown said...

Thank u Suresh for ur timely reply..

Thanks and Regards,
Venkatesan.R

Unknown said...

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

Unknown said...

Dear Suresh,

Can we set a profile option values through PL/SQL?

Thanks and Regards,
Venkat

Suresh Vaishya said...

Check fnd_profile.save

I think using this you can set value at any level(site, user, resp, appln)

Thanks,
suresh

Unknown said...

Dear Suresh,

Thanks much for ur prompt reply.

Thanks and Regards,
Venkat

Some one called Dasaradhi said...

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

Suresh Vaishya said...

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.

Anonymous said...

Hi All,

Thanks...I have one question ..
par.DEFAULT_VALUE and
par.DEFAULT_type is coming null ...

In 11i it is happening...

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