--How to use script to get all oracle EBS Form name and corresponding fmb file name . SELECT fff.function_name , ff.form_name , ffft.user_function_name , fff.function_id , ff.form_id , fff.application_id FROM fnd_form ff , fnd_form_functions fff , fnd_form_functions_tl ffft WHERE 1 = 1 AND ff.form_id = fff.form_id AND fff.function_id = ffft.function_id AND ffft.language = 'US' AND fff.application_id = 401 --Inventory Module ORDER BY ffft.user_function_name; --How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution f . SELECT fcp.concurrent_program_name , fcpt.user_concurrent_program_name , fcp.execution_method_code , flv.meaning FROM fnd_concurrent_programs fcp , fnd_concurrent_programs_tl fcpt , fnd_lookup_values flv WHERE 1 = 1 AND fcp.concurrent_program_id = fcpt.concurrent_program_id AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE' AND fcp.execution_method_code = flv.lookup_code AND fcpt.language = 'US' AND flv.language = 'US' AND fcp.application_id = 401 --Inventory Module ORDER BY fcpt.user_concurrent_program_name;
EBS SQL --> Form & Report
原创QUANWEIRU 博主文章分类:Oracle EBS ©著作权
©著作权归作者所有:来自51CTO博客作者QUANWEIRU的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Odoo集合pdfjs实现在form表单上预览附件
Odoo集成pdfjs实现预览附件
字段 html HTML odoo -
EBS FORM开发步骤
EBS FORM开发步骤(step by step)
FORM EBS 开发步骤 -
EBS Form开发总结(1)
1、FORM中调用请求示例:Form 中调用并发请求生成报表并输出PDF的方法。要完成这个目的,首先要在ebs中注册报表,并注册模板。然后
application date hierarchy query layout