科尔尼-中国银行—BOC Key Success Factors v4.doc
《科尔尼-中国银行—BOC Key Success Factors v4.doc》由会员分享,可在线阅读,更多相关《科尔尼-中国银行—BOC Key Success Factors v4.doc(4页珍藏版)》请在文库网上搜索。
1、(屬尀錀耀$坝(漬帀言$坟(珜怀謀$坡礶(瘴戀錀鐀$坣礙(趤攀鴀$坤(钬昀$坧(栀渀$坩(樀$坫(氀帀$坭(渀$坯(瀀稀$坱礢(爀$坳(琀$坵(瘀$坷礹(砀瘀$坹示(稀洀$坻礢(簀挀$坽(縀渀$坿礻(耀蠀$垁(舀$垃礽(萀$垅礿(括蘀瀀$垇(晰蠀錀$垉礴(欠言猀砀$型?(盘谀唀$垍(耸踀謀$垏(贜退$垑(鱘鈀堀$垓(鱘鐀堀$垕祂(鶄阀萀$垗(鶄頀$垙祄(騀謀嘀$垛(鰀吀$垝(鸀嘀頀$垟祆(吀$垡祈(挀$垣(一/帀琀$垥(昀$垧祋(踀昀$垩祌(猀$垫(瘀尀$垭(笀蠀$垯祎(伀簀$垱祐(蜀脀$垳(儀蜀$垵祒(踀蜀氀$垷祓(蠀氀$垹祔(謀$垻祕(嘀踀$垽(鐀退栀$垿(需$埁(鸀瀀$埃祗(需鰀$埅祘(
2、踀$埇祙(灴娀琀$埉(睼P堀$埋(羰$埍(羰渀$埏祛($埑寬(尀$埓?(戀%$埕($埗(崀$埙神(釨$埛(魈$埝(欀$域(开$埡祠(愀琀$埣($埥(戀$埧祣(踀$埩常(隴$埫(怀$埭(蘀蠀$埯(砀$埱祤(藄攀$埳(昀退$埵尷(渀$埶(伀$培(最倀瀀$埻(瀤洀开$埽(氀搀琀$埿(栀瘀鐀$堀祩(瘀鐀$堃(蔀$堅(蠀$堇(谀$堉(圀鴀$堋(樀$堍m(斴欀$堏祬(躸鴀砀$堑(洀$堓m(洀$堕($堗(洀$堙(蔀尀$堛m(渀$堝祯(瀀$堟(create or replace package PL_YUAN_101102_CXCPZB isTYPE my_Cursor IS REF CURSOR;proce
3、dure GetYieldInfo( p_KSNY varchar, p_JSNY varchar, p_num float, p_ReCursor0 out my_Cursor -p_ReCursor1 out my_Cursor, -p_ReCursor2 out my_Cursor);end PL_YUAN_101102_CXCPZB;create or replace package body PL_YUAN_101102_CXCPZB isprocedure GetYieldInfo( p_KSNY varchar, p_JSNY varchar, p_num float, p_Re
4、Cursor0 out my_Cursor -p_ReCursor1 out my_Cursor, -p_ReCursor2 out my_Cursor)is i_SqlText varchar(4000);beginDELETE FROM TEMP_YUAN_101102_CXCPZB ;INSERT INTO TEMP_YUAN_101102_CXCPZB (F_XH,F_CPZB,F_DW,F_NY,F_YSL)(select 1,b.prodny,count(*) from PL_Bill a,PL_Bill_Ferment b where a.BillState=03and a.Wo
5、rkshopID =ddc8e52a-1c9d-471d-8968-30e09fbba101 and a.stationid in(c2e479fe-fb49-4a33-8437-3896230d0b91,e142f4b3-9594-47f2-8b2a-4068137f2a35,d37a8b0a-15ed-4701-bf7a-bfe4b02e2eed) and b.prodny between p_KSNY and p_JSNY and a.billid=b.billid GROUP BY b.prodny);UPDATE TEMP_YUAN_101102_CXCPZB SET F_NLJ=(
6、SELECT COUNT(*) FROM PL_Bill a,PL_Bill_Ferment b where a.BillState=03and a.WorkshopID =ddc8e52a-1c9d-471d-8968-30e09fbba101 and a.stationid in(c2e479fe-fb49-4a33-8437-3896230d0b91,e142f4b3-9594-47f2-8b2a-4068137f2a35,d37a8b0a-15ed-4701-bf7a-bfe4b02e2eed) and a.billid=b.billidAND b.prodny BETWEEN SUB
7、STRING(F_NY,1,4)|01 AND F_NY)WHERE F_CPZB=;-INSERT INTO TEMP_YUAN_101102_CXCPZB (F_XH,F_CPZB,F_DW,F_NY)(select 2,F_NY FROM TEMP_YUAN_101102_CXCPZB WHERE F_CPZB=);UPDATE TEMP_YUAN_101102_CXCPZB SET F_YSL=(select count(*) from PL_Bill a,PL_Bill_Ferment b where a.WorkshopID =ddc8e52a-1c9d-471d-8968-30e
8、09fbba101 and a.stationid in(c2e479fe-fb49-4a33-8437-3896230d0b91,e142f4b3-9594-47f2-8b2a-4068137f2a35,d37a8b0a-15ed-4701-bf7a-bfe4b02e2eed)and b.prodny=F_NY and a.BillState=03and a.billid=b.billid and b.OutKettleUnit=p_num)WHERE F_CPZB=;UPDATE TEMP_YUAN_101102_CXCPZB SET F_NLJ=(SELECT COUNT(*) FROM
9、 PL_Bill a,PL_Bill_Ferment b where a.BillState=03and a.WorkshopID =ddc8e52a-1c9d-471d-8968-30e09fbba101 and a.stationid in(c2e479fe-fb49-4a33-8437-3896230d0b91,e142f4b3-9594-47f2-8b2a-4068137f2a35,d37a8b0a-15ed-4701-bf7a-bfe4b02e2eed) and a.billid=b.billid AND b.prodny BETWEEN SUBSTRING(F_NY,1,4)|01
- 1.请仔细阅读文档,确保文档完整性,对于不预览、不比对内容而直接下载带来的问题本站不予受理。
- 2.下载的文档,不会出现我们的网址水印。
- 3、该文档所得收入(下载+内容+预览)归上传者、原创作者;如果您是本文档原作者,请点此认领!既往收益都归您。
下载文档到电脑,查找使用更方便
30 文币 0人已下载
下载 | 加入VIP,免费下载 |
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 科尔尼中国银行BOC Key Success Factors v4 科尔尼 中国银行 BOC