随笔分类 -  EBS 开发

摘要:select rt.name, hcas.org_id from ar.hz_cust_acct_sites_all hcas, ar.hz_cust_site_uses_all hcsu, ra_terms_vl rt where 1 = 1 and hcas.status = 'A' and h 阅读全文
posted @ 2020-06-01 08:08 游兮游兮 阅读(311) 评论(0) 推荐(0)
摘要:select pro.profile_option_name, pro.user_profile_option_name, lev.level_type type, --lev.level_code, lev.level_name, prv.profile_option_value from app 阅读全文
posted @ 2020-05-31 22:17 游兮游兮 阅读(122) 评论(0) 推荐(0)
摘要:--R12查询EBS在线用户SQL SELECT U.USER_NAME, APP.APPLICATION_SHORT_NAME, FAT.APPLICATION_NAME, FR.RESPONSIBILITY_KEY, FRT.RESPONSIBILITY_NAME, FFF.FUNCTION_N 阅读全文
posted @ 2020-05-31 22:17 游兮游兮 阅读(138) 评论(0) 推荐(0)
摘要:--查找运行请求时间,参数等(可以是某用户的,某个报表) select c.user_name, papf.full_name, b.user_concurrent_program_name, a.request_date, a.argument_text, (a.actual_completion 阅读全文
posted @ 2020-05-31 22:17 游兮游兮 阅读(184) 评论(0) 推荐(0)
摘要:SELECT gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id, 1, gcc.segment1) || '-' || gl_flexfields_pkg.get_description_sql(gcc.chart_of_a 阅读全文
posted @ 2020-05-31 22:16 游兮游兮 阅读(133) 评论(0) 推荐(0)