ORACLE EBS中查找所有客制化并发程序

SELECT fcpv.user_concurrent_program_name 程序,

fcpv.concurrent_program_name 简称,

fcpv.description 说明,

'*************' 可执行并发程序,

fefv.executable_name 可执行名称,

fefv.user_executable_name 简称,

fefv.application_name 应用产品,

fefv.description 说明,

fefv.execution_file_name 执行文件名,

fdfcuv.end_user_column_name 参数,

(SELECT ffvs.flex_value_set_name

FROM fnd_flex_value_sets ffvs

WHERE 1 = 1

AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id) 值集,

fdfcuv.default_value 默认值,

fdfcuv.description 说明,

fdfcuv.form_left_prompt 提示,

fdfcuv.srw_param 变量

FROM fnd_concurrent_programs_vl fcpv,

fnd_executables_form_v fefv,

fnd_descr_flex_col_usage_vl fdfcuv

WHERE 1 = 1

AND fcpv.executable_id = fefv.executable_id

AND fcpv.concurrent_program_name =

substr(fdfcuv.descriptive_flexfield_name, 7)

AND fcpv.user_concurrent_program_name like '%CUX%';

最后

以上就是动人心情为你收集整理的ORACLE EBS中查找所有客制化并发程序的全部内容，希望文章能够帮你解决ORACLE EBS中查找所有客制化并发程序所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。