摘要：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 阅读全文

摘要：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 阅读全文

摘要：--R12查询EBS在线用户SQL SELECT U.USER_NAME, APP.APPLICATION_SHORT_NAME, FAT.APPLICATION_NAME, FR.RESPONSIBILITY_KEY, FRT.RESPONSIBILITY_NAME, FFF.FUNCTION_N 阅读全文

摘要：--查找运行请求时间，参数等（可以是某用户的，某个报表） select c.user_name, papf.full_name, b.user_concurrent_program_name, a.request_date, a.argument_text, (a.actual_completion 阅读全文

摘要：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 阅读全文