资源描述：
《oracle的报表的典型sql语句》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、www.xuancheng.org66oracle的报表的典型sql语句SelectLEAD(m.app_no,(SelectCount(1)Fromapp_mtfeatureWhereapp_no='04')-1,'')over(OrderBym.app_no)appno,m.feature_seq
2、
3、''feature_seq,m.month
4、
5、''month,m.pointfee,m.discountFromapp_mtfeaturemWherem.app_no='04'UnionAllSelect'','合计','',Sum(pointfee),Sum(discount)Fr
6、omapp_mtfeatureWhereapp_no='04'UnionAllSelectLEAD(m.app_no,(SelectCount(1)Fromapp_mtfeatureWhereapp_no='06')-1,'')over(OrderBym.app_no)appno,m.feature_seq
7、
8、'',m.month
9、
10、'',m.pointfee,m.discountFromapp_mtfeaturemWherem.app_no='06'UnionAllSelect'','合计','',Sum(pointfee),Sum(discount)Fromapp_mtfeatu
11、reWhereapp_no='06'zxbxiaobo@sina.compwd:xiaobo看看首项，第二项效果怎么样!http://xiaobo.javaeye.com/blog/34094一些开发脚本(1)./*根据报表文件名称关键字查找报表的执行文件名称等信息*/SELECTA.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
12、.DESCRIPTIONFROMFND_CONCURRENT_PROGRAMS_VLA,fnd_executables_vlB,FND_LOOKUPSFND_LWHEREA.APPLICATION_ID=B.APPLICATION_IDANDA.EXECUTABLE_ID=B.EXECUTABLE_IDANDB.EXECUTION_METHOD_CODE=FND_L.LOOKUP_CODE(+)ANDFND_L.LOOKUP_TYPE='CP_EXECUTION_METHOD_CODE'www.xuancheng.org66ANDA.USER_CONCURRENT_PROGRAM_N
13、AMELIKE'C%杂项出入库报表%'(2)./*查找在标准请求组里提交的报表所在的职责*/SELECTA.RESPONSIBILITY_NAME,B.USER_CONCURRENT_PROGRAM_NAME,B.CONCURRENT_PROGRAM_NAMEFROMFND_RESPONSIBILITY_VLA,FND_CONCURRENT_PROGRAMS_VLB,FND_REQUEST_GROUP_UNITSCWHEREA.APPLICATION_ID=C.APPLICATION_IDANDA.REQUEST_GROUP_ID=C.REQUEST_GROUP_IDANDB.APP
14、LICATION_ID=C.UNIT_APPLICATION_IDANDB.CONCURRENT_PROGRAM_ID=C.REQUEST_UNIT_IDANDB.USER_CONCURRENT_PROGRAM_NAMELIKE'%杂项出入库报表%'(3)./*查找在菜单里提交的报表所在职责*/SELECTA.RESPONSIBILITY_NAME,B.PROMPT,F.USER_CONCURRENT_PROGRAM_NAMEFROMFND_RESPONSIBILITY_VLA,FND_MENU_ENTRIES_VLB,FND_FORM_FUNCTIONS_VLC,FND_REQUE
15、ST_GROUPSD,FND_REQUEST_GROUP_UNITSE,FND_CONCURRENT_PROGRAMS_VLFWHEREA.MENU_ID=B.MENU_IDANDB.FUNCTION_ID=C.FUNCTION_IDANDC.PARAMETERSLIKE'%'
16、
17、D.REQUEST_GROUP_CODE
18、
19、'%'ANDD.APPLICATION_ID=E.APPLICATION_IDANDD.REQUEST_GROUP_ID=E.REQU
