随笔分类 -  Oracle EBS-SQL (SYS)

1 2 下一页

Oracle EBS-SQL (SYS-24):职责列表
摘要:select B.application_name, TL.responsibility_name from fnd_responsibility_tl tl, fnd_responsibility a, fnd_application_tl B, fnd_application Cwhere a.... 阅读全文

posted @ 2014-06-09 15:48 st.sun 编辑

Oracle EBS-SQL (SYS-23):用户权限查询.sql
摘要:select b.user_name, b.description, b.creation_date, d.responsibility_name from fnd_user b, fnd_user_resp_groups c, fnd_responsibility_tl d where b.... 阅读全文

posted @ 2014-06-09 15:43 st.sun 编辑

Oracle EBS-SQL (SYS-22):sysadmin_用户职责查询.sql
摘要:select fu.user_name 用户名, fu.description 用户说明, frv.RESPONSIBILITY_NAME 职责名称, REQUEST_GROUP_NAME 报表组, (select ppf.FULL_NAME from apps.per_people_f ppf w... 阅读全文

posted @ 2014-06-09 15:38 st.sun 编辑

Oracle EBS-SQL (SYS-21):sys_用户名与人员对应关系查询.sql
摘要:select fu.user_name 用户名, fu.description 描述, (select ppf.FULL_NAME from per_people_f ppf where ppf.PERSON_ID = fu.employee_id and trunc(sysdate) bet... 阅读全文

posted @ 2014-06-09 15:34 st.sun 编辑

Oracle EBS-SQL (SYS-20):职责使用菜单2.sql
摘要:select frt.responsibility_name, fr.menu_id, fm.menu_name, fr.request_group_id, frg.request_group_namefrom fnd_responsibility fr, fnd_responsibility_... 阅读全文

posted @ 2014-06-09 15:29 st.sun 编辑

Oracle EBS-SQL (SYS-20):OPM接口处理.sql
摘要:/* 未加工的材料交易(必须解决)UNcosted Transactions (must resolve) 无成本的交易(必须解决)Pending WIP costing transactions (must resolve) 等待在制品成本交易(必须解决)UNcosted WSM transact... 阅读全文

posted @ 2014-06-09 15:24 st.sun 编辑

Oracle EBS-SQL (SYS-19):sys-用户登陆纪录查询.sql
摘要:select * from fnd_user t where t.user_name='user_name' 阅读全文

posted @ 2014-06-09 15:22 st.sun 编辑

Oracle EBS-SQL (SYS-18):检查系统安装的各个表是否打开(PJM%).sql
摘要:select status,trigger_namefrom all_triggerswhere trigger_name like 'PJM%';ALTER TRIGGER PJM_ORG_PARAMETERS_BRIU ENABLE; 阅读全文

posted @ 2014-06-09 15:20 st.sun 编辑

Oracle EBS-SQL (SYS-17):查询一张报表在哪个职责下面.sql
摘要:1.查询该报表的 concurrent_program_id SQL如下: SELECT t.application_id, t.concurrent_program_id, t.* FROM FND_CONCURRENT_PROGRAMS_TL T WHERE T.USER_CONCURRENT_... 阅读全文

posted @ 2014-06-09 14:36 st.sun 编辑

Oracle EBS-SQL (SYS-16):查询密码.sql
该文被密码保护。

posted @ 2014-06-09 14:34 st.sun 阅读(0) 评论(0) 推荐(0) 编辑

Oracle EBS-SQL (SYS-15):查询表空间2.sql
摘要:/*表空间查询*/SELECT d.status "状态", d.tablespace_name "名称", d.contents "类型", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99G999G990D900') "大小 (M)", TO_CHAR(NVL(... 阅读全文

posted @ 2014-06-09 14:25 st.sun 编辑

Oracle EBS-SQL (SYS-14):查询表空间1.sql
摘要:SELECT d.status "状态",d.tablespace_name "名称", d.contents "类型", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99G999G990D900') "大小 (M)", TO_CHAR(NVL(a.bytes - ... 阅读全文

posted @ 2014-06-09 14:20 st.sun 编辑

Oracle EBS-SQL (SYS-13):查询DBA在系统中的打Patch的信息.SQL
摘要:查询DBA在系统中的打补丁信息1. select * from ad_patch_drivers /*查看已经打了哪些Patch*/2. select * from ad_patch_runs/*查看打patch的时间,目录等信息*/3. select * from ad_patch_driver_... 阅读全文

posted @ 2014-06-09 11:59 st.sun 编辑

Oracle EBS-SQL (SYS-12):查询各Profile的设置情况.sql
摘要:SELECT pro.profile_option_name, pro.user_profile_option_name, lev.level_type TYPE, --lev.level_code, lev.level_name, prv.profile_option_valueFROM apps... 阅读全文

posted @ 2014-06-09 11:56 st.sun 编辑

Oracle EBS-SQL (SYS-11):查询系统已打的PATCH.sql
摘要:select a.patch_name, b.DRIVER_FILE_NAME, c.language, b.creation_datefrom apps.ad_applied_patches a, apps.ad_patch_drivers b, apps.ad_patch_driver_lang... 阅读全文

posted @ 2014-06-09 11:50 st.sun 编辑

Oracle EBS-SQL (SYS-10):锁定表查询.sql
摘要:/*死锁查询-1*/SELECT o.object_name, l.session_id,l.process,l.locked_mode FROM v$locked_object l , dba_objects o WHEREo.object_id=l.object_id--------------... 阅读全文

posted @ 2014-06-09 11:45 st.sun 编辑

Oracle EBS-SQL (SYS-9):职责使用菜单.sql
摘要:select aa.menu_name, aa.user_menu_name, aa.type, aa.description, aa.ENTRY_SEQUENCE, aa.prompt, aa.sub_user_menu_name, aa.user_function_name, aa.des... 阅读全文

posted @ 2014-06-09 11:39 st.sun 编辑

Oracle EBS-SQL (SYS-8):职责定义明细.sql
摘要:SELECT DISTINCT fa.application_short_name 模块, b.responsibility_name 职责名称, fa.application_name 应用产品, b.responsibility_key 责任关键字, b.description 说明, D... 阅读全文

posted @ 2014-06-09 11:38 st.sun 编辑

Oracle EBS-SQL (SYS-7):表单个性化查询.sql
摘要:SELECT * FROM FND_FORM_CUSTOM_RULES;SELECT * FROM FND_FORM_CUSTOM_ACTIONS;SELECT * FROM FND_FORM_CUSTOM_PARAMS;SELECT * FROM FND_FORM_CUSTOM_SCOPES;se... 阅读全文

posted @ 2014-06-09 11:36 st.sun 编辑

Oracle EBS-SQL (SYS-6):sys_在线用户职责查询.sql
摘要:/*线用户查询-1*/SELECT FSAV.USER_NAME,FU.DESCRIPTION,FSAV.RESPONSIBILITY_NAME,FSAV.USER_FORM_NAME,FSAV.LOGIN_NAME,FSAV.TIME,FSAV.PID,FSAV.TERMINAL_ID,FSAV.... 阅读全文

posted @ 2014-06-09 11:30 st.sun 编辑

1 2 下一页

导航

点击右上角即可分享
微信分享提示