EBS常用SQL总结.docxVIP

Session相关1）查看session状态Pl/Sql developer-tools-sessions2）查看那些表被哪个session锁定SELECT a.object_name, a.object_type, v.session_idFROM all_objects a, v$locked_object vWHERE v.object_id = a.object_id;查找配置文件select t.PROFILE_OPTION_NAME,a.application_name ,t.USER_PROFILE_OPTION_NAME,T.DESCRIPTIONfrom FND_PROFILE_OPTIONS_VL t, fnd_application_tl awhere1=1--AND t.PROFILE_OPTION_NAME like %ZZOM207%and t.APPLICATION_ID=a.application_idand a.language=ZHS;请求相关1）查找所有请求对应的职责SELECT FRTL.RESPONSIBILITY_NAME, PRO.USER_CONCURRENT_PROGRAM_NAME, PROS.CONCURRENT_PROGRAM_NAMEFROM FND_RESPONSIBILITY_TL FRTL, FND_RESPONSIBILITY FR, FND_REQUEST_GROUP_UNITS REQ, FND_CONCURRENT_PROGRAMS_TL PRO, FND_CONCURRENT_PROGRAMS PROSWHERE FRTL.RESPONSIBILITY_ID = FR.RESPONSIBILITY_IDAND FRTL.APPLICATION_ID = FR.APPLICATION_IDAND FRTL.LANGUAGE = ZHSAND FR.REQUEST_GROUP_ID = REQ.REQUEST_GROUP_IDAND REQ.REQUEST_UNIT_ID = PRO.CONCURRENT_PROGRAM_IDAND PRO.CONCURRENT_PROGRAM_ID = PROS.CONCURRENT_PROGRAM_IDAND PRO.USER_CONCURRENT_PROGRAM_NAME LIKE%IES 总括请求书传送至海外%2）查找已提交请求相关信息SELECT T.REQUEST_ID, T.REQUEST_DATE, T.REQUESTED_BY, FRTL.RESPONSIBILITY_NAME, t.outfile_name, pro.user_concurrent_program_name, pros.concurrent_program_nameFROM FND_CONCURRENT_REQUESTS T, FND_RESPONSIBILITY_TL FRTL, FND_CONCURRENT_PROGRAMS_TL PRO, fnd_concurrent_programs prosWHERE T.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_IDAND T.CONCURRENT_PROGRAM_ID = PRO.CONCURRENT_PROGRAM_IDAND pro.concurrent_program_id=pros.concurrent_program_idAND pro.language=ZHS--AND t.request_id=3897869--AND PRO.USER_CONCURRENT_PROGRAM_NAME LIKE %STD 供应商帐龄报表%AND pros.concurrent_program_name=ZZAPGML010CANDROWNUM 10SELECT t.request_id 请求ID ,t.request_date 请求时间 ,frtl.responsibility_name 职责 ,t.outfile_name 输出文件路径 ,pro.user_concurrent_program_name 报表名 ,pros.concurrent_program_name 可执行名FROM fnd_concurrent_request