资源描述:
《EBS常用SQL总结》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Session相关1)查看session状态Pl/Sqldeveloper->tools->sessions2)查看那些表被哪个session锁定SELECTa.object_name,a.object_type,v.session_idFROMall_objectsa,v$locked_objectvWHEREv.object_id=a.object_id;查找配置文件selectt.PROFILE_OPTION_NAME,a.application_name,t.USER_PROFILE_OPTION_NAME,T.DESCRIPT
2、IONfromFND_PROFILE_OPTIONS_VLt,fnd_application_tlawhere1=1--ANDt.PROFILE_OPTION_NAMElike'%ZZOM207%'andt.APPLICATION_ID=a.application_idanda.language='ZHS';请求相关1)查找所有请求对应的职责SELECTFRTL.RESPONSIBILITY_NAME,PRO.USER_CONCURRENT_PROGRAM_NAME,PROS.CONCURRENT_PROGRAM_NAMEFROMFND
3、_RESPONSIBILITY_TLFRTL,FND_RESPONSIBILITYFR,FND_REQUEST_GROUP_UNITSREQ,FND_CONCURRENT_PROGRAMS_TLPRO,FND_CONCURRENT_PROGRAMSPROSWHEREFRTL.RESPONSIBILITY_ID=FR.RESPONSIBILITY_IDANDFRTL.APPLICATION_ID=FR.APPLICATION_IDANDFRTL.LANGUAGE='ZHS'ANDFR.REQUEST_GROUP_ID=REQ.REQUES
4、T_GROUP_IDANDREQ.REQUEST_UNIT_ID=PRO.CONCURRENT_PROGRAM_IDANDPRO.CONCURRENT_PROGRAM_ID=PROS.CONCURRENT_PROGRAM_IDANDPRO.USER_CONCURRENT_PROGRAM_NAMELIKE'%IES总括请求书传送至海外%'2)查找已提交请求相关信息SELECTT.REQUEST_ID,T.REQUEST_DATE,T.REQUESTED_BY,FRTL.RESPONSIBILITY_NAME,t.outfile_name,
5、pro.user_concurrent_program_name,pros.concurrent_program_nameFROMFND_CONCURRENT_REQUESTST,FND_RESPONSIBILITY_TLFRTL,FND_CONCURRENT_PROGRAMS_TLPRO,fnd_concurrent_programsprosWHERET.RESPONSIBILITY_ID=FRTL.RESPONSIBILITY_IDANDT.CONCURRENT_PROGRAM_ID=PRO.CONCURRENT_PROGRAM_I
6、DANDpro.concurrent_program_id=pros.concurrent_program_idANDpro.language='ZHS'--ANDt.request_id=3897869--ANDPRO.USER_CONCURRENT_PROGRAM_NAMELIKE'%STD供应商帐龄报表%'ANDpros.concurrent_program_name='ZZAPGML010C'ANDROWNUM<10SELECTt.request_id"请求ID",t.request_date"请求时间",frtl.respon
7、sibility_name"职责",t.outfile_name"输出文件路径",pro.user_concurrent_program_name"报表名",pros.concurrent_program_name"可执行名"FROMfnd_concurrent_requestst,fnd_responsibility_tlfrtl,fnd_concurrent_programs_tlpro,fnd_concurrent_programsprosWHEREt.responsibility_id=frtl.responsibility_i
8、dANDt.concurrent_program_id=pro.concurrent_program_idANDpro.concurrent_program_id=pros.concurrent_progr