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
Below query can be used to get concurrent program name and its parameter.
Recent Comments
- Sachin on What is Profile Options?
- Shiva on About
- Sudhanshu Mishra on Oracle E-Business Suite 12 Free Vision Instance
- THOMSON ALEXANDER on How to Insert Attachments in R12 Using API
- Kirtiwardhan on Attachment in Oracle Application
Latest Posts
- R12 – How to Delete Oracle AR TransactionsMarch 22, 2019 - 8:37 pm
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
- How to Find Duplicate Row in OAF Page?April 26, 2017 - 5:17 pm
Leave a Reply
Want to join the discussion?Feel free to contribute!