ITPub博客

（6）。查找运行请求时间，参数等（可以是某用户的，某个报表）SELECT C.USER_NAME,papf.full_name,B.USER_CONCURRENT_PROGRAM_NAME,A.REQUEST_DATE,A.ARGUMENT_TEXT,(A.ACTUAL_COMPLETION_DATE-A.ACTUAL_START_DATE)*24*60 MINUTES,A.ACTUAL_START_DATE,A.ACTUAL_COMPLETION_DATE,a.request_id,a.outfile_name[@more@]FROM FND_CONCURRENT_REQUESTS A,FND_CONCURRENT_PROGRAMS_VL B,FND_USER C,per_all_people_f papfWHERE A.CONCURRENT_PROGRAM_ID=B.CONCURRENT_PROGRAM_IDAND A.REQUESTED_BY=C.USER_IDand c.user_name=papf.employee_n

(5) /*根据描述性弹性域的标题查找描述性弹性域表和列*/--SELECT FND_DFV.TITLE,FND_DFV.DESCRIPTIVE_FLEXFIELD_NAME ,FND_DFV.APPLICATION_TABLE_NAME ,FND_DFU.APPLICATION_COLUMN_NAME,FND_DFU.FORM_LEFT_PROMPT,FND_DFU.FORM_ABOVE_PROMPT[@more@]FROM FND_DESCRIPTIVE_FLEXS_VL FND_DFV,FND_DESCR_FLEX_COL_USAGE_VL FND_DFUWHERE FND_DFV.TITLE='物料' --如：物料AND FND_DFU.DESCRIPTIVE_FLEXFIELD_NAME=FND_DFV.DESCRIPTIVE_FLEXFIELD_NAME

(4)./* 根据窗口名称查找关键字弹性域用到的表，列等信息*/--SELECT C.ID_FLEX_NAME,A.ID_FLEX_STRUCTURE_NAME,B.FORM_LEFT_PROMPT,C.APPLICATION_TABLE_NAME,B.APPLICATION_COLUMN_NAME,B.FLEX_VALUE_SET_IDFROM FND_ID_FLEX_STRUCTURES_VL A,FND_ID_FLEX_SEGMENTS_VL B,FND_ID_FLEXS CWHERE A.ID_FLEX_STRUCTURE_NAME='帐户别名' --用你自己要查的代替，就是Form窗口的标题AND A.APPLICATION_ID=B.APPLICATION_IDAND A.ID_FLEX_CODE=B.ID_FLEX_CODEAND A.ID_FLEX_NUM=B.ID_FLEX_NUM AND A.APPLICATION_ID=C.APPLICATION_IDAND A.ID_FLEX

(3)./*查找在菜单里提交的报表所在职责*/SELECT A.RESPONSIBILITY_NAME,B.PROMPT,F.USER_CONCURRENT_PROGRAM_NAMEFROM FND_RESPONSIBILITY_VL A,FND_MENU_ENTRIES_VL B,FND_FORM_FUNCTIONS_VL C,FND_REQUEST_GROUPS D,FND_REQUEST_GROUP_UNITS E,FND_CONCURRENT_PROGRAMS_VL FWHERE A.MENU_ID=B.MENU_IDAND B.FUNCTION_ID=C.FUNCTION_IDAND C.PARAMETERS LIKE '%'||D.REQUEST_GROUP_CODE||'%'AND D.APPLICATION_ID=E.APPLICATION_IDAND D.REQUEST_GROUP_ID=E.REQUEST_GROUP_IDAND E.UNIT_APPLICATION_ID=F.APPLICATION_IDAND E.REQUEST_UN

(2)./*查找在标准请求组里提交的报表所在的职责*/SELECT A.RESPONSIBILITY_NAME,B.USER_CONCURRENT_PROGRAM_NAME,B.CONCURRENT_PROGRAM_NAMEFROM FND_RESPONSIBILITY_VL A,FND_CONCURRENT_PROGRAMS_VL B,FND_REQUEST_GROUP_UNITS CWHERE A.APPLICATION_ID=C.APPLICATION_IDAND A.REQUEST_GROUP_ID=C.REQUEST_GROUP_IDAND B.APPLICATION_ID=C.UNIT_APPLICATION_IDAND B.CONCURRENT_PROGRAM_ID=C.REQUEST_UNIT_IDAND B.USER_CONCURRENT_PROGRAM_NAME LIKE '%杂项出入库报表%'[@more@]

下面是我常用的脚本，在做报表，修改报表时很有用（对我是这样），希望能给大家带来帮助--(1)./* 根据报表文件名称关键字查找报表的执行文件名称等信息*/SELECT A.USER_CONCURRENT_PROGRAM_NAME,A.CONCURRENT_PROGRAM_NAME,A.OUTPUT_FILE_TYPE,B.EXECUTION_FILE_NAME,B.EXECUTABLE_NAME,FND_L.MEANING,B.USER_EXECUTABLE_NAME,B.DESCRIPTIONFROM FND_CONCURRENT_PROGRAMS_VL A,fnd_executables_vl B,FND_LOOKUPS FND_LWHERE A.APPLICATION_ID=B.APPLICATION_IDAND A.EXECUTABLE_ID=B.EXECUTABLE_ID AND B.EXECUTION_METHOD_CODE= FND_L.LO