SQL Id | SQL Text |
04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
07pbq5wpv71sy | SELECT NFSN_FUNC_001(NULL, :B5 , :B4 , :B3 , :B2 , :B1 ) FROM DUAL |
0h2vakcbv7d3m | SELECT USER_ID FROM ALL_USERS WHERE USERNAME = :B1 |
0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0q9gk89y5bhcy |
insert into ic_general_b ( bbarcodeclose, bonroadflag, breturnprofit, bsafeprice, bsourcelargess, bsupplyflag, btoinzgflag, btoouttoiaflag, btooutzgflag, btou8rm, bzgflag, castunitid, cbodybilltypecode, cbodywarehouseid, ccheckstateid, ccorrespondbid, ccorrespondcode, ccorrespondhid, ccorrespondtype, ccostobject, cfirstbillbid, cfirstbillhid, cfirsttype, cfreezeid, cgeneralbid, cgeneralhid, cinvbasid, cinventoryid, corder_bb1id, cparentid, cprojectid, cprojectphaseid, cquotecurrency, cquoteunitid, creceieveid, creceiveareaid, creceivepointid, crowno, cselastunitid, csignwastbid, csignwasthid, csignwasttype, csourcebillbid, csourcebillhid, csourcetype, csourcewastbid, csourcewasthid, csourcewasttype, csrc2billbid, csrc2billhid, csrc2billtype, csumid, cvendorid, cworkcenterid, cworksiteid, cwp, dbizdate, ddeliverdate, dfirstbilldate, drequiredate, drequiretime, dstandbydate, dzgdate, fbillrowflag, fchecked, flargess, ftoouttransflag, hsl, idesatype, isok, naccumtonum, naccumwastnum, nbarcodenum, ncorrespondastnum, ncorrespondgrsnum, ncorrespondnum, ncountnum, nfeesettletimes, ninassistnum, ningrossnum, ninnum, nkdnum, nmny, nneedinassistnum, noutassistnum, noutgrossnum, noutnum, nplannedmny, nplannedprice, nprice, npricesettlebill, nquotemny, nquotentmny, nquotentprice, nquoteprice, nquoteunitnum, nquoteunitrate, nreplenishedastnum, nreplenishednum, nretastnum, nretnum, nsalemny
, nsaleprice, nshouldinnum, nshouldoutassistnum, nshouldoutnum, ntarenum, ntaxmny, ntaxprice, ntranoutastnum, ntranoutnum, pk_bodycalbody, pk_corp, pk_creqwareid, pk_cubasdoc, pk_defdoc1, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17, pk_defdoc18, pk_defdoc19, pk_defdoc2, pk_defdoc20, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9, pk_invoicecorp, pk_measware, pk_packsort, pk_reqcorp, pk_reqstoorg, pk_returnreason, vbatchcode, vbilltypeu8rm, vbodynote2, vcorrespondrowno, vfirstbillcode, vfirstrowno, vfree1, vfree10, vfree2, vfree3, vfree4, vfree5, vfree6, vfree7, vfree8, vfree9, vnotebody, vproductbatch, vreceiveaddress, vsignwastcode, vsignwastrowno, vsourcebillcode, vsourcerowno, vsourcewastcode, vsourcewastrowno, vsrc2billcode, vsrc2billrowno, vtransfercode, vuserdef1, vuserdef10, vuserdef11, vuserdef12, vuserdef13, vuserdef14, vuserdef15, vuserdef16, vuserdef17, vuserdef18, vuserdef19, vuserdef2, vuserdef20, vuserdef3, vuserdef4, vuserdef5, vuserdef6, vuserdef7, vuserdef8, vuserdef9, vvehiclecode , ts) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50
, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190 , '2013-12-09 10:59:25') |
0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
0x6br9hgbj9y5 |
SELECT NVL(SUM(PRIMAL_AMOUNT), 0) FROM ( SELECT SUM(PRIMAL_AMOUNT) PRIMAL_AMOUNT FROM (SELECT PK_ACCOUNT, PK_CURRTYPE PK_CURRTYPE, INIT_PRIMAL PRIMAL_AMOUNT, INIT_LOCAL LOCAL_AMOUNT, INIT_FRAC FRAC_AMOUNT FROM CMP_INITDATA WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_MNGACCOUNT IS NULL AND FORMCODE = 1 AND AUDITING_DATE <=:B1 UNION ALL SELECT PK_ACCOUNT, PK_CURRTYPE PK_CURRTYPE, SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT, SUM(GATHERINGLOCAL) - SUM(PAYLOCAL) LOCAL_AMOUNT, SUM(GATHERINGFRAC) - SUM(PAYFRAC) FRAC_AMOUNT FROM CMP_TALLYYEARLY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND FUNDFORMCODE = 1 AND CYEAR IS NOT NULL AND CYEAR <:B3 AND FUNDFORMCODE <= 2 GROUP BY PK_CURRTYPE, PK_ACCOUNT UNION ALL SELECT PK_ACCOUNT, PK_CURRTYPE PK_CURRTYPE, SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT, SUM(GATHERINGLOCAL) - SUM(PAYLOCAL) LOCAL_AMOUNT, SUM(GATHERINGFRAC) - SUM(PAYFRAC) FRAC_AMOUNT FROM CMP_TALLYMENSAL WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND FUNDFORMCODE = 1 AND CYEAR = :B3 AND CMONTH < :B4 AND FUNDFORMCODE <= 2 GROUP BY PK_CURRTYPE, PK_ACCOUNT UNION ALL SELECT PK_ACCOUNT, PK_CURRTYPE PK_CURRTYPE, SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT, SUM(GATHERINGLOCAL) - SUM(PAYLOCAL) LOCAL_AMOUNT, SUM(GATHERINGFRAC) - SUM(PAYFRAC) FRAC_AMOUNT FROM CMP_TALLYDAILY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND FUNDFORMCODE = 1 AND CYEAR = :B3 AND CMONTH = :B4 AND DAY < :B1 AND FUNDFORMCODE <= 2 GROUP BY PK_CURRTYPE, PK_ACCOUNT) UT WHERE (PRIMAL
_AMOUNT <> 0 OR LOCAL_AMOUNT <> 0) AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS B, BD_BANKTYPE T WHERE ACCOUNTCODE LIKE '%001' AND B.PK_BANKTYPE = T.PK_BANKTYPE AND T.BANKTYPENAME = '×ʽð×éÖ¯' AND B.PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND NVL(B.DR, 0) = 0 AND NVL(T.DR, 0) = 0) GROUP BY UT.PK_CURRTYPE) |
0zht1pujthavs | SELECT hostID, ip, port, servername, activetime, activeStatus, loadWeight FROM qdi_host ORDER BY activetime desc |
10u35nm4prs0p | select pk_busiclass, pk_corp, pk_billtype, actiontype, pk_businesstype, isbefore, classname, ts, dr from pub_busiclass where isbefore = :1 and pk_billtype = :2 and actiontype = :3 and pk_businesstype = :4 |
1bph5g603jg2k | select 1 from sm_createcorp t1, sm_codetocode t2 where t1.pk_corp = :1 and t2.pk_codetocode = :2 and t1.funccode = t2.funccode |
1twg5kk5w8uqq | select a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where ( checkman = :1 and a.type in ( 0, 10 ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc |
2hzd2sxpmj4mx | SELECT NFSN_FUNC_002(NULL, :B5 , :B4 , :B3 , :B2 , :B1 ) FROM DUAL |
2v0xb556xfwdk |
insert into ic_general_b ( bbarcodeclose, bonroadflag, breturnprofit, bsafeprice, bsourcelargess, bsupplyflag, btoinzgflag, btoouttoiaflag, btooutzgflag, btou8rm, bzgflag, castunitid, cbodybilltypecode, cbodywarehouseid, ccheckstateid, ccorrespondbid, ccorrespondcode, ccorrespondhid, ccorrespondtype, ccostobject, cfirstbillbid, cfirstbillhid, cfirsttype, cfreezeid, cgeneralbid, cgeneralhid, cinvbasid, cinventoryid, corder_bb1id, cparentid, cprojectid, cprojectphaseid, cquotecurrency, cquoteunitid, creceieveid, creceiveareaid, creceivepointid, crowno, cselastunitid, csignwastbid, csignwasthid, csignwasttype, csourcebillbid, csourcebillhid, csourcetype, csourcewastbid, csourcewasthid, csourcewasttype, csrc2billbid, csrc2billhid, csrc2billtype, csumid, cvendorid, cworkcenterid, cworksiteid, cwp, dbizdate, ddeliverdate, dfirstbilldate, drequiredate, drequiretime, dstandbydate, dzgdate, fbillrowflag, fchecked, flargess, ftoouttransflag, hsl, idesatype, isok, naccumtonum, naccumwastnum, nbarcodenum, ncorrespondastnum, ncorrespondgrsnum, ncorrespondnum, ncountnum, nfeesettletimes, ninassistnum, ningrossnum, ninnum, nkdnum, nmny, nneedinassistnum, noutassistnum, noutgrossnum, noutnum, nplannedmny, nplannedprice, nprice, npricesettlebill, nquotemny, nquotentmny, nquotentprice, nquoteprice, nquoteunitnum, nquoteunitrate, nreplenishedastnum, nreplenishednum, nretastnum, nretnum, nsalemny
, nsaleprice, nshouldinnum, nshouldoutassistnum, nshouldoutnum, ntarenum, ntaxmny, ntaxprice, ntranoutastnum, ntranoutnum, pk_bodycalbody, pk_corp, pk_creqwareid, pk_cubasdoc, pk_defdoc1, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17, pk_defdoc18, pk_defdoc19, pk_defdoc2, pk_defdoc20, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9, pk_invoicecorp, pk_measware, pk_packsort, pk_reqcorp, pk_reqstoorg, pk_returnreason, vbatchcode, vbilltypeu8rm, vbodynote2, vcorrespondrowno, vfirstbillcode, vfirstrowno, vfree1, vfree10, vfree2, vfree3, vfree4, vfree5, vfree6, vfree7, vfree8, vfree9, vnotebody, vproductbatch, vreceiveaddress, vsignwastcode, vsignwastrowno, vsourcebillcode, vsourcerowno, vsourcewastcode, vsourcewastrowno, vsrc2billcode, vsrc2billrowno, vtransfercode, vuserdef1, vuserdef10, vuserdef11, vuserdef12, vuserdef13, vuserdef14, vuserdef15, vuserdef16, vuserdef17, vuserdef18, vuserdef19, vuserdef2, vuserdef20, vuserdef3, vuserdef4, vuserdef5, vuserdef6, vuserdef7, vuserdef8, vuserdef9, vvehiclecode , ts) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50
, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190 , '2013-12-09 10:54:56') |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
34jbq53bkuxpb | select pk_billcoderule, pk_billtypecode, billcodeshortname, ishaveshortname, controlpara, object1, object2, year, month, day, snnum, lastsn, ischeck, snresetflag, isautofill, ispreserve, pk_corp from pub_billcode_rule where pk_billtypecode = :1 and pk_corp = :2 |
36rfh2zq85qax | select a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where checkman = :1 and ( a.type in ( 3, 4, 5, 6 ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc |
3u0931ykk868j |
SELECT DISTINCT zb.vouchid, zb.bbje, zb.ddhbbm, zb.djbh, zb.djdl, zb.djkjnd, zb.djkjqj, zb.djlxbm, zb.djrq, zb.djzt, zb.dr, zb.dwbm, zb.dyvouchid, zb.dzrq, zb.effectdate, zb.enduser, zb.fbje, zb.fj, zb.fktjbm, zb.inner_effect_date, zb.isonlinepay, zb.jszxzf, zb.kmbm, zb.lrr, zb.lybz, zb.officialprintdate, zb.officialprintuser, zb.pj_num, zb.pj_oid, zb.pzglh, zb.qcbz, zb.qrr, zb.scomment, zb.sfkr, zb.shkjnd, zb.shkjqj, zb.shr, zb.shrq, zb.shzd, zb.sxbz, zb.sxkjnd, zb.sxkjqj, zb.sxr, zb.sxrq, zb.ts, zb.xslxbm, zb.ybje, zb.yhqrkjnd, zb.yhqrkjqj, zb.yhqrr, zb.yhqrrq, zb.ywbm, zb.zdr, zb.zdrq, zb.zyx1, zb.zyx10, zb.zyx11, zb.zyx12, zb.zyx13, zb.zyx14, zb.zyx15, zb.zyx16, zb.zyx17, zb.zyx18, zb.zyx19, zb.zyx2, zb.zyx20, zb.zyx3, zb.zyx4, zb.zyx5, zb.zyx6, zb.zyx7, zb.zyx8, zb.zyx9, zb.zzzt, zb.zgyf, zb.isselectedpay, zb.zyx21, zb.zyx22, zb.zyx23, zb.zyx24, zb.zyx25, zb.zyx26, zb.zyx27, zb.zyx28, zb.zyx29, zb.zyx30, zb.sscause, zb.kskhyh, zb.lastshr, zb.spzt, zb.payman, zb.paydate, zb.settlenum, zb.isnetready, zb.ispaid, zb.isjszxzf, zb.isreded from cmp_busibill zb where exists ( select vouchid from cmp_busibill_b where zb.vouchid = cmp_busibill_b.vouchid and cmp_busibill_b.ddhh in ( '1135G41000000007SYR1' ) and cmp_busibill_b.dr = 0 and zb.dr = 0 )
|
3xyxhjvpdj31x |
SELECT ic_general_h.cgeneralhid, ic_general_h.cauditorid, ic_general_h.cbilltypecode, ic_general_h.cbizid, ic_general_h.cbiztype, ic_general_h.ccustomerid, ic_general_h.cdilivertypeid, ic_general_h.cdispatcherid, ic_general_h.cdptid, ic_general_h.cinventoryid, ic_general_h.coperatorid, ic_general_h.cproviderid, ic_general_h.cregister, ic_general_h.cwarehouseid, ic_general_h.cwastewarehouseid, ic_general_h.cwhsmanagerid, ic_general_h.daccountdate, ic_general_h.dauditdate, ic_general_h.dbilldate, ic_general_h.dr, ic_general_h.fbillflag, ic_general_h.fspecialflag, ic_general_h.pk_corp, ic_general_h.vbillcode, ic_general_h.vdiliveraddress, ic_general_h.vnote, ic_general_h.vuserdef1, ic_general_h.vuserdef10, ic_general_h.vuserdef2, ic_general_h.vuserdef3, ic_general_h.vuserdef4, ic_general_h.vuserdef5, ic_general_h.vuserdef6, ic_general_h.vuserdef7, ic_general_h.vuserdef8, ic_general_h.vuserdef9, ic_general_h.vuserdef11, ic_general_h.vuserdef12, ic_general_h.vuserdef13, ic_general_h.vuserdef14, ic_general_h.vuserdef15, ic_general_h.vuserdef16, ic_general_h.vuserdef17, ic_general_h.vuserdef18, ic_general_h.vuserdef19, ic_general_h.vuserdef20, ic_general_h.pk_defdoc1, ic_general_h.pk_defdoc2, ic_general_h.pk_defdoc3, ic_general_h.pk_defdoc4, ic_general_h.pk_defdoc5, ic_general_h.pk_defdoc6, ic_general_h.pk_defdoc7, ic_general_h.pk_defdoc8, ic_general_h.pk_defdoc9, ic_general_h.pk_defdoc10, ic_general_h.pk_defdoc11, ic_general_
h.pk_defdoc12, ic_general_h.pk_defdoc13, ic_general_h.pk_defdoc14, ic_general_h.pk_defdoc15, ic_general_h.pk_defdoc16, ic_general_h.pk_defdoc17, ic_general_h.pk_defdoc18, ic_general_h.pk_defdoc19, ic_general_h.pk_defdoc20, ic_general_h.pk_corp, ic_general_h.ts, ic_general_h.pk_calbody, ic_general_h.pk_purcorp, ic_general_h.freplenishflag, ic_general_h.boutretflag, ic_general_h.bassetcard, ic_general_h.taccounttime, ic_general_h.clastmodiid, ic_general_h.iprintcount, ic_general_h.tmaketime, ic_general_h.tlastmoditime, ic_general_b.bzgflag, ic_general_b.castunitid, ic_general_b.ccorrespondbid, ic_general_b.ccorrespondcode, ic_general_b.ccorrespondhid, ic_general_b.ccorrespondtype, ic_general_b.ccostobject, ic_general_b.cfirstbillbid, ic_general_b.cfirstbillhid, ic_general_b.cfirsttype, ic_general_b.cgeneralbid, ic_general_b.cgeneralhid, ic_general_b.cinventoryid, ic_general_b.cprojectid, ic_general_b.cprojectphaseid, ic_general_b.csourcebillbid, ic_general_b.csourcebillhid, ic_general_b.csourcetype, ic_general_b.cwp, ic_general_b.dbizdate, ic_general_b.dr, ic_general_b.dstandbydate, ic_general_b.dvalidate, ic_general_b.fchecked, ic_general_b.flargess, ic_general_b.isok, ic_general_b.ninassistnum, ic_general_b.ninnum, ic_general_b.nmny, ic_general_b.nneedinassistnum, ic_general_b.noutassistnum, ic_general_b.noutnum, ic_general_b.nplannedmny, ic_general_b.nplannedprice, ic_general_b.nprice, ic_general_b.nshouldinnum, ic_gen
eral_b.nshouldoutassistnum, ic_general_b.nshouldoutnum, ic_general_b.ntranoutnum, ic_general_b.vbatchcode, ic_general_b.vfree1, ic_general_b.vfree10, ic_general_b.vfree2, ic_general_b.vfree3, ic_general_b.vfree4, ic_general_b.vfree5, ic_general_b.vfree6, ic_general_b.vfree7, ic_general_b.vfree8, ic_general_b.vfree9, ic_general_b.vproductbatch, ic_general_b.vsourcebillcode, ic_general_b.vuserdef1, ic_general_b.vuserdef10, ic_general_b.vuserdef2, ic_general_b.vuserdef3, ic_general_b.vuserdef4, ic_general_b.vuserdef5, ic_general_b.vuserdef6, ic_general_b.vuserdef7, ic_general_b.vuserdef8, ic_general_b.vuserdef9, ic_general_b.vuserdef11, ic_general_b.vuserdef12, ic_general_b.vuserdef13, ic_general_b.vuserdef14, ic_general_b.vuserdef15, ic_general_b.vuserdef16, ic_general_b.vuserdef17, ic_general_b.vuserdef18, ic_general_b.vuserdef19, ic_general_b.vuserdef20, ic_general_b.pk_defdoc1, ic_general_b.pk_defdoc2, ic_general_b.pk_defdoc3, ic_general_b.pk_defdoc4, ic_general_b.pk_defdoc5, ic_general_b.pk_defdoc6, ic_general_b.pk_defdoc7, ic_general_b.pk_defdoc8, ic_general_b.pk_defdoc9, ic_general_b.pk_defdoc10, ic_general_b.pk_defdoc11, ic_general_b.pk_defdoc12, ic_general_b.pk_defdoc13, ic_general_b.pk_defdoc14, ic_general_b.pk_defdoc15, ic_general_b.pk_defdoc16, ic_general_b.pk_defdoc17, ic_general_b.pk_defdoc18, ic_general_b.pk_defdoc19, ic_general_b.pk_defdoc20, ic_general_b.pk_corp, ic_general_b.ts, ic_general_b.vnotebody,
ic_general_b.cinvbasid, ic_general_b.pk_invoicecorp, ic_general_b.hsl, ic_general_b.crowno, ic_general_b.csourcetype, ic_general_b.vsourcebillcode, ic_general_b.vsourcerowno, ic_general_b.vfirstbillcode, ic_general_b.vfirstrowno, ic_general_bb3.caccountunitid, ic_general_bb3.cgeneralbb3, ic_general_bb3.cgeneralbid, ic_general_bb3.cgeneralhid, ic_general_bb3.dr, ic_general_bb3.naccountmny, ic_general_bb3.naccountnum1, ic_general_bb3.naccountnum2, ic_general_bb3.nmaterialmoney, ic_general_bb3.npmoney, ic_general_bb3.npprice, ic_general_bb3.nsignnum, ic_general_bb3.ts, po_order.vordercode, po_order.ctermprotocolid, po_order.cgiveinvoicevendor, po_order.cvendormangid, po_order_b.corderid, po_order_b.corder_bid, po_order_b.pk_corp, po_order_b.cusedeptid, po_order_b.cmangid, po_order_b.cbaseid, po_order_b.nordernum, po_order_b.cassistunit, po_order_b.nassistnum, po_order_b.ndiscountrate, po_order_b.idiscounttaxtype, po_order_b.ntaxrate, po_order_b.ccurrencytypeid, po_order_b.noriginalnetprice, po_order_b.noriginalcurprice, po_order_b.noriginalcurmny, po_order_b.noriginaltaxmny, po_order_b.noriginaltaxpricemny, po_order_b.nexchangeotobrate, po_order_b.ntaxmny, po_order_b.nmoney, po_order_b.ntaxpricemny, po_order_b.naccumarrvnum, po_order_b.naccumstorenum, po_order_b.naccuminvoicenum, po_order_b.naccumwastnum, po_order_b.dplanarrvdate, po_order_b.vvendorordercode, po_order_b.vvendororderrow, po_order_b.cwarehouseid, po_order_b.v
receiveaddress, po_order_b.nconfirmnum, po_order_b.dconfirmdate, po_order_b.ccorrectrowid, po_order_b.dcorrectdate, po_order_b.cprojectid, po_order_b.cprojectphaseid, po_order_b.coperator, po_order_b.iisactive, po_order_b.iisreplenish, po_order_b.forderrowstatus, po_order_b.csourcebilltype, po_order_b.csourcebillid, po_order_b.csourcerowid, po_order_b.cupsourcebilltype, po_order_b.cupsourcebillid, po_order_b.cupsourcebillrowid, po_order_b.vmemo, po_order_b.vfree1, po_order_b.vfree2, po_order_b.vfree3, po_order_b.vfree4, po_order_b.vfree5, po_order_b.vdef1, po_order_b.vdef2, po_order_b.vdef3, po_order_b.vdef4, po_order_b.vdef5, po_order_b.vdef6, po_order_b.dr, po_order_b.ts, po_order_b.norgnettaxprice FROM ic_general_h INNER JOIN ic_general_b ON ic_general_h.cgeneralhid = ic_general_b.cgeneralhid INNER JOIN ic_general_bb3 ON ic_general_b.cgeneralbid = ic_general_bb3.cgeneralbid LEFT OUTER JOIN po_order_b ON ic_general_b.cfirstbillhid = po_order_b.corderid AND ic_general_b.cfirstbillbid = po_order_b.corder_bid LEFT OUTER JOIN po_order ON po_order.corderid = po_order_b.corderid LEFT OUTER JOIN bd_cumandoc ON ic_general_h.cproviderid = bd_cumandoc.pk_cumandoc left outer join bd_invmandoc on ic_general_b.cinventoryid = bd_invmandoc.pk_invmandoc WHERE ( ic_general_h.fbillflag = 3 OR ic_general_h.fbillflag = 4 ) AND ic_general_h.dr = 0 AND ic_general_b.dr = 0 AND nvl ( ic_general_b.flargess, 'N' ) = 'N' AND ic_general_bb3.dr = 0 AND ic_general_b.isok
= 'N' AND ic_general_b.ninnum IS NOT NULL AND ic_general_b.pk_invoicecorp = '1052' AND ic_general_h.cbiztype = '000165100000000XMBUA' AND ic_general_h.cbilltypecode = '45' AND ( ( ic_general_h.dbilldate >= '2013-12-09' ) and ( ic_general_h.dbilldate <= '2013-12-09' ) ) AND ( ( ic_general_b.cfirsttype IS NULL ) OR ( po_order.dr = 0 AND po_order_b.dr = 0 AND ic_general_b.cfirsttype = '21' ) ) AND ( bd_cumandoc.frozenflag IS NULL OR bd_cumandoc.frozenflag = 'N' ) ORDER BY ic_general_h.cgeneralhid, ic_general_b.cinventoryid |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
54qdjfczdqbsd | select bd_currtype.pk_currtype, bd_currtype.currtypename from bd_currtype where bd_currtype.pk_currtype in ( '00010000000000000001' ) |
56nwat6ng48c9 | select sum ( sb.norigtaxmny ), sum ( ( nvl ( norigtaxprice, 0 ) + nvl ( ntransprice, 0 ) ) * nvl ( ntotalpondernum, 0 ) ) noutmny from so_salepreorder sh, so_salepreorder_b sb where sh.pk_saledispose_h = sb.pk_saledispose_h and sh.dr = 0 and sb.dr = 0 and sh.pk_corp = '1134' and sh.ccustomerid = '113465100000000005JQ' and ( sh.vbillstatus = 1 or sh.vbillstatus = 7 ) |
5fha4v0ng98br |
SELECT SUM(PRIMAL_AMOUNT) FROM (SELECT INIT_PRIMAL PRIMAL_AMOUNT FROM CMP_INITDATA WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND ((PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 2 AND NVL(ISINNERACC, 'N')='N' AND NVL(DEF1, '·ñ')='·ñ' ) AND PK_MNGACCOUNT IS NULL)) AND FORMCODE = 1 AND AUDITING_DATE <= :B1 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYYEARLY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 2 AND NVL(ISINNERACC, 'N')='N' AND NVL(DEF1, '·ñ')='·ñ') AND FUNDFORMCODE = 1 AND CYEAR IS NOT NULL AND CYEAR < :B3 AND FUNDFORMCODE <= 2 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYMENSAL WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 2 AND NVL(ISINNERACC, 'N')='N' AND NVL(DEF1, '·ñ')='·ñ' ) AND FUNDFORMCODE = 1 AND CYEAR = :B3 AND CMONTH < :B4 AND FUNDFORMCODE <= 2 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYDAILY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 2 AND NVL(ISINNERACC, 'N')='N' AND NVL(DEF1, '·ñ')='·ñ') AND FUNDFORMCODE = 1 AND CYEAR = :B3 AND CMONTH = :B4 AND DAY < :B1 AND
FUNDFOR
MCODE <= 2) UT WHERE PRIMAL_AMOUNT <> 0 |
5pjgqu9rr64p1 | SELECT * FROM bd_corp WHERE pk_corpkind = '0001KHH00000000A0002' |
5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
60uw2vh6q9vn2 | insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/*DTYIYM*/, :7, 183/*DTYIDS*/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/*MAXSB1MINAL*/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20) |
6fck1sxqg9qra | select /*+ 0.6620186233940184 */ gl_detail.pk_accsubj, gl_detail.pk_glorgbook, gl_detail.yearv yearv, gl_detail.assid, sum ( gl_detail.debitquantity ) debitquantitysum, sum ( gl_detail.creditquantity ) creditquantitysum, sum ( gl_detail.debitamount ) debitamountsum, sum ( gl_detail.creditamount ) creditamountsum, sum ( gl_detail.fracdebitamount ) fracdebitamountsum, sum ( gl_detail.fraccreditamount ) fraccreditamountsum, sum ( gl_detail.localdebitamount ) localdebitamountsum, sum ( gl_detail.localcreditamount ) localcreditamountsum from gl_detail gl_detail, gl_fixtmpfreevalue gl_ftpfreevalue, tmptabsubj where gl_detail.pk_accsubj = tmptabsubj.pk_accsubj and gl_detail.yearv = '2013' and gl_detail.free6 >= '01' and gl_detail.free6 <= '12' and gl_detail.pk_glorgbook = '000165100000000AQT1C' and gl_detail.discardflagv = 'N' and gl_detail.dr = 0 and gl_detail.voucherkindv <> 255 and gl_detail.pk_managerv = 'N/A' and gl_detail.assid = gl_ftpfreevalue.assid and code1 = '03301850152' group by gl_detail.pk_accsubj, gl_detail.pk_glorgbook, gl_detail.yearv, gl_detail.assid order by gl_detail.pk_accsubj, gl_detail.pk_glorgbook, gl_detail.yearv, gl_detail.assid |
6n4ggw5qad6k0 |
insert into ic_general_b ( bbarcodeclose, bonroadflag, breturnprofit, bsafeprice, bsourcelargess, bsupplyflag, btoinzgflag, btoouttoiaflag, btooutzgflag, btou8rm, bzgflag, castunitid, cbodybilltypecode, cbodywarehouseid, ccheckstateid, ccorrespondbid, ccorrespondcode, ccorrespondhid, ccorrespondtype, ccostobject, cfirstbillbid, cfirstbillhid, cfirsttype, cfreezeid, cgeneralbid, cgeneralhid, cinvbasid, cinventoryid, corder_bb1id, cparentid, cprojectid, cprojectphaseid, cquotecurrency, cquoteunitid, creceieveid, creceiveareaid, creceivepointid, crowno, cselastunitid, csignwastbid, csignwasthid, csignwasttype, csourcebillbid, csourcebillhid, csourcetype, csourcewastbid, csourcewasthid, csourcewasttype, csrc2billbid, csrc2billhid, csrc2billtype, csumid, cvendorid, cworkcenterid, cworksiteid, cwp, dbizdate, ddeliverdate, dfirstbilldate, drequiredate, drequiretime, dstandbydate, dzgdate, fbillrowflag, fchecked, flargess, ftoouttransflag, hsl, idesatype, isok, naccumtonum, naccumwastnum, nbarcodenum, ncorrespondastnum, ncorrespondgrsnum, ncorrespondnum, ncountnum, nfeesettletimes, ninassistnum, ningrossnum, ninnum, nkdnum, nmny, nneedinassistnum, noutassistnum, noutgrossnum, noutnum, nplannedmny, nplannedprice, nprice, npricesettlebill, nquotemny, nquotentmny, nquotentprice, nquoteprice, nquoteunitnum, nquoteunitrate, nreplenishedastnum, nreplenishednum, nretastnum, nretnum, nsalemny
, nsaleprice, nshouldinnum, nshouldoutassistnum, nshouldoutnum, ntarenum, ntaxmny, ntaxprice, ntranoutastnum, ntranoutnum, pk_bodycalbody, pk_corp, pk_creqwareid, pk_cubasdoc, pk_defdoc1, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17, pk_defdoc18, pk_defdoc19, pk_defdoc2, pk_defdoc20, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9, pk_invoicecorp, pk_measware, pk_packsort, pk_reqcorp, pk_reqstoorg, pk_returnreason, vbatchcode, vbilltypeu8rm, vbodynote2, vcorrespondrowno, vfirstbillcode, vfirstrowno, vfree1, vfree10, vfree2, vfree3, vfree4, vfree5, vfree6, vfree7, vfree8, vfree9, vnotebody, vproductbatch, vreceiveaddress, vsignwastcode, vsignwastrowno, vsourcebillcode, vsourcerowno, vsourcewastcode, vsourcewastrowno, vsrc2billcode, vsrc2billrowno, vtransfercode, vuserdef1, vuserdef10, vuserdef11, vuserdef12, vuserdef13, vuserdef14, vuserdef15, vuserdef16, vuserdef17, vuserdef18, vuserdef19, vuserdef2, vuserdef20, vuserdef3, vuserdef4, vuserdef5, vuserdef6, vuserdef7, vuserdef8, vuserdef9, vvehiclecode , ts) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50
, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190 , '2013-12-09 10:58:13') |
7222ak1vf1xuj | select pk_busiclass, pk_corp, pk_billtype, actiontype, pk_businesstype, isbefore, classname, ts, dr from pub_busiclass where isbefore = :1 and pk_billtype = :2 and actiontype = :3 and pk_businesstype is null |
78m9ryygp65v5 | SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1 |
7p7nxyd9tj71x | select fin.pk_finindex, fin.billcode, fin.pk_sys, fin.pk_proc, fin.pk_busitype, fin.businame, fin.busidate, fin.operator, fin.checker, rt.prepared, fin.pk_corp, fin.flag, fin.currency, fin.money, fin.dapcomment, fin.settlemode, fin.docnum, fin.docdate, fin.pk_vouchentry, fin.deltag, fin.sign, fin.pk_mergebatch, fin.mergebatchcode, fin.errmsg, fin.checkstate, fin.pk_rtvouch, bt.billtypename, fin.procmsg, oper.user_name, ch.user_name, pre.user_name, cur.currtypename, fin.destsystem, rt.assino, fin.pk_glorg, fin.pk_glbook from dap_finindex fin left outer join dap_rtvouch rt on fin.pk_rtvouch = rt.pk_voucher left outer join bd_billtype bt on fin.pk_proc = bt.pk_billtypecode left outer join sm_user oper on fin.operator = oper.cuserid left outer join sm_user ch on fin.checker = ch.cuserid left outer join sm_user pre on rt.prepared = pre.cuserid left outer join bd_currtype cur on fin.currency = cur.pk_currtype where flag = 2 and fin.pk_glorg = '0001651000000009LDLD' and fin.pk_glbook = '0001AA10000000004VTQ' and ( ( pk_sys = 'ARAP' and pk_proc = 'D1' ) or ( pk_sys = 'IA' and pk_proc = 'I2' ) ) and fin.busidate >= '2013-12-01' and fin.currency = '00010000000000000001' and fin.busidate <= '2013-12-09' and fin.destsystem = 0 order by fin.billcode |
83taa7kaw59c1 | select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# |
8bd2za131fg0a | SELECT NVL(SUM(A), 0) FROM ( SELECT SUM(D.RECEIVE - D.PAY) A FROM CMP_DETAIL D WHERE D.PK_ACCOUNT IS NULL AND FUNDFORMCODE = 2 AND D.PK_BILLTYPE <> '36GM' AND ( D.NOTEDIRECTION = 0 OR ( D.NOTEDIRECTION = 1 AND D.PK_DETAIL IN ( SELECT OUTER.PK_OUTERBILL_B FROM FBM_OUTER OUTER, FBM_REGISTER REG WHERE REG.PK_REGISTER = OUTER.PK_REGISTER AND REG.PK_BILLTYPECODE = '36GA' AND REG.SFFLAG = 'Y' AND NVL(REG.DR, 0) = 0 AND NVL(OUTER.DR, 0) = 0 AND REG.PK_CORP = D.PK_CORP ) ) ) AND ( D.ISBILLRECORD <> 'Y' OR D.ISBILLRECORD IS NULL ) AND D.PK_NOTETYPE = '0001A9100000000026B0' AND D.PK_CURRTYPE = '00010000000000000001' AND ( D.TALLYSTATUS <> 0 OR ( D.TALLYSTATUS = 0 AND D.TALLYDATE IS NOT NULL ) ) AND D.TALLYDATE IS NOT NULL AND ( D.TALLYDATE > :B3 AND D.TALLYDATE < :B2 ) AND D.PK_CORP = :B1 UNION SELECT -SUM(D.RECEIVE - D.PAY) A FROM CMP_DETAIL D LEFT JOIN FBM_BASEINFO F ON F.FBMBILLNO = D.NOTENUMBER WHERE D.PK_ACCOUNT IS NULL AND F.BASEINFOSTATUS = 'has_impawn' AND FUNDFORMCODE = 2 AND D.TALLYDATE IS NOT NULL AND D.TALLYDATE IS NOT NULL AND D.PK_NOTETYPE = '0001A9100000000026B0' AND D.PK_CURRTYPE = '00010000000000000001' AND ( D.TALLYDATE > :B3 AND D.TALLYDATE < :B2 ) AND D.PK_CORP = :B1 ) |
8d8xhfg9mxdmy |
SELECT SUM(PRIMAL_AMOUNT) FROM (SELECT INIT_PRIMAL PRIMAL_AMOUNT FROM CMP_INITDATA WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND ((PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 3) AND PK_MNGACCOUNT IS NULL)) AND FORMCODE = 0 AND AUDITING_DATE <= :B1 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYYEARLY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 3) AND FUNDFORMCODE = 0 AND CYEAR IS NOT NULL AND CYEAR < :B3 AND FUNDFORMCODE <= 2 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYMENSAL WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 3) AND FUNDFORMCODE = 0 AND CYEAR = :B3 AND CMONTH < :B4 AND FUNDFORMCODE <= 2 UNION ALL SELECT SUM(GATHERING) - SUM(PAY) PRIMAL_AMOUNT FROM CMP_TALLYDAILY WHERE PK_CORP IN (SELECT * FROM TABLE(:B2 )) AND PK_CURRTYPE='00010000000000000001' AND PK_ACCOUNT IN (SELECT PK_BANKACCBAS FROM BD_BANKACCBAS WHERE ACCCLASS= 3) AND FUNDFORMCODE = 0 AND CYEAR = :B3 AND CMONTH = :B4 AND DAY < :B1 AND FUNDFORMCODE <= 2 ) UT WHERE PRIMAL_AMOUNT <> 0
|
8gy1bfzk76phk | begin :n_Return_Number := nfsn_func_002(:1, :2, :3, :4, :5, :6); end; |
8jy81gs47y3th | insert into gl_detail(pk_detail, assid, bankaccount, checkdate, checkno, checkstyle, contrastflag, creditamount, creditquantity, debitamount, debitquantity, detailindex, errmessage, excrate1, excrate2, explanation, fraccreditamount, fracdebitamount, free1, free2, free3, free4, free5, localcreditamount, localdebitamount, modifyflag, oppositesubj, pk_accsubj, pk_corp, pk_currtype, pk_innercorp, pk_innersob, pk_sob, pk_voucher, price, recieptclass, pk_glbook, pk_glorg, pk_glorgbook, pk_sourcepk, convertflag , DIRECTION, PREPAREDDATEV, YEARV, FREE6, PERIODV, PK_VOUCHERTYPEV, NOV, PK_MANAGERV, VOUCHERKINDV, ERRMESSAGE2, DISCARDFLAGV, signdatev, pk_systemv, pk_offerdetail, isdifflag, busireconno, ts) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, '2013-12-09 10:55:23') |
8swc03d362v74 | select vmainlicense, vpairlicense from meam_vehicle where rownum<16 and ( vmainlicense like :1 or vpairlicense like :2 ) and ( dr = 0 or dr is null ) |
8vkjh60z1g287 |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL
LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID |
94ww7sfdd0gqx | select billcode from pub_billcode_fetched where pk_corp = :1 and billcode = :2 and pk_billtypecode = :3 |
9539rk3kwp5b5 | select a.pk_checkflow, a.pk_billtype, a.billno, a.actiontype, a.senderman, c.user_name, a.ischeck, a.checkman, a.checknote, a.senddate, a.dealdate, a.messagenote, a.pk_corp, a.pk_businesstype, a.billid, a.priority, a.approvestatus, a.userobject, a.workflow_type from pub_workflownote a left outer join sm_user c on a.senderman = c.cuserid where a.checkman = :1 and ( a.approvestatus is null or a.approvestatus != 4 ) and a.receivedeleteflag = 'N' and a.approvestatus = 0 and ischeck = 'N' order by senddate desc |
96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 |
a8bdyasttc0sc | SELECT COUNT(*) FROM SYS.USER_ARGUMENTS B WHERE B.OBJECT_NAME = UPPER(:B1 ) AND ARGUMENT_NAME IS NOT NULL |
afmr5ugdus13x | select pk_billcode_returned, pk_corp, pk_billtypecode, sn from pub_billcode_returned where pk_corp = :1 and pk_billtypecode = :2 order by sn |
aj37st6bd0gyq | begin :n_Return_Number := nfsn_func_000(:1, :2, :3, :4, :5, :6); end; |
amj3f84d2sqpw | select /*+ 0.2965578635168641 */ gl_voucher.pk_glorgbook, gl_detail.pk_accsubj, gl_detail.assid, sum ( gl_detail.debitquantity ) debitquantitysum, sum ( gl_detail.creditquantity ) creditquantitysum, sum ( gl_detail.debitamount ) debitamountsum, sum ( gl_detail.creditamount ) creditamountsum, sum ( gl_detail.fracdebitamount ) fracdebitamountsum, sum ( gl_detail.fraccreditamount ) fraccreditamountsum, sum ( gl_detail.localdebitamount ) localdebitamountsum, sum ( gl_detail.localcreditamount ) localcreditamountsum from gl_detail gl_detail, gl_voucher gl_voucher where gl_detail.pk_accsubj in ( '000165100000000BON21', '000165100000000BON20', '000165100000000BON1Z', '000165100000000BON1Y' ) and gl_voucher.year = '2013' and gl_voucher.free1 >= '01' and gl_voucher.free1 <= '12' and gl_voucher.pk_glorgbook = '000165100000000AQWAP' and gl_detail.pk_glorgbook = '000165100000000AQWAP' and gl_detail.dr = 0 and gl_voucher.discardflag = 'N' and gl_voucher.dr = 0 and gl_voucher.voucherkind <> 255 and gl_voucher.pk_manager = 'N/A' and gl_detail.pk_voucher = gl_voucher.pk_voucher group by gl_voucher.pk_glorgbook, gl_detail.pk_accsubj, gl_detail.assid order by gl_voucher.pk_glorgbook, gl_detail.pk_accsubj, gl_detail.assid |
aru2tfbybth7a |
SELECT pk_corp, cwarehouseid, cinventoryid, sum ( nonhandnum ) nonhandnum, sum ( nonhandassistnum ) nonhandassistnum, sum ( ngrossnum ) ngrossnum FROM ( ( SELECT hand.pk_corp, hand.cwarehouseid, hand.cinventoryid, nvl ( sum ( nonhandnum ), 0.0 ) nonhandnum, nvl ( sum ( nonhandassistnum ), 0.0 ) nonhandassistnum, nvl ( sum ( ngrossnum ), 0.0 ) ngrossnum FROM ic_month_hand hand WHERE dyearmonth = '2013-06' and ( 1 = 1 ) and ( 1 = 1 ) and ( 1 = 1 ) and ( hand.cwarehouseid = '106989100000000003X6' ) and ( 1 = 1 ) and ( hand.pk_corp in ( '1069' ) ) GROUP BY hand.pk_corp, hand.cwarehouseid, hand.cinventoryid ) UNION ALL ( SELECT rec.pk_corp, rec.cwarehouseid, rec.cinventoryid, sum ( nvl ( ninnum, 0.0 ) - nvl ( noutnum, 0.0 ) ) nonhandnum, sum ( nvl ( ninassistnum, 0.0 ) - nvl ( noutassistnum, 0.0 ) ) nonhandassistnum, sum ( nvl ( ningrossnum, 0.0 ) - nvl ( noutgrossnum, 0.0 ) ) ngrossnum FROM ic_month_record rec WHERE dyearmonth >= '2013-07' and dyearmonth <= '2013-11' and ( 1 = 1 ) and ( 1 = 1 ) and ( 1 = 1 ) and ( rec.cwarehouseid = '106989100000000003X6' ) and ( 1 = 1 ) and ( rec.pk_corp in ( '1069' ) ) and ( ( rec.cbilltypecode in ( '40', '41', '44', '4401', '45', '46', '47', '48', '49', '4A', '4B', '4E' ) ) AND ninnum IS NOT NULL OR ( rec.cbilltypecode in ( '4451', '4C', '4D', '4F', '4G', '4H', '4I', '4J', '4O', '4Y' ) ) AND noutnum IS NOT NULL ) GROUP BY rec.pk_corp, rec.cwarehouseid, rec.cinventoryid ) UNION ALL ( SELECT
b.pk_corp, h.cwarehouseid, b.cinventoryid, sum ( nvl ( ninnum, 0.0 ) - nvl ( noutnum, 0.0 ) ) nonhandnum, sum ( nvl ( ninassistnum, 0.0 ) - nvl ( noutassistnum, 0.0 ) ) nonhandassistnum, sum ( nvl ( ningrossnum, 0.0 ) - nvl ( noutgrossnum, 0.0 ) ) ngrossnum FROM ic_general_h h inner join ic_general_b b on h.cgeneralhid = b.cgeneralhid WHERE dbizdate > '2013-11-31' and dbizdate < '2013-12-01' and ( 1 = 1 ) and ( 1 = 1 ) and ( 1 = 1 ) and ( h.cwarehouseid = '106989100000000003X6' ) and ( 1 = 1 ) and ( b.pk_corp in ( '1069' ) ) and ( h.pk_corp in ( '1069' ) ) and ( ( ( h.cbilltypecode in ( '45' ) AND b.fchecked = 0 AND ( h.cbiztype IN ( SELECT pk_busitype FROM bd_busitype WHERE verifyrule <> 'J' ) OR h.cbiztype IS NULL ) ) OR h.cbilltypecode in ( '40', '41', '44', '4401', '46', '47', '48', '49', '4A', '4B', '4E' ) ) AND ninnum IS NOT NULL OR ( ( h.cbilltypecode in ( '4C' ) AND ( h.cbiztype IN ( SELECT pk_busitype FROM bd_busitype WHERE verifyrule <> 'C' ) OR h.cbiztype IS NULL ) ) OR h.cbilltypecode in ( '4451', '4D', '4F', '4G', '4H', '4I', '4J', '4O', '4Y' ) ) AND noutnum IS NOT NULL ) and h.cbilltypecode in ( '4401', '4451', '45', '46', '47', '48', '49', '4A', '4B', '4C', '4D', '4E', '4F', '4G', '4H', '4I', '4J', '4O', '4P', '4Q', '4X', '4Y' ) and h.dr = 0 and b.dr = 0 and h.pk_corp = b.pk_corp GROUP BY b.pk_corp, h.cwarehouseid, b.cinventoryid ) ) qichu GROUP BY pk_corp, cwarehouseid, cinventoryid
|
axmdf8vq7k1rh | select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1 |
ayd7gwk0296dt | SELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1 |
b6vxaxdx93w36 | select configflag, operator, a.classname aclassname, a.returntype areturntype, a.functionnote afunctionnote, a.method amethod, a.parameter aparameter, ysf, value, b.classname bclassname, b.functionnote bfunctionnote, b.method bmethod, b.parameter bparameter, errhintmsg, c.isbefore from pub_actionconstrict c inner join pub_function a on c.functionid = a.pk_function left outer join pub_function b on c.value = b.pk_function where ( pk_corp = :1 or pk_corp = '@@@@' ) and c.pk_billtype = :2 and actiontype = :3 and pk_businesstype = :4 and ( configflag = 1 or ( configflag = 2 and operator = :5 ) or ( configflag = 3 and operator in ( select pk_role from sm_user_role where cuserid = :6 and pk_corp = :7 ) ) ) order by c.sysindex |
bdr7rnq03y8rt |
SELECT DISTINCT zb.vouchid, zb.bbje, zb.ddhbbm, zb.djbh, zb.djdl, zb.djkjnd, zb.djkjqj, zb.djlxbm, zb.djrq, zb.djzt, zb.dr, zb.dwbm, zb.dyvouchid, zb.dzrq, zb.effectdate, zb.enduser, zb.fbje, zb.fj, zb.fktjbm, zb.inner_effect_date, zb.isonlinepay, zb.jszxzf, zb.kmbm, zb.lrr, zb.lybz, zb.officialprintdate, zb.officialprintuser, zb.pj_num, zb.pj_oid, zb.pzglh, zb.qcbz, zb.qrr, zb.scomment, zb.sfkr, zb.shkjnd, zb.shkjqj, zb.shr, zb.shrq, zb.shzd, zb.sxbz, zb.sxkjnd, zb.sxkjqj, zb.sxr, zb.sxrq, zb.ts, zb.xslxbm, zb.ybje, zb.yhqrkjnd, zb.yhqrkjqj, zb.yhqrr, zb.yhqrrq, zb.ywbm, zb.zdr, zb.zdrq, zb.zyx1, zb.zyx10, zb.zyx11, zb.zyx12, zb.zyx13, zb.zyx14, zb.zyx15, zb.zyx16, zb.zyx17, zb.zyx18, zb.zyx19, zb.zyx2, zb.zyx20, zb.zyx3, zb.zyx4, zb.zyx5, zb.zyx6, zb.zyx7, zb.zyx8, zb.zyx9, zb.zzzt, zb.zgyf, zb.isselectedpay, zb.zyx21, zb.zyx22, zb.zyx23, zb.zyx24, zb.zyx25, zb.zyx26, zb.zyx27, zb.zyx28, zb.zyx29, zb.zyx30, zb.sscause, zb.kskhyh, zb.lastshr, zb.spzt, zb.payman, zb.paydate, zb.settlenum, zb.isnetready, zb.ispaid, zb.isjszxzf, zb.isreded from cmp_busibill zb where exists ( select vouchid from cmp_busibill_b where zb.vouchid = cmp_busibill_b.vouchid and cmp_busibill_b.ddhh in ( '1114G41000000003IRHP', '1114G41000000003IRHO', '1114G41000000003IRHN', '1114G41000000003IRHM', '1114G41000000003IRHS', '1114G41000000003IRHR', '1114G41000000003IRHQ', '1114G41000000003IRHG', '1114G4
1000000003IRHH', '1114G41000000003IRHL' ) and cmp_busibill_b.dr = 0 and zb.dr = 0 ) |
bdv0rkkssq2jm | SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF' |
bfh0w93c034dn | select cCustomMenuShortcutID, userId, funcId, iconText, iconId, b.fun_code from sm_custom_menu_shortcut a, sm_funcRegister b where a.funcId = b.cFunId and b.fun_property = 0 and userId = :1 |
btqgdrm4c33y9 | begin :n_Return_Number := nfsn_func_001(:1, :2, :3, :4, :5, :6); end; |
bvatuyfqw3atc |
SELECT ic_general_h.cgeneralhid, ic_general_h.cauditorid, ic_general_h.cbilltypecode, ic_general_h.cbizid, ic_general_h.cbiztype, ic_general_h.ccustomerid, ic_general_h.cdilivertypeid, ic_general_h.cdispatcherid, ic_general_h.cdptid, ic_general_h.cinventoryid, ic_general_h.coperatorid, ic_general_h.cproviderid, ic_general_h.cregister, ic_general_h.cwarehouseid, ic_general_h.cwastewarehouseid, ic_general_h.cwhsmanagerid, ic_general_h.daccountdate, ic_general_h.dauditdate, ic_general_h.dbilldate, ic_general_h.dr, ic_general_h.fbillflag, ic_general_h.fspecialflag, ic_general_h.pk_corp, ic_general_h.vbillcode, ic_general_h.vdiliveraddress, ic_general_h.vnote, ic_general_h.vuserdef1, ic_general_h.vuserdef10, ic_general_h.vuserdef2, ic_general_h.vuserdef3, ic_general_h.vuserdef4, ic_general_h.vuserdef5, ic_general_h.vuserdef6, ic_general_h.vuserdef7, ic_general_h.vuserdef8, ic_general_h.vuserdef9, ic_general_h.vuserdef11, ic_general_h.vuserdef12, ic_general_h.vuserdef13, ic_general_h.vuserdef14, ic_general_h.vuserdef15, ic_general_h.vuserdef16, ic_general_h.vuserdef17, ic_general_h.vuserdef18, ic_general_h.vuserdef19, ic_general_h.vuserdef20, ic_general_h.pk_defdoc1, ic_general_h.pk_defdoc2, ic_general_h.pk_defdoc3, ic_general_h.pk_defdoc4, ic_general_h.pk_defdoc5, ic_general_h.pk_defdoc6, ic_general_h.pk_defdoc7, ic_general_h.pk_defdoc8, ic_general_h.pk_defdoc9, ic_general_h.pk_defdoc10, ic_general_h.pk_defdoc11, ic_general_
h.pk_defdoc12, ic_general_h.pk_defdoc13, ic_general_h.pk_defdoc14, ic_general_h.pk_defdoc15, ic_general_h.pk_defdoc16, ic_general_h.pk_defdoc17, ic_general_h.pk_defdoc18, ic_general_h.pk_defdoc19, ic_general_h.pk_defdoc20, ic_general_h.pk_corp, ic_general_h.ts, ic_general_h.pk_calbody, ic_general_h.pk_purcorp, ic_general_h.freplenishflag, ic_general_h.boutretflag, ic_general_h.bassetcard, ic_general_h.taccounttime, ic_general_h.clastmodiid, ic_general_h.iprintcount, ic_general_h.tmaketime, ic_general_h.tlastmoditime, ic_general_b.bzgflag, ic_general_b.castunitid, ic_general_b.ccorrespondbid, ic_general_b.ccorrespondcode, ic_general_b.ccorrespondhid, ic_general_b.ccorrespondtype, ic_general_b.ccostobject, ic_general_b.cfirstbillbid, ic_general_b.cfirstbillhid, ic_general_b.cfirsttype, ic_general_b.cgeneralbid, ic_general_b.cgeneralhid, ic_general_b.cinventoryid, ic_general_b.cprojectid, ic_general_b.cprojectphaseid, ic_general_b.csourcebillbid, ic_general_b.csourcebillhid, ic_general_b.csourcetype, ic_general_b.cwp, ic_general_b.dbizdate, ic_general_b.dr, ic_general_b.dstandbydate, ic_general_b.dvalidate, ic_general_b.fchecked, ic_general_b.flargess, ic_general_b.isok, ic_general_b.ninassistnum, ic_general_b.ninnum, ic_general_b.nmny, ic_general_b.nneedinassistnum, ic_general_b.noutassistnum, ic_general_b.noutnum, ic_general_b.nplannedmny, ic_general_b.nplannedprice, ic_general_b.nprice, ic_general_b.nshouldinnum, ic_gen
eral_b.nshouldoutassistnum, ic_general_b.nshouldoutnum, ic_general_b.ntranoutnum, ic_general_b.vbatchcode, ic_general_b.vfree1, ic_general_b.vfree10, ic_general_b.vfree2, ic_general_b.vfree3, ic_general_b.vfree4, ic_general_b.vfree5, ic_general_b.vfree6, ic_general_b.vfree7, ic_general_b.vfree8, ic_general_b.vfree9, ic_general_b.vproductbatch, ic_general_b.vsourcebillcode, ic_general_b.vuserdef1, ic_general_b.vuserdef10, ic_general_b.vuserdef2, ic_general_b.vuserdef3, ic_general_b.vuserdef4, ic_general_b.vuserdef5, ic_general_b.vuserdef6, ic_general_b.vuserdef7, ic_general_b.vuserdef8, ic_general_b.vuserdef9, ic_general_b.vuserdef11, ic_general_b.vuserdef12, ic_general_b.vuserdef13, ic_general_b.vuserdef14, ic_general_b.vuserdef15, ic_general_b.vuserdef16, ic_general_b.vuserdef17, ic_general_b.vuserdef18, ic_general_b.vuserdef19, ic_general_b.vuserdef20, ic_general_b.pk_defdoc1, ic_general_b.pk_defdoc2, ic_general_b.pk_defdoc3, ic_general_b.pk_defdoc4, ic_general_b.pk_defdoc5, ic_general_b.pk_defdoc6, ic_general_b.pk_defdoc7, ic_general_b.pk_defdoc8, ic_general_b.pk_defdoc9, ic_general_b.pk_defdoc10, ic_general_b.pk_defdoc11, ic_general_b.pk_defdoc12, ic_general_b.pk_defdoc13, ic_general_b.pk_defdoc14, ic_general_b.pk_defdoc15, ic_general_b.pk_defdoc16, ic_general_b.pk_defdoc17, ic_general_b.pk_defdoc18, ic_general_b.pk_defdoc19, ic_general_b.pk_defdoc20, ic_general_b.pk_corp, ic_general_b.ts, ic_general_b.vnotebody,
ic_general_b.cinvbasid, ic_general_b.pk_invoicecorp, ic_general_b.hsl, ic_general_b.crowno, ic_general_b.csourcetype, ic_general_b.vsourcebillcode, ic_general_b.vsourcerowno, ic_general_b.vfirstbillcode, ic_general_b.vfirstrowno, ic_general_bb3.caccountunitid, ic_general_bb3.cgeneralbb3, ic_general_bb3.cgeneralbid, ic_general_bb3.cgeneralhid, ic_general_bb3.dr, ic_general_bb3.naccountmny, ic_general_bb3.naccountnum1, ic_general_bb3.naccountnum2, ic_general_bb3.nmaterialmoney, ic_general_bb3.npmoney, ic_general_bb3.npprice, ic_general_bb3.nsignnum, ic_general_bb3.ts, po_order.vordercode, po_order.ctermprotocolid, po_order.cgiveinvoicevendor, po_order.cvendormangid, po_order_b.corderid, po_order_b.corder_bid, po_order_b.pk_corp, po_order_b.cusedeptid, po_order_b.cmangid, po_order_b.cbaseid, po_order_b.nordernum, po_order_b.cassistunit, po_order_b.nassistnum, po_order_b.ndiscountrate, po_order_b.idiscounttaxtype, po_order_b.ntaxrate, po_order_b.ccurrencytypeid, po_order_b.noriginalnetprice, po_order_b.noriginalcurprice, po_order_b.noriginalcurmny, po_order_b.noriginaltaxmny, po_order_b.noriginaltaxpricemny, po_order_b.nexchangeotobrate, po_order_b.ntaxmny, po_order_b.nmoney, po_order_b.ntaxpricemny, po_order_b.naccumarrvnum, po_order_b.naccumstorenum, po_order_b.naccuminvoicenum, po_order_b.naccumwastnum, po_order_b.dplanarrvdate, po_order_b.vvendorordercode, po_order_b.vvendororderrow, po_order_b.cwarehouseid, po_order_b.v
receiveaddress, po_order_b.nconfirmnum, po_order_b.dconfirmdate, po_order_b.ccorrectrowid, po_order_b.dcorrectdate, po_order_b.cprojectid, po_order_b.cprojectphaseid, po_order_b.coperator, po_order_b.iisactive, po_order_b.iisreplenish, po_order_b.forderrowstatus, po_order_b.csourcebilltype, po_order_b.csourcebillid, po_order_b.csourcerowid, po_order_b.cupsourcebilltype, po_order_b.cupsourcebillid, po_order_b.cupsourcebillrowid, po_order_b.vmemo, po_order_b.vfree1, po_order_b.vfree2, po_order_b.vfree3, po_order_b.vfree4, po_order_b.vfree5, po_order_b.vdef1, po_order_b.vdef2, po_order_b.vdef3, po_order_b.vdef4, po_order_b.vdef5, po_order_b.vdef6, po_order_b.dr, po_order_b.ts, po_order_b.norgnettaxprice FROM ic_general_h INNER JOIN ic_general_b ON ic_general_h.cgeneralhid = ic_general_b.cgeneralhid INNER JOIN ic_general_bb3 ON ic_general_b.cgeneralbid = ic_general_bb3.cgeneralbid LEFT OUTER JOIN po_order_b ON ic_general_b.cfirstbillhid = po_order_b.corderid AND ic_general_b.cfirstbillbid = po_order_b.corder_bid LEFT OUTER JOIN po_order ON po_order.corderid = po_order_b.corderid LEFT OUTER JOIN bd_cumandoc ON ic_general_h.cproviderid = bd_cumandoc.pk_cumandoc left outer join bd_invmandoc on ic_general_b.cinventoryid = bd_invmandoc.pk_invmandoc WHERE ( ic_general_h.fbillflag = 3 OR ic_general_h.fbillflag = 4 ) AND ic_general_h.dr = 0 AND ic_general_b.dr = 0 AND nvl ( ic_general_b.flargess, 'N' ) = 'N' AND ic_general_bb3.dr = 0 AND ic_general_b.isok
= 'N' AND ic_general_b.ninnum IS NOT NULL AND ic_general_b.pk_invoicecorp = '1034' AND ic_general_h.cbiztype = '000165100000000XMBTY' AND ic_general_h.cbilltypecode = '45' AND ( ( ic_general_h.dbilldate >= '2013-09-30' ) and ( ic_general_h.dbilldate <= '2013-12-09' ) and ( ic_general_h.cproviderid IN ( SELECT pk_cumandoc FROM bd_cumandoc LEFT OUTER JOIN bd_cubasdoc ON bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc LEFT OUTER JOIN bd_areacl ON bd_cubasdoc.pk_areacl = bd_areacl.pk_areacl WHERE custname = 'ÐìÖÝά¿ËÔ´Îï×ÊóÒ×ÓÐÏÞ¹«Ë¾' ) ) ) AND ( ( ic_general_b.cfirsttype IS NULL ) OR ( po_order.dr = 0 AND po_order_b.dr = 0 AND ic_general_b.cfirsttype = '21' ) ) AND ( bd_cumandoc.frozenflag IS NULL OR bd_cumandoc.frozenflag = 'N' ) ORDER BY ic_general_h.cgeneralhid, ic_general_b.cinventoryid |
bwq4c63ng4j09 |
select distinct B.cinvbasid, A.vuserdef1, A.vuserdef2, A.vuserdef3, A.vuserdef4, A.vuserdef5, A.vuserdef6, A.vuserdef7, A.vuserdef8, A.vuserdef9, A.vuserdef10, A.cdispatcherid, A.cbizid, A.vnote, A.cwhsmanagerid, A.cdptid, A.cbilltypecode, B.cprojectid, B.cprojectphaseid, B.cfirsttype, B.cfirstbillbid, B.cfirstbillhid, B.ninassistnum, B.hsl, B.nplannedmny, B.castunitid, B.dbizdate, vbillcode, dbilldate, cproviderid, A.cgeneralhid, B.cgeneralbid, B.cinventoryid, B.vuserdef1, B.vuserdef2, B.vuserdef3, B.vuserdef4, B.vuserdef5, B.vuserdef6, B.vfree1, B.vfree2, B.vfree3, B.vfree4, B.vfree5, ninnum, naccountnum1, naccountmny, cwarehouseid, A.pk_corp, nmaterialmoney, cgeneralbb3, A.ts, B.ts, C.ts, cbiztype, vbatchcode, csourcebillhid, csourcebillbid, crowno, A.pk_calbody, npprice, npmoney, dzgdate, A.vuserdef11, A.vuserdef12, A.vuserdef13, A.vuserdef14, A.vuserdef15, A.vuserdef16, A.vuserdef17, A.vuserdef18, A.vuserdef19, A.vuserdef20, A.pk_defdoc1, A.pk_defdoc2, A.pk_defdoc3, A.pk_defdoc4, A.pk_defdoc5, A.pk_defdoc6, A.pk_defdoc7, A.pk_defdoc8, A.pk_defdoc9, A.pk_defdoc10, A.pk_defdoc11, A.pk_defdoc12, A.pk_defdoc13, A.pk_defdoc14, A.pk_defdoc15, A.pk_defdoc16, A.pk_defdoc17, A.pk_defdoc18, A.pk_defdoc19, A.pk_defdoc20, B.vuserdef7, B.vuserdef8, B.vuserdef9, B.vuserdef10, B.vuserdef11, B.vuserdef12, B.vuserdef13, B.vuserdef14, B.vuserdef15, B.vuserdef16, B.vuserdef17, B.vuserdef
18, B.vuserdef19, B.vuserdef20, B.pk_defdoc1, B.pk_defdoc2, B.pk_defdoc3, B.pk_defdoc4, B.pk_defdoc5, B.pk_defdoc6, B.pk_defdoc7, B.pk_defdoc8, B.pk_defdoc9, B.pk_defdoc10, B.pk_defdoc11, B.pk_defdoc12, B.pk_defdoc13, B.pk_defdoc14, B.pk_defdoc15, B.pk_defdoc16, B.pk_defdoc17, B.pk_defdoc18, B.pk_defdoc19, B.pk_defdoc20, B.cvendorid, bzgyfflag, nzgyfprice, nzgyfmoney, pk_invoicecorp, pk_purcorp, vfirstbillcode, iscalculatedinvcost, C.currencytypeid, noriginalnetprice, norgnettaxprice, noriginaltaxpricemny, noriginalcurmny, nexchangeotobrate, cfeeid, nfeemny, ccorrespondhid, ccorrespondbid, ccorrespondcode from ic_general_h A, ic_general_b B, ic_general_bb3 C, bd_stordoc S, bd_busitype BT where ( A.cbiztype = BT.pk_busitype or A.cbiztype is null ) and A.cwarehouseid = S.pk_stordoc and A.cgeneralhid = B.cgeneralhid and A.cgeneralhid = C.cgeneralhid and B.cgeneralbid = C.cgeneralbid and ( ( dbilldate <= '2013-11-30' ) and ( cproviderid in ( select pk_cumandoc from bd_cumandoc A, bd_cubasdoc B where A.pk_corp = '1046' and custcode = '03308250202' and A.pk_cubasdoc = B.pk_cubasdoc and ( custflag = '1' or custflag = '3' ) ) ) ) and nvl( B.flargess, 'N' ) = 'N' and BT.verifyrule not in ( 'V', 'N' ) and ( nvl( S.iscalculatedinvcost, 'N' ) = 'Y' or A.cwarehouseid is null ) and nvl( S.iscapitalstor, 'N' ) = 'N' and ( A.pk_corp = '1046' and A.pk_corp = B.pk_invoicecorp or A.pk_purcorp <> A.pk_corp and A.pk_purcorp = '1046' and A
.pk_purcorp = B.pk_invoicecorp ) and ( cbilltypecode = '45' or cbilltypecode = '46' ) and A.dr = 0 and B.dr = 0 and ( A.fbillflag = 3 or A.fbillflag = 4 ) and upper ( bzgflag ) = 'Y' and naccountnum1 = 0.0 and nvl ( nfeesettletimes, 0 ) = 0 order by vbillcode, crowno |
cb8wzz3mc81kj |
SELECT ic_general_h.cgeneralhid, ic_general_h.cauditorid, ic_general_h.cbilltypecode, ic_general_h.cbizid, ic_general_h.cbiztype, ic_general_h.ccustomerid, ic_general_h.cdilivertypeid, ic_general_h.cdispatcherid, ic_general_h.cdptid, ic_general_h.cinventoryid, ic_general_h.coperatorid, ic_general_h.cproviderid, ic_general_h.cregister, ic_general_h.cwarehouseid, ic_general_h.cwastewarehouseid, ic_general_h.cwhsmanagerid, ic_general_h.daccountdate, ic_general_h.dauditdate, ic_general_h.dbilldate, ic_general_h.dr, ic_general_h.fbillflag, ic_general_h.fspecialflag, ic_general_h.pk_corp, ic_general_h.vbillcode, ic_general_h.vdiliveraddress, ic_general_h.vnote, ic_general_h.vuserdef1, ic_general_h.vuserdef10, ic_general_h.vuserdef2, ic_general_h.vuserdef3, ic_general_h.vuserdef4, ic_general_h.vuserdef5, ic_general_h.vuserdef6, ic_general_h.vuserdef7, ic_general_h.vuserdef8, ic_general_h.vuserdef9, ic_general_h.vuserdef11, ic_general_h.vuserdef12, ic_general_h.vuserdef13, ic_general_h.vuserdef14, ic_general_h.vuserdef15, ic_general_h.vuserdef16, ic_general_h.vuserdef17, ic_general_h.vuserdef18, ic_general_h.vuserdef19, ic_general_h.vuserdef20, ic_general_h.pk_defdoc1, ic_general_h.pk_defdoc2, ic_general_h.pk_defdoc3, ic_general_h.pk_defdoc4, ic_general_h.pk_defdoc5, ic_general_h.pk_defdoc6, ic_general_h.pk_defdoc7, ic_general_h.pk_defdoc8, ic_general_h.pk_defdoc9, ic_general_h.pk_defdoc10, ic_general_h.pk_defdoc11, ic_general_
h.pk_defdoc12, ic_general_h.pk_defdoc13, ic_general_h.pk_defdoc14, ic_general_h.pk_defdoc15, ic_general_h.pk_defdoc16, ic_general_h.pk_defdoc17, ic_general_h.pk_defdoc18, ic_general_h.pk_defdoc19, ic_general_h.pk_defdoc20, ic_general_h.pk_corp, ic_general_h.ts, ic_general_h.pk_calbody, ic_general_h.pk_purcorp, ic_general_h.freplenishflag, ic_general_h.boutretflag, ic_general_h.bassetcard, ic_general_h.taccounttime, ic_general_h.clastmodiid, ic_general_h.iprintcount, ic_general_h.tmaketime, ic_general_h.tlastmoditime, ic_general_b.bzgflag, ic_general_b.castunitid, ic_general_b.ccorrespondbid, ic_general_b.ccorrespondcode, ic_general_b.ccorrespondhid, ic_general_b.ccorrespondtype, ic_general_b.ccostobject, ic_general_b.cfirstbillbid, ic_general_b.cfirstbillhid, ic_general_b.cfirsttype, ic_general_b.cgeneralbid, ic_general_b.cgeneralhid, ic_general_b.cinventoryid, ic_general_b.cprojectid, ic_general_b.cprojectphaseid, ic_general_b.csourcebillbid, ic_general_b.csourcebillhid, ic_general_b.csourcetype, ic_general_b.cwp, ic_general_b.dbizdate, ic_general_b.dr, ic_general_b.dstandbydate, ic_general_b.dvalidate, ic_general_b.fchecked, ic_general_b.flargess, ic_general_b.isok, ic_general_b.ninassistnum, ic_general_b.ninnum, ic_general_b.nmny, ic_general_b.nneedinassistnum, ic_general_b.noutassistnum, ic_general_b.noutnum, ic_general_b.nplannedmny, ic_general_b.nplannedprice, ic_general_b.nprice, ic_general_b.nshouldinnum, ic_gen
eral_b.nshouldoutassistnum, ic_general_b.nshouldoutnum, ic_general_b.ntranoutnum, ic_general_b.vbatchcode, ic_general_b.vfree1, ic_general_b.vfree10, ic_general_b.vfree2, ic_general_b.vfree3, ic_general_b.vfree4, ic_general_b.vfree5, ic_general_b.vfree6, ic_general_b.vfree7, ic_general_b.vfree8, ic_general_b.vfree9, ic_general_b.vproductbatch, ic_general_b.vsourcebillcode, ic_general_b.vuserdef1, ic_general_b.vuserdef10, ic_general_b.vuserdef2, ic_general_b.vuserdef3, ic_general_b.vuserdef4, ic_general_b.vuserdef5, ic_general_b.vuserdef6, ic_general_b.vuserdef7, ic_general_b.vuserdef8, ic_general_b.vuserdef9, ic_general_b.vuserdef11, ic_general_b.vuserdef12, ic_general_b.vuserdef13, ic_general_b.vuserdef14, ic_general_b.vuserdef15, ic_general_b.vuserdef16, ic_general_b.vuserdef17, ic_general_b.vuserdef18, ic_general_b.vuserdef19, ic_general_b.vuserdef20, ic_general_b.pk_defdoc1, ic_general_b.pk_defdoc2, ic_general_b.pk_defdoc3, ic_general_b.pk_defdoc4, ic_general_b.pk_defdoc5, ic_general_b.pk_defdoc6, ic_general_b.pk_defdoc7, ic_general_b.pk_defdoc8, ic_general_b.pk_defdoc9, ic_general_b.pk_defdoc10, ic_general_b.pk_defdoc11, ic_general_b.pk_defdoc12, ic_general_b.pk_defdoc13, ic_general_b.pk_defdoc14, ic_general_b.pk_defdoc15, ic_general_b.pk_defdoc16, ic_general_b.pk_defdoc17, ic_general_b.pk_defdoc18, ic_general_b.pk_defdoc19, ic_general_b.pk_defdoc20, ic_general_b.pk_corp, ic_general_b.ts, ic_general_b.vnotebody,
ic_general_b.cinvbasid, ic_general_b.pk_invoicecorp, ic_general_b.hsl, ic_general_b.crowno, ic_general_b.csourcetype, ic_general_b.vsourcebillcode, ic_general_b.vsourcerowno, ic_general_b.vfirstbillcode, ic_general_b.vfirstrowno, ic_general_bb3.caccountunitid, ic_general_bb3.cgeneralbb3, ic_general_bb3.cgeneralbid, ic_general_bb3.cgeneralhid, ic_general_bb3.dr, ic_general_bb3.naccountmny, ic_general_bb3.naccountnum1, ic_general_bb3.naccountnum2, ic_general_bb3.nmaterialmoney, ic_general_bb3.npmoney, ic_general_bb3.npprice, ic_general_bb3.nsignnum, ic_general_bb3.ts, po_order.vordercode, po_order.ctermprotocolid, po_order.cgiveinvoicevendor, po_order.cvendormangid, po_order_b.corderid, po_order_b.corder_bid, po_order_b.pk_corp, po_order_b.cusedeptid, po_order_b.cmangid, po_order_b.cbaseid, po_order_b.nordernum, po_order_b.cassistunit, po_order_b.nassistnum, po_order_b.ndiscountrate, po_order_b.idiscounttaxtype, po_order_b.ntaxrate, po_order_b.ccurrencytypeid, po_order_b.noriginalnetprice, po_order_b.noriginalcurprice, po_order_b.noriginalcurmny, po_order_b.noriginaltaxmny, po_order_b.noriginaltaxpricemny, po_order_b.nexchangeotobrate, po_order_b.ntaxmny, po_order_b.nmoney, po_order_b.ntaxpricemny, po_order_b.naccumarrvnum, po_order_b.naccumstorenum, po_order_b.naccuminvoicenum, po_order_b.naccumwastnum, po_order_b.dplanarrvdate, po_order_b.vvendorordercode, po_order_b.vvendororderrow, po_order_b.cwarehouseid, po_order_b.v
receiveaddress, po_order_b.nconfirmnum, po_order_b.dconfirmdate, po_order_b.ccorrectrowid, po_order_b.dcorrectdate, po_order_b.cprojectid, po_order_b.cprojectphaseid, po_order_b.coperator, po_order_b.iisactive, po_order_b.iisreplenish, po_order_b.forderrowstatus, po_order_b.csourcebilltype, po_order_b.csourcebillid, po_order_b.csourcerowid, po_order_b.cupsourcebilltype, po_order_b.cupsourcebillid, po_order_b.cupsourcebillrowid, po_order_b.vmemo, po_order_b.vfree1, po_order_b.vfree2, po_order_b.vfree3, po_order_b.vfree4, po_order_b.vfree5, po_order_b.vdef1, po_order_b.vdef2, po_order_b.vdef3, po_order_b.vdef4, po_order_b.vdef5, po_order_b.vdef6, po_order_b.dr, po_order_b.ts, po_order_b.norgnettaxprice FROM ic_general_h INNER JOIN ic_general_b ON ic_general_h.cgeneralhid = ic_general_b.cgeneralhid INNER JOIN ic_general_bb3 ON ic_general_b.cgeneralbid = ic_general_bb3.cgeneralbid LEFT OUTER JOIN po_order_b ON ic_general_b.cfirstbillhid = po_order_b.corderid AND ic_general_b.cfirstbillbid = po_order_b.corder_bid LEFT OUTER JOIN po_order ON po_order.corderid = po_order_b.corderid LEFT OUTER JOIN bd_cumandoc ON ic_general_h.cproviderid = bd_cumandoc.pk_cumandoc left outer join bd_invmandoc on ic_general_b.cinventoryid = bd_invmandoc.pk_invmandoc WHERE ( ic_general_h.fbillflag = 3 OR ic_general_h.fbillflag = 4 ) AND ic_general_h.dr = 0 AND ic_general_b.dr = 0 AND nvl ( ic_general_b.flargess, 'N' ) = 'N' AND ic_general_bb3.dr = 0 AND ic_general_b.isok
= 'N' AND ic_general_b.ninnum IS NOT NULL AND ic_general_b.pk_invoicecorp = '1421' AND ic_general_h.cbiztype = '0001F1100000001KT12H' AND ic_general_h.cbilltypecode = '45' AND ( ( ic_general_h.dbilldate <= '2013-12-09' ) and ( ic_general_h.cproviderid IN ( SELECT pk_cumandoc FROM bd_cumandoc LEFT OUTER JOIN bd_cubasdoc ON bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc LEFT OUTER JOIN bd_areacl ON bd_cubasdoc.pk_areacl = bd_areacl.pk_areacl WHERE custname = 'ƽºþ¹âÃ÷»úеÉè±¸ÖÆÔìÓÐÏÞ¹«Ë¾' ) ) ) AND ( ( ic_general_b.cfirsttype IS NULL ) OR ( po_order.dr = 0 AND po_order_b.dr = 0 AND ic_general_b.cfirsttype = '21' ) ) AND ( bd_cumandoc.frozenflag IS NULL OR bd_cumandoc.frozenflag = 'N' ) ORDER BY ic_general_h.cgeneralhid, ic_general_b.cinventoryid |
cd2zjpv26y5wh | select a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where ( ( checkman = :1 and a.type = 1 ) or ( a.type = - 1 and a.state <> 2 and ( a.pk_corp = :2 or a.pk_corp = '0001' ) ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc |
cgg8d7p8pa1va |
SELECT bd_cumandoc.pk_cumandoc FROM bd_cumandoc WHERE bd_cumandoc.ts >= '2013-12-09 10:45:07' AND ( bd_cumandoc.pk_cumandoc IN ( '1155651000000000QNYQ', '000165100000000FVJ4V', '1155651000000000AFUF', '000165100000000FRYOH', '1155F110000000021UIN', '115565100000000068L1', '1155651000000000SJ42', '1155G410000000026B9V', '1155G41000000002CX31', '1155G41000000001MVR4', '1155G410000000026BTP', '1155651000000000VD6V', '1155G41000000001K101', '1155651000000000SDR1', '115565100000000018U7', '115565100000000018TV', '000165100000000G1M8A', '1155G410000000026WF0', '11556510000000000WY1', '11556510000000000WXP', '1155F11000000001Y1LV', '1155G4100000000270KZ', '0001G41000000018WA97', '0001G41000000018WA8V', '1155651000000000D17S', '000165100000000GHKII', '11556510000000001CMV', '11556510000000001CN7', '000165100000000DR0VO', '000165100000000DR0W0', '000165100000000DO9SF', '000165100000000GF6R7', '11556510000000018XD0', '11556510000000001NM4', '11556510000000001CRN', '1155651000000000X7L0', '0001G41000000018WAB9', '0001G41000000018WAAX', '115565100000000019JJ', '11556510000000018RK3', '000165100000000GH9UA', '000165100000000I87MS', '1155G410000000029JBC', '000165100000000GF6VT', '1155F11000000001Y482', '115565100000000014TN', '000165100000000GD65M', '1155G41000000002C1C0', '000165100000000DR0TG', '000165100000000GHXH5', '1155G41000000001JSVO', '1155G41000000002C1CN', '1155651000000000B1DT', '115565100000000018TE', '000165100000000FR
TII', '000165100000000GAB5M', '000165100000000FRTGD', '1155651000000001BIYX', '1155G4100000000271OL', '1155G41000000001KYA5', '115565100000000012RM', '115565100000000018YB', '000165100000000DR0UX', '000165100000000DR0V9', '1155G410000000021BMO', '11556510000000001CMF', '1155G410000000028RAK', '1155651000000000Z0WT', '1155G41000000001OYGL', '11556510000000019XU9', '1155G410000000028GZA', '000165100000000DR0T8', '000165100000000DR0SW', '1155651000000000RGTU', '1155G410000000024REL', '1155G41000000002DJ6H', '1155G41000000002MORB', '1155G41000000002762Z', '1155F11000000001Y1S6', '1155G41000000001M8VG', '1155651000000001BJ2S', '1155G410000000026DIZ', '000165100000000DO9SG', '0001G41000000018WABJ', '115565100000000014YB', '000165100000000GF6RG', '000165100000000ENDY3', '000165100000000ENDXR', '1155G410000000026DOY', '1155651000000001BUZU', '1155G41000000001LBRQ', '1155651000000000UGI6', '000165100000000FRTHI', '1155651000000000YLDQ', '1155G41000000002K7OB', '0001G41000000018WA6K', '000165100000000FRWXJ', '1155G4100000000274PO', '1155651000000000D7DS', '11556510000000007IXY', '115565100000000017ZG', '000165100000000FRTI9', '1155651000000000BRAY', '1155G41000000001O345', '000165100000000GF6TJ', '0001G41000000018WA85', '0001G41000000018WA7T', '11556510000000001CA4', '1155G41000000002ADQA', '1155G41000000002DKA3', '000165100000000O2SAK', '1155F110000000021L84', '1155F110000000020UFN', '1155G410000000026C9K', '11556510000000001
8VJ', '000165100000000FUKMM', '11556510000000001CM7', '1155G41000000002AH1Z', '1155651000000000POF8', '1155651000000000BVKI', '1155651000000001FF0V', '115565100000000018Z3', '115565100000000018YR', '000165100000000FVLJ6', '000165100000000GCOVU', '000165100000000GF6RQ', '0001G41000000018WAA3', '1155651000000000XR7G', '11556510000000018Y59', '0001651000000013W174', '000165100000000GCOVS', '000165100000000FRYPP', '000165100000000J5M8A', '11556510000000001CMU', '11556510000000001CN6', '1155G41000000002CBYX', '1155G41000000001PNX6', '000165100000000FRTH8', '000165100000000DR0UE', '1155F11000000001Y1QI', '1155G4100000000275OK', '11556510000000012Y9U', '1155G410000000027VML', '11556510000000000U64', '11556510000000000U5S', '1155651000000000RO59', '0001G41000000018WA7E', '000165100000000ENDY4', '000165100000000ENDXS', '1155G41000000002BY7J', '1155G41000000002CWY8', '1155G410000000028P5R', '1155651000000000WBO6', '1155G410000000025YEG', '0001G41000000018WABZ', '1155651000000000UCJ3', '000165100000000FRTJJ', '11556510000000007OBE', '1155651000000001CBB3', '1155651000000000XQEJ', '1155651000000000AI7U', '000165100000000DR0WP', '0001G41000000018WA8F', '11556510000000004Z0M', '000165100000000JOG04', '000165100000000GS9PD', '1155G41000000001L2RN', '11556510000000001COI', '1155G41000000001OF5W', '1155651000000001BMAK', '000165100000000GGDP4', '000165100000000FRLZC', '115565100000000018UY', '11556510000000007YKB', '000165100000000FR
TIX', '1155F110000000020S7V', '000165100000000H2I65', '1155651000000000RP9Z', '0001G41000000018WAAC', '1155F110000000021MNN', '1155G41000000002C1B2', '11556510000000015UPX', '1155651000000000USEB', '0001G41000000018WAAD', '000165100000000G1M8K', '115565100000000166N3', '115565100000000018WM', '11556510000000000WWM', '000165100000000FRTG4', '1155G41000000001MAYD', '11556510000000001NMD', '1155G410000000026BB3', '1155651000000000VQFV', '1155651000000001F58N', '000165100000000FRTGH', '1155651000000001AAZA', '000165100000000GEY4D', '1155G410000000027SZB', '1155651000000000RUDY', '1155G41000000002FRXQ', '000165100000000DR0TV', '000165100000000DR0U7', '1155651000000000CAQO', '1155G410000000026IWV', '1155G41000000001M8VF', '1155G41000000002KPSC', '1155F11000000002RHU1', '0001G41000000018WACR', '1155651000000001BUZT', '0001G41000000018WA8G', '1155G41000000001KYA6', '115565100000000017A9', '11556510000000001CPJ', '0001G41000000018WA9L', '000165100000000DR0WN', '1155651000000000UGI5', '11556510000000004YK2', '1155651000000000QNYP', '000165100000000FRTIH', '1155G41000000001W1W8', '11556510000000000U3J', '1155651000000000XSQM', '115565100000000015OA', '11556510000000000U9F', '000165100000000GF6QU', '000165100000000GF6R6', '11556510000000009QI9', '1155651000000001FCVV', '1155651000000000TG35', '1155G410000000026S84', '000165100000000DR0VN', '11556510000000001CNI', '1155651000000000SDR0', '1155G41000000001MKIH', '1155G410000000029
JBF', '11556510000000001C5R', '115565100000000076HN', '11556510000000000U97', '11556510000000000U8V', '000165100000000DO9SE', '1155651000000000CSRG', '000165100000000GHAYE', '11556510000000015UPW', '1155G41000000002F7VB', '1155651000000000US93', '000165100000000DR0TD', '11556510000000000YBR', '11556510000000001EAF', '000165100000000GAB5N', '000165100000000G1M8Z', '11556510000000001CPZ', '000165100000000D25L0', '0001G41000000018WA7D', '1155G41000000001MJD1', '11556510000000000U7F', '000165100000000NA6KC', '0001G41000000018WAA4', '000165100000000FRYOX', '000165100000000FRYP9', '000165100000000GF6RH', '000165100000000CUX07', '000165100000000GHKIL', '11556510000000001CNY', '1155G41000000001N4JT', '1155651000000000W353', '1155F11000000002OVB2', '000165100000000DR0UU', '000165100000000DR0V6', '0001G41000000018WA84', '0001G41000000018WA7S', '000165100000000HB98M', '1155651000000001A0DO', '1155G410000000026RAF', '11556510000000001CA3', '115565100000000014YA', '115565100000000018ZF', '11556510000000000WZF', '1155G41000000001OYGM', '1155G410000000026FAZ', '1155G41000000001N4JM', '11556510000000006MNT', '1155651000000001C6S5', '1155651000000001C2SP', '000165100000000DR0SZ', '1155651000000000X84E', '1155651000000000USE6', '1155G41000000002ISPX', '1155651000000000BRAX', '1155G410000000028BC6', '0001G41000000018WA6J', '1155651000000000ONFF', '000165100000000GH9U1', '000165100000000CUX08', '1155F11000000001QTZK', '000165100000000FR
WXI', '000165100000000GF6VC', '000165100000000G1M8J', '000165100000000MSMBK', '115565100000000018XA', '11556510000000000WXA', '1155G410000000028P5S', '000165100000000GF6RR', '11556510000000000ZQM', '11556510000000001CM6', '11556510000000012Y9T', '000165100000000FRTHJ', '11556510000000001COY', '0001G41000000018WAAZ', '115565100000000018Z2', '115565100000000018YQ', '11556510000000000WZ2', '11556510000000000WYQ', '1155G41000000001L4UE', '000165100000000DR0UF', '000165100000000GCOVR', '1155651000000001I43X', '1155F11000000001Y8SM', '1155G410000000028GZB', '1155G41000000002EGCO', '0001G41000000018WABY', '000165100000000FVJ4S', '0001G41000000018WAA5', '115565100000000018UF', '1155651000000000RP9Y', '11556510000000001CQM', '1155651000000000XQEK', '000165100000000FRTJ3', '000165100000000FRTIR', '1155651000000000RMA5', '1155651000000000PBOM', '1155651000000000VBK9', '1155651000000000RO58', '115565100000000011UL', '1155651000000000RAAZ', '11556510000000000X0J', '1155651000000000X5UE', '1155651000000000SCX6', '1155G41000000002C75L', '1155651000000000WAW0', '11556510000000004Z0L', '11556510000000006ERR', '1155F110000000021MNM', '1155G41000000001WOET', '1155651000000000PZFJ', '1155651000000000PPBP', '11556510000000000U8F', '11556510000000001CQZ', '1155651000000001I4TJ', '115565100000000015P2', '115565100000000015OQ', '1155651000000000BXVH', '115565100000000018WN', '1155651000000000WRWC', '115565100000000018T6', '11556510000000001
8SU', '1155651000000001BMAL', '0001G41000000018WAAE', '000165100000000FRTG3', '1155G41000000002C1B3', '000165100000000FRLZB', '000165100000000DR0WM', '1155G410000000026BB4', '000165100000000GM1I0', '1155651000000000P4CT', '1155651000000000SJ41', '1155651000000000116W', '1155651000000000VQFW', '000165100000000GGDP5', '000165100000000DR0TW', '000165100000000DR0U8', '11556510000000008AMC', '000165100000000GHKKJ', '000165100000000GD65N', '1155G41000000002CX2U', '1155F110000000020UFM', '1155651000000000RUDZ', '1155F11000000001ZI30', '1155651000000001FDPV', '000165100000000GS9Q8', '115565100000000015O2', '1155651000000000XRVP', '1155G410000000026YFN', '000165100000000ERZ7B', '1155651000000000TG34', '1155G410000000026U3V', '1155651000000001CND9', '0001G41000000018WA9M', '000165100000000GD65K', '000165100000000DR0T6', '000165100000000DR0SU', '11556510000000000U5N', '1155G41000000001PX8N', '11556510000000000YBQ', '1155651000000000PB9Y', '1155651000000000VPZ6', '1155G41000000002DOTF', '1155G41000000002CWYK', '11556510000000000U77', '11556510000000000U6V', '000165100000000DOE4C', '1155651000000001BA6F', '1155G41000000001OY5D', '11556510000000001CPI', '1155651000000000TAWA', '11556510000000001CNJ', '000165100000000GCOVB', '115565100000000018Y3', '115565100000000018XR', '1155651000000000A0D2', '1155F11000000001Y1M5', '1155651000000001FDPA', '115565100000000018VZ', '1155651000000000R2PA', '000165100000000GEY4B', '11556510000000006
ERQ', '1155651000000000TA4W', '000165100000000FRTFX', '000165100000000GF6RE', '1155651000000000XDFM', '000165100000000FRWXD', '000165100000000GHXH3', '1155G4100000000272VV', '000165100000000FRTIG', '000165100000000GGDP6', '1155651000000000ZG8N', '1155651000000000162H', '1155651000000000POER', '11556510000000008124', '000165100000000FRYON', '1155G410000000028BCF', '0001G41000000018WA5Y', '000165100000000DR0WB', '1155651000000000VBL9', '0001G41000000018WACQ', '0001G41000000018WA8H', '1155F11000000002IAST', '115565100000000017A8', '1155G41000000002CXLJ', '11556510000000001EAE', '000165100000000GF6RW', '1155G410000000028D4G', '0001G41000000018WA87', '0001G41000000018WA7V', '000165100000000II631', '11556510000000019JQP', '000165100000000GF6TD', '0001G41000000018WAAJ', '11556510000000001CPY', '1155651000000000PTU5', '11556510000000016A8Z', '1155651000000000YDB0', '1155G41000000001MJD0', '000165100000000GFPGA', '1155651000000000A0GL', '1155G410000000026CW2', '000165100000000DR0UZ', '1155G41000000002DROY', '11556510000000001C5S', '1155G410000000027QS7', '11556510000000006MNU', '1155G41000000002CXL8', '11556510000000000U6G', '11556510000000019LM0', '1155G41000000001KZ3O', '11556510000000004YK5', '1155G410000000026W4E', '0001G41000000018WA6M', '1155651000000000AQKQ', '11556510000000000U87', '11556510000000000U7V', '11556510000000001CNZ', '1155651000000000UCAW', '1155651000000000TR0P', '000165100000000FRTHR', '1155G41000000001N
4JN', '1155G410000000028LL1', '1155651000000000W013', '1155651000000000BR20', '000165100000000FUO12', '1155G410000000024QDE', '000165100000000CUX09', '1155G41000000002C1CB', '11556510000000009SYD', '11556510000000018XNA', '1155G41000000002C1BF', '000165100000000GF6VD', '1155G41000000001KYEJ', '11556510000000000U4M', '1155651000000000ONFG', '1155651000000000UZ5H', '000165100000000GH9U2', '0001G41000000018WAC8', '0001G41000000018WABW', '11556510000000001CQN', '1155651000000000CGB1', '000165100000000DR0UG', '1155G41000000001O344', '0001G41000000018WAC9', '0001G41000000018WABX', '11556510000000001C76', '1155G410000000026S4C', '000165100000000ENDYN', '000165100000000MSMBJ', '1155651000000000YD3F', '000165100000000FVLJ0', '1155651000000000VD83', '000165100000000DR0TI', '1155651000000000QYUT', '000165100000000GH9BT', '000165100000000FVJ4P', '000165100000000ENDYC', '11556510000000018XCZ', '1155651000000000WZ3M', '1155651000000000Z0WS', '11556510000000000WYT', '1155F11000000002IW6I', '115565100000000018T3', '115565100000000018SR', '1155651000000000CYUR', '1155651000000000UB2G', '1155F11000000001XF8A', '0001G41000000018WA7G', '11556510000000000N6Z', '1155G410000000028FV1', '1155F110000000021O11', '000165100000000FVLJA', '115565100000000015ON', '115565100000000018RA', '000165100000000FRYPN', '1155G410000000026WAU', '000165100000000DR0WR', '115565100000000018UE', '1155G410000000027T9P', '11556510000000001CAQ', '1155G41000000002C
1BM', '000165100000000FRTHK', '1155651000000000CAUX', '1155651000000000R2JE', '11556510000000000N6K', '1155651000000000VS87', '1155651000000000VBJL', '11556510000000009A4G', '000165100000000FRWXU', '1155G41000000001MVR5', '0001G41000000018WAA6', '1155G4100000000274BR', '0001G41000000018WA98', '0001G41000000018WA8W', '000165100000000KYH9V', '000165100000000FRLZA', '1155G41000000001P8QD', '1155651000000000RMA6', '1155651000000001BJ2T', '1155G41000000002KMBF', '000165100000000D25L1', '000165100000000FRTGN', '1155651000000000YDAZ', '1155651000000000VD6W', '1155G410000000026R9K', '11556510000000000YRI', '1155651000000000116X', '000165100000000GFPGL', '1155651000000001I4TI', '1155651000000000VBL8', '1155G41000000001JSIP', '115565100000000012AP', '11556510000000000ZQN', '1155G41000000002CGRR', '11556510000000004Z0I', '11556510000000001COZ', '1155651000000000VD6H', '000165100000000GM1I1', '1155G41000000001W230', '1155651000000000BVKJ', '1155G41000000002CWN0', '1155651000000001I4Y3', '1155G41000000001KYAD', '11556510000000000Y48', '1155G410000000026C9J', '1155651000000000SCX7', '000165100000000FRTJC', '115565100000000018Z7', '115565100000000018YV', '000165100000000DR0TX', '000165100000000DR0U9', '1155651000000000CR3T', '1155G410000000026CFH', '1155G41000000002C75M', '000165100000000DR0VQ', '000165100000000DR0W2', '1155G410000000028BCU', '1155651000000000PPBO', '1155651000000000SEXO', '0001G41000000018WAAF', '000165100000000DR
0TF', '1155651000000000D17R', '1155G410000000026WF1', '1155651000000000UCJC', '000165100000000FRTJ4', '000165100000000FRTIS', '0001G41000000018WA8I', '000165100000000GD65L', '1155G41000000002CXQS', '1155651000000000CGB0', '0001G41000000018WA9N', '1155G410000000026U0X', '1155651000000000PB9X', '115565100000000018Z6', '115565100000000018YU', '11556510000000000WYU', '1155651000000000XRVO', '11556510000000001CQY', '1155651000000001CND8', '115565100000000018Y2', '115565100000000018XQ', '11556510000000000WY2', '11556510000000000WXQ', '1155651000000000D9CF', '000165100000000FRTIF', '115565100000000018U6', '115565100000000018TU', '1155G410000000026YFO', '115565100000000018ZE', '11556510000000000WZE', '000165100000000FUMGO', '000165100000000GHKN1', '1155651000000001BIYW', '000165100000000GCOVA', '1155F11000000001Y1M4', '000165100000000GF6QW', '000165100000000GF6R8', '1155651000000000AQKR', '11556510000000001CRM', '1155651000000000B1DU', '000165100000000I87MT', '1155G410000000028BCE', '11556510000000000WX1', '11556510000000000WWP', '000165100000000FRYOO', '000165100000000FRYP0', '1155651000000000BQWJ', '1155G41000000002L7H0', '000165100000000G1M8X', '000165100000000GGDP7', '1155G41000000002KS62', '000165100000000GF6RF', '000165100000000FRTJS', '0001G41000000018WA5Z', '1155G41000000002C1CO', '1155651000000000X7L1', '1155G41000000001MJJU', '11556510000000004YK4', '115565100000000017B0', '000165100000000GHXH4', '11556510000000001
2RL', '11556510000000015UPU', '1155G41000000001KYFE', '000165100000000DR0WA', '1155651000000000A0GM', '0001G41000000018WACP', '11556510000000008TWJ', '000165100000000GS9PE', '1155G410000000026CW3', '11556510000000000WYD', '1155G41000000001QLW5', '11556510000000000N6J', '1155G41000000002CVW9', '1155G41000000002EAVN', '000165100000000DO9SL', '1155G410000000023HGL', '1155G41000000002ADQB', '000165100000000XI5P9', '1155651000000000RP5W', '115565100000000018VY', '11556510000000000WVY', '1155G410000000027QS6', '1155G41000000002MOQA', '1155651000000000TR0O', '11556510000000001CAP', '1155G410000000026DOX', '000165100000000DR0UW', '000165100000000DR0V8', '0001G41000000018WAAK', '1155G4100000000272UP', '115565100000000014TK', '115565100000000011V0', '115565100000000011UO', '000165100000000FRTJD', '000165100000000RQCQT', '000165100000000DR0T9', '000165100000000DR0SX', '1155G41000000002CWU3', '1155G410000000021BMP', '1155G41000000001WOEZ', '000165100000000GCOVQ', '11556510000000007OBD', '1155651000000000BXYY', '1155651000000000YD3G', '1155G41000000002BY7K', '000165100000000FRTHS', '11556510000000000U4N', '1155G41000000001LBRR', '000165100000000ENDYD', '1155651000000001BA6E', '11556510000000000WY5', '11556510000000000WXT', '000165100000000FRWXK', '1155651000000000BR1N', '11556510000000000U6F', '1155G41000000002CWN6', '115565100000000018TB', '1155G410000000020ICK', '1155G4100000000274PN', '11556510000000000N5N', '11556510000000004
Z0Y', '11556510000000009SYE', '1155651000000000A0D1', '1155651000000000V22R', '115565100000000017ZJ', '000165100000000FVJ4U', '115565100000000018WA', '11556510000000000WWA', '11556510000000019JQQ', '0001G41000000018WA86', '0001G41000000018WA7U', '0001G41000000018WA6L', '1155651000000000D7DR', '1155651000000000PTU4', '1155651000000000CO2V', '1155651000000000XR7F', '11556510000000007OCN', '000165100000000DR0UH', '1155651000000000PBP0', '1155651000000000QYUS', '000165100000000FRYPO', '1155651000000000VBCA', '0001G41000000018WA7F', '115565100000000018ZV', '11556510000000000WZV', '1155F11000000001ZOPL', '000165100000000FVLJ1', '11556510000000009TH7', '1155651000000000VD82', '1155G41000000001P8QE', '1155G41000000002BSR5', '000165100000000GH9BU', '000165100000000FUKML', '000165100000000FRLZQ', '000165100000000J5M8B', '000165100000000G1M8H', '1155651000000001I4Y2', '1155F110000000021O10', '1155651000000000X84D', '11556510000000001E99', '1155F11000000001YZL2', '1155F11000000001Y1S5', '0001G41000000018WAA7', '000165100000000DR0WO', '11556510000000001COJ', '1155G41000000002C1BN', '1155G41000000001PNX7', '1155G41000000001LVLK', '000165100000000DOE4D', '000165100000000GCOWC', '11556510000000000U67', '11556510000000000U5V', '1155651000000000BN0V', '000165100000000GF6RX', '1155651000000000UCJ4', '1155G41000000002ISNU', '1155G41000000002AZVD', '1155651000000000PBP1', '11556510000000001CME', '000165100000000D25L2', '000165100000000D2
5KQ', '1155G410000000026CO7', '1155G4100000000274BS', '000165100000000DR0TY', '0001G41000000018WA99', '0001G41000000018WA8X', '1155651000000000UPKH', '11556510000000004ID1', '1155G41000000002BWVA', '115565100000000018V7', '115565100000000018UV', '1155G41000000001K100', '1155F110000000021L85', '000165100000000FRTGM', '11556510000000004Z0J', '000165100000000H2I66', '1155651000000000USHU', '1155G410000000026QTM', '000165100000000FRLZH', '1155651000000000ZCCX', '11556510000000007X10', '115565100000000018XB', '1155F110000000020S7U', '1155G41000000001P5KY', '1155G410000000026R9J', '1155651000000001HH6I' ) OR bd_cumandoc.pk_cumandoc IN ( '1155G410000000026CFI', '000165100000000DR0VP', '000165100000000DR0W1', '1155F11000000002W97S', '1155G410000000027WKZ', '11556510000000000Y47', '0001G41000000018WAAG', '1155G41000000001W231', '11556510000000016IV6', '000165100000000FRLZ7', '000165100000000FRLYV', '11556510000000016S5C', '115565100000000018ZU', '11556510000000000WZU', '1155G41000000002CWJU', '11556510000000006ES5', '11556510000000000N5Z', '1155G410000000026FB0', '11556510000000001C77', '000165100000000GEY4C', '115565100000000166N2', '11556510000000001563', '1155G410000000026WN9', '11556510000000001COU', '11556510000000001CP6', '1155651000000000US92', '000165100000000FRTIT', '000165100000000DR0WI', '000165100000000DR0T4', '000165100000000DR0SS', '000165100000000GAE1Y', '11556510000000004HJH', '000165100000000FVJ4W', '1155651000
00000018ZA', '11556510000000000WZA', '1155651000000000XAEX', '1155651000000000UC00', '1155651000000001BJ0I', '1155651000000000RPOU', '000165100000000G1M8N', '0001G41000000018WAAH', '000165100000000GF6QR', '000165100000000GF6R3', '0001G41000000018WABM', '1155651000000000RPUG', '000165100000000D25L3', '000165100000000D25KR', '1155651000000001FCVW', '1155651000000000CBUR', '1155G41000000002CXLI', '1155G41000000002721G', '11556510000000000U47', '11556510000000000U3V', '115565100000000012NU', '000165100000000H2I6A', '1155G41000000002CWN7', '1155G41000000002C75H', '11556510000000008TWI', '000165100000000G1M84', '000165100000000G1M8E', '1155G41000000002C1C4', '000165100000000FUMGP', '1155G410000000027WT4', '11556510000000001CRR', '1155G41000000001QLW4', '115565100000000018VF', '0001G41000000018WABF', '1155G410000000026B9R', '11556510000000001CM2', '11556510000000007PSP', '0001G41000000018WA78', '0001G41000000018WA6W', '1155G410000000026XL9', '1155651000000000V8BM', '1155651000000000BRB0', '1155651000000000UCAJ', '0001G41000000018WACH', '1155G410000000024UZI', '115565100000000017ZK', '11556510000000000U8J', '1155651000000000Q5FH', '11556510000000001946', '1155651000000000BQ3T', '000165100000000FRTJE', '1155G410000000027YXS', '000165100000000NA6KB', '000165100000000GF6RC', '11556510000000000ZY9', '1155651000000000UCJB', '1155651000000000UBZZ', '000165100000000GS9PP', '115565100000000019JF', '000165100000000GCOVP', '1155651000
000000T42T', '1155G41000000002BV0F', '1155651000000000V22Q', '1155651000000000WYZ8', '1155651000000001HH6G', '11556510000000001COE', '1155G41000000002C759', '000165100000000GD65I', '1155651000000000PZF3', '0001G41000000018WA9O', '1155G410000000020ICL', '11556510000000016JV0', '000165100000000FRTGL', '000165100000000FRWXF', '1155G410000000022W0U', '115565100000000012RI', '000165100000000DR0VK', '1155651000000000USHS', '1155F11000000001R1JX', '11556510000000008HL3', '1155G410000000026LKT', '11556510000000007IXV', '11556510000000001NM8', '11556510000000007OCO', '11556510000000008J7I', '11556510000000009YT0', '000165100000000FRYPK', '1155G41000000002CWYW', '0001G41000000018WA8B', '1155G410000000026XG6', '1155651000000000RP5V', '1155651000000000159L', '000165100000000FRTJU', '115565100000000018VM', '000165100000000GCOWB', '000165100000000FRTHT', '000165100000000FRLZ6', '000165100000000FRLYU', '1155G41000000002BRHH', '1155651000000001BUZY', '1155651000000001BA5W', '1155G410000000028CSP', '1155G410000000026IX3', '000165100000000DR0UC', '115565100000000018WI', '11556510000000000WWI', '000165100000000ENDYA', '1155G41000000001OS52', '11556510000000001CNU', '11556510000000001CO6', '1155G41000000002CMEX', '11556510000000001CMB', '000165100000000FVLJ2', '11556510000000000U68', '11556510000000000U5W', '1155651000000000W36O', '1155651000000001AAZE', '1155651000000000166H', '1155G410000000027YV3', '1155G41000000001PTEO', '1155651000
000000UBZI', '11556510000000000U5A', '0001G41000000018WA7A', '115565100000000018TY', '1155G41000000001LKCP', '0001G41000000018WA67', '000165100000000FRTJF', '000165100000000GD65Y', '1155651000000000162G', '115565100000000199MQ', '1155651000000000RMAA', '1155F11000000001ZOPM', '1155G41000000002CVUC', '1155651000000000CO2U', '000165100000000FRLZG', '1155651000000000SYIT', '11556510000000005SUC', '1155G41000000002AY43', '1155651000000000USHV', '1155G410000000025RE7', '000165100000000DR0VB', '1155G410000000026CO8', '1155G410000000026CDM', '1155G41000000002CWJV', '1155G410000000026IZI', '1155G41000000002KFHX', '1155651000000000TD0Y', '1155G410000000025XKH', '1155G41000000002AZVC', '1155651000000000CO2Z', '1155G41000000001LDC0', '11556510000000000YU7', '11556510000000000U7J', '11556510000000001CQA', '000165100000000FRYPV', '1155G4100000000257OX', '1155G410000000026BB7', '1155651000000000XR7C', '1155G41000000002CXQT', '115565100000000012RU', '1155G410000000026V0X', '1155F110000000020UFJ', '000165100000000GF6R2', '1155G4100000000270KV', '0001G41000000018WA6G', '115565100000000018XM', '11556510000000000WXM', '000165100000000GFPGJ', '0001G41000000018WA81', '0001G41000000018WA7P', '1155651000000000O5M2', '1155651000000000QBJV', '11556510000000000N79', '1155G41000000001T8LF', '1155G410000000027QF3', '1155G41000000002CVU5', '1155651000000000R2TZ', '11556510000000018RK6', '1155G410000000027QFA', '1155G410000000026BTO', '1155651000
0000000U46', '11556510000000000U3U', '1155G4100000000270KW', '000165100000000DR0T7', '000165100000000DR0SV', '000165100000000H2I6B', '1155F11000000001Y1SL', '1155651000000000V8BL', '1155651000000000VD6I', '1155G41000000002CXG8', '11556510000000009T0H', '1155651000000000ZCCY', '11556510000000005SUB', '1155G41000000001PX8M', '0001G41000000018WAB6', '0001G41000000018WAAU', '000165100000000FRTF0', '1155F11000000001ZHHL', '1155G410000000026RA7', '1155651000000001BJ0H', '1155G410000000026KYK', '1155G41000000002721F', '0001651000000011456A', '1155651000000000107Z', '1155651000000000X5Z1', '000165100000000FRTJ6', '000165100000000FRTIU', '000165100000000GD65J', '0001G41000000018WAAI', '115565100000000018ZR', '11556510000000000WZR', '11556510000000001CPN', '000165100000000D25L4', '000165100000000D25KS', '1155651000000000RPUF', '1155G410000000029D33', '1155G410000000026VBN', '000165100000000DR0TB', '1155651000000000129B', '0001G41000000018WA9P', '1155G41000000001N4JI', '1155651000000000XDFN', '000165100000000FRTHC', '1155G410000000020ICI', '11556510000000000YU8', '11556510000000018WEZ', '115565100000000015R6', '0001G41000000018WACG', '11556510000000000U4A', '1155651000000000TAW9', '000165100000000DR0VZ', '11556510000000000U78', '11556510000000000U6W', '11556510000000000U60', '11556510000000000U5O', '1155651000000000UCAK', '0001G41000000018WA8C', '11556510000000009T14', '1155G410000000027YXT', '000165100000000GHKIH', '1155651000
0000001COV', '11556510000000001CP7', '1155651000000001F18Q', '1155651000000000X86X', '000165100000000DR0UQ', '000165100000000DR0V2', '115565100000000014TB', '0001G41000000018WA69', '1155G41000000001JQH9', '1155G410000000026B9U', '1155F11000000002OZK1', '000165100000000G1M8D', '11556510000000001CQI', '0001G41000000018WA77', '0001G41000000018WA6V', '000165100000000GS9PO', '1155651000000000PCTL', '000165100000000GCOVO', '11556510000000000U8K', '1155G41000000002C1CC', '11556510000000004IBX', '1155651000000000ZGA0', '11556510000000009QKV', '1155G41000000001JSVP', '1155651000000000W014', '1155651000000000YGYI', '1155G41000000002CXL9', '000165100000000FRTGK', '1155G41000000002C758', '0001G41000000018WA92', '0001G41000000018WA8Q', '000165100000000G1M85', '11556510000000008967', '1155F11000000001XQUO', '000165100000000II630', '1155G410000000026LKU', '1155651000000000Q5FI', '0001G41000000018WAA8', '1155651000000001HH6F', '11556510000000000U88', '11556510000000000U7W', '1155G41000000001OS51', '000165100000000GAE1Z', '1155651000000000UZ5G', '000165100000000FRWXE', '115565100000000018TI', '1155G41000000002KH8B', '000165100000000FRYPL', '000165100000000FRTGR', '1155G410000000026W4D', '11556510000000001945', '1155F11000000001Y5NL', '1155G410000000022W0T', '000165100000000GF6TE', '11556510000000009YT1', '1155G41000000001WRJA', '115565100000000018RB', '1155G410000000026BAI', '11556510000000009T0G', '000165100000000GF6RM', '1155651000
000001984A', '115565100000000018YN', '1155651000000000O760', '1155G410000000028OF9', '000165100000000FRYOT', '000165100000000FRYP5', '1155651000000001BA5V', '1155651000000000W36N', '000165100000000FRTJT', '000165100000000FVLJ3', '115565100000000011V1', '115565100000000011UP', '000165100000000GHKJH', '1155G410000000027MJO', '115565100000000199MR', '1155651000000000159M', '115565100000000018WJ', '1155G410000000027ZBP', '1155G410000000028F6A', '000165100000000FRM00', '0001G41000000018WA6F', '11556510000000001CNV', '11556510000000001CO7', '000165100000000ENDYG', '1155G41000000001PTEL', '1155651000000000BQWK', '1155G41000000001MAYE', '000165100000000FRWXV', '115565100000000018TZ', '000165100000000GFPFG', '1155G410000000027R63', '1155651000000000UBZJ', '1155651000000000RUDA', '0001G41000000018WA93', '0001G41000000018WA8R', '1155651000000000POF9', '0001G41000000018WA68', '000165100000000GF6RD', '1155651000000000RWPG', '1155651000000000VS88', '1155651000000001AL01', '1155F11000000001QYZR', '1155651000000000WZWT', '1155G4100000000297A0', '11556510000000004Z0R', '11556510000000001EBA', '1155651000000000AIAU', '1155G410000000028BCN', '000165100000000GCOWA', '1155651000000001BM0V', '000165100000000ENDYB', '115565100000000015OM', '000165100000000FRLZF', '000165100000000DR0UR', '000165100000000DR0V3', '0001G41000000018WABG', '11556510000000007NNY', '11556510000000000YRH', '0001G41000000018WABL', '000165100000000GD65G', '0001651000
00000DR0TS', '000165100000000DR0U4', '1155G410000000026CDL', '000165100000000HMH3V', '115565100000000012AO', '115565100000000018SY', '11556510000000000U7K', '1155651000000000SYIS', '1155651000000000CO2Y', '1155G410000000025RE6', '0001G41000000018WA9A', '11556510000000016HBP', '000165100000000FRTIN', '1155G410000000026U0W', '1155G410000000027YV2', '1155651000000000R2U0', '1155651000000000WATS', '1155G41000000001KYAC', '11556510000000000WXL', '1155G4100000000257OY', '0001G41000000018WA80', '0001G41000000018WA7O', '11556510000000001CNE', '1155G41000000002CYDA', '000165100000000FRYPU', '000165100000000DR0VE', '000165100000000D22KJ', '115565100000000012RT', '000165100000000FRYOD', '1155G410000000026IWU', '000165100000000GFPGK', '115565100000000018UJ', '11556510000000000U8Z', '1155651000000000CAI4', '000165100000000GF6R1', '1155G410000000026BB8', '1155651000000000163A', '000165100000000FRYOJ', '1155G41000000002CX2V', '1155651000000000RGMZ', '1155G410000000026VBM', '1155G41000000001N4JJ', '11556510000000009T15', '1155G410000000028BCJ', '1155G41000000001OTSH', '1155F110000000021LDC', '1155651000000001BQDR', '1155651000000000POKW', '1155G41000000002C1CF', '0001G41000000018WAB7', '0001G41000000018WAAV', '11556510000000001CPM', '1155G410000000026V68', '1155651000000000XSQL', '115565100000000018XN', '115565100000000015OZ', '1155G410000000026BSJ', '000165100000000DR0T2', '000165100000000DR0WK', '1155G41000000002C1F2', '1155651000
000001C2SQ', '11556510000000001NME', '11556510000000000U98', '11556510000000000U8W', '11556510000000001PBT', '000165100000000DOE9S', '000165100000000ENDY6', '1155G410000000026S85', '0001G41000000018WACF', '0001G4100000001ITGA9', '1155F11000000001ZHHK', '000165100000000GF6P1', '11556510000000000U7G', '1155G41000000002CVZY', '115565100000000015OJ', '1155G41000000002O5GV', '1155G410000000026RTI', '115565100000000015R5', '000165100000000GF6W3', '115565100000000014TA', '000165100000000GFPGX', '000165100000000DR0TE', '1155G41000000002C1BQ', '1155G41000000001WO2D', '000165100000000D25KT', '000165100000000D25L5', '1155651000000000AI7T', '1155651000000000CSRF', '0001G41000000018WA65', '1155651000000000CMJS', '000165100000000FUKN4', '1155651000000000SEMZ', '1155G410000000026KYJ', '000165100000000FRLZZ', '1155651000000001C6S4', '115565100000000076HO', '1155651000000000XUJO', '1155G410000000026CJS', '1155651000000000PCTM', '1155G41000000001XAOK', '1155G41000000002391G', '000165100000000FUKN3', '11556510000000000U52', '11556510000000000U4Q', '000165100000000GCOVN', '1155G410000000028BC7', '000165100000000FRYOY', '000165100000000CUX06', '1155651000000000C9KN', '1155G41000000001JQH8', '1155651000000000YGYJ', '11556£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡àÖ£¿£¿Ò»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶£¿Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿…¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿Ò»£¿£¿£¿£¿
¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡àÖ£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿
£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Ü¥£¿£¿‚t£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡«Ò»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿«…¸£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶‰Þ‚t£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶…¸£¿ƒx£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡†eàÖ£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿ƒxµ¶Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†eÔÈ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿¡¡£¿àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿¡¡£¿‰Þ£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿¡¡Ü¥‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‰Þ£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿àÖ£¿£¿…¸£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶‡óÜ¥ƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ƒx£¿àÖÒ»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Š»£¿£¿Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó‰ÞÜ¥£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡‰Þ†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿Ü¥Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿àÖ«£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿ƒx£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿†eÜ¥£¿£¿£¿£¿£¿
£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿µ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Ò»£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿ƒx£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡àÖ£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶‰Þ‚t£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿µ¶ÔÈ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ÔȆe¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿àև󣿣¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡00004Z0O', '1155651000000000XUM5', '1155651000000000PBOL', '1155651000000000RP9E', '1155651000000000RUDB', '0001G41000000018WA7C', '1155G41000000002CY7I', '1155G410000000027VLL', '1155651000000000UCAX', '000165100000000DR0US', '000165100000000DR0V4', '11556510000000019891', '1155651000000000RGTV', '1155F11000000001QYZQ', '1155F11000000001ZS6F', '0001G4100000001ANIUE', '000165100000000GHKJG', '115565100000000
018TF', '1155G41000000001N76U', '115565100000000164LT', '1155G410000000026R9G', '1155G41000000002NKPU', '1155G41000000002CFDZ', '1155651000000001BM0U', '0001G41000000018WA8D', '1155651000000000BXVG', '000165100000000FRTFN', '1155G41000000002CVSB', '1155651000000000WBOZ', '000165100000000FRTJ0', '000165100000000FRTIO', '0001G41000000018WABH', '11556510000000005TOL', '11556510000000000N6V', '000165100000000I0KF0', '1155651000000000TD0X', '11556510000000001CNF', '0001G41000000018WABK', '1155651000000000RWPH', '0001G41000000018WA9B', '1155G41000000002CWYG', '11556510000000000U8G', '000165100000000FTC1Q', '0001651000000012BOTN', '115565100000000018T7', '115565100000000018SV', '000165100000000DR0TT', '000165100000000DR0U5', '11556510000000016S5B', '11556510000000000U6Z', '000165100000000GFPGH', '115565100000000012AL', '11556510000000018RK2', '1155G410000000026WRK', '115565100000000018UI', '0001G41000000018WA94', '0001G41000000018WA8S', '000165100000000GFPF9', '1155651000000000CAI5', '000165100000000FRYOI', '1155G41000000001LU23', '000165100000000HMH3W', '11556510000000004YK9', '000165100000000G1M8M', '11556510000000001562', '1155G41000000001KYEK', '1155651000000000UBZ8', '000165100000000DR0VD', '000165100000000D22KK', '1155651000000000WATT', '1155651000000001HH6J', '1155G41000000002KA41', '115565100000000015OY', '000165100000000DR0T5', '000165100000000DR0ST', '000165100000000DR0WL', '1155G41000000002CWYJ', '0001G4100000001
8WA96', '0001G41000000018WA8U', '1155651000000000163B', '1155G410000000026WN8', '1155651000000000CBUS', '0001G41000000018WABI', '000165100000000GF6QS', '000165100000000GF6R4', '000165100000000GHKN5', '0001G41000000018WAB8', '0001G41000000018WAAW', '1155651000000001FDJI', '115565100000000018VI', '1155G41000000002CWJP', '11556510000000001CRQ', '0001G41000000018WAAY', '1155G410000000028BCI', '1155651000000000SJ1S', '000165100000000FRYOK', '000165100000000GD65H', '1155651000000000YLDP', '11556510000000001NM5', '1155G41000000001LDC1', '1155651000000000X86Y', '000165100000000ENDXV', '1155G410000000026RTH', '11556510000000018RK7', '000165100000000GF6VS', '000165100000000I3OKA', '115565100000000014TO', '11556510000000004YK8', '000165100000000DOE9R', '115565100000000019JI', '1155F11000000002RHTX', '000165100000000GHXH2', '0001G41000000018WA79', '0001G41000000018WA6X', '1155G41000000002C1C3', '1155G41000000002C1BR', '000165100000000G1M8B', '000165100000000DR0TR', '000165100000000DR0U3', '11556510000000001CM3', '11556510000000004HJI', '1155651000000001BQDQ', '1155651000000000CGCP', '1155G410000000029JBB', '1155G41000000002CWXY', '115565100000000018ZB', '11556510000000000WZB', '1155G410000000027QF2', '000165100000000GF6P2', '1155G410000000026R9F', '1155G410000000028LL0', '000165100000000BYOQB', '1155651000000000XUJN', '11556510000000008HL2', '1155651000000000CMJT', '1155G41000000001LVJX', '11556510000000001CMQ', '115565100000000
01CN2', '11556510000000000ZY8', '000165100000000FRTIA', '1155F11000000001R1JW', '1155G410000000027QRY', '1155651000000000BQ3S', '11556510000000000U6J', '1155651000000000PZF2', '11556510000000001C31', '000165100000000FRTJO', '1155G41000000001WOEN', '11556510000000000U9G', '11556510000000000WZ1', '11556510000000000WYP', '1155G41000000001MWDF', '1155G41000000001XAOJ', '1155G410000000026J39', '1155G410000000026DLW', '115565100000000012RH', '1155651000000000WYZ9', '000165100000000FRTGE', '11556510000000001COF', '1155G410000000026U3U', '1155651000000001C0FW', '000165100000000DO9SH', '1155651000000000WZ3L', '1155651000000000ONCI', '1155G41000000002B616', '1155G41000000002B18I', '000165100000000DR0VL', '11556510000000000YUE', '000165100000000GF6RT', '000165100000000GNZN9', '000165100000000GHKK3', '1155651000000001BUZZ', '000165100000000FRTJV', '000165100000000FRTI1', '1155651000000001I4XY', '0001G41000000018WA9R', '11556510000000000U4B', '1155G41000000002CVSC', '1155F11000000001Y0NA', '11556510000000019892', '0001G41000000018WA6H', '11556510000000001CMA', '1155651000000000XUM4', '1155G41000000002CDBZ', '11556510000000007IXW', '11556510000000000U5B', '1155651000000000W352', '1155651000000000UBZ7', '1155G4100000000272UQ', '1155G41000000001PTEN', '0001651000000013W175', '1155G410000000025XKI', '11556510000000000U5Z', '1155651000000000RJLK', '1155G41000000002AY42', '000165100000000GF6RB', '1155651000000001CBB2', '1155G4100000000
27RF6', '000165100000000GD65X', '1155651000000001A0OZ', '11556510000000001CMR', '11556510000000001CN3', '11556510000000004Z0P', '1155G41000000002BRHI', '115565100000000012R9', '11556510000000000U53', '11556510000000000U4R', '1155651000000000C9KM', '1155F11000000001Y1QH', '11556510000000000N6G', '000165100000000FRYOZ', '1155651000000000RP9D', '000165100000000DR0UT', '000165100000000DR0V5', '1155651000000000166I', '000165100000000D25KU', '000165100000000D25L6', '0001G41000000018WA7B', '1155651000000000CYUS', '000165100000000FRWXP', '11556510000000007NO0', '0001G41000000018WA66', '1155F11000000001ZS6E', '0001G4100000001ANIUD', '115565100000000018YA', '11556510000000000WYA', '1155G41000000002CY7J', '115565100000000018ZQ', '11556510000000000WZQ', '0001G41000000018WA9C', '1155G410000000026WAT', '11556510000000007YKA', '1155G410000000027VLK', '1155G41000000002CWY9', '1155G41000000002CWXX', '1155651000000001AAZB', '1155G41000000001L2RM', '1155651000000000CGCQ', '1155G41000000001JSIQ', '115565100000000018UZ', '1155G41000000002AH20', '0001G41000000018WA8E' ) OR bd_cumandoc.pk_cumandoc IN ( '11556510000000000U63', '11556510000000000U5R', '1155651000000000W4VU', '1155G410000000026BSI', '1155G41000000002979Z', '000165100000000GFPGI', '000165100000000G1M8L', '000165100000000DR0TU', '000165100000000DR0U6', '000165100000000FRTJ1', '000165100000000FRTIP', '1155G410000000027QFB', '0001G41000000018WA82', '0001G41000000018WA7Q', '11556510
00000001FDPW', '1155G410000000025YEH', '000165100000000GHKN2', '1155G41000000001LU22', '1155651000000000XR7B', '0001G41000000018WA95', '0001G41000000018WA8T', '1155651000000000RGSI', '1155F110000000020UFK', '11556510000000001PBS', '0001651000000012BOTO', '11556510000000000WWL', '11556510000000000N78', '11556510000000000N6W', '000165100000000ENDY8', '000165100000000ENDXW', '000165100000000GVITN', '000165100000000FRYPW', '1155651000000000AIVL', '1155651000000000V896', '11556510000000018SPD', '1155G41000000001T8LE', '0001G41000000018WAC2', '0001G41000000018WABQ', '1155G41000000002CEP6', '000165100000000GNZNC', '115565100000000018ZM', '11556510000000000WZM', '000165100000000FVLIX', '000165100000000FVLJ9', '1155G410000000026CJA', '000165100000000FRTIJ', '11556510000000018GB7', '1155G41000000001M5PO', '000165100000000FRTGP', '000165100000000DR0WU', '0001G41000000018WA9D', '115565100000000019JB', '115565100000000018R7', '1155651000000000X5Z0', '000165100000000GHKN4', '115565100000000018XY', '11556510000000000WXY', '11556510000000001CMN', '000165100000000DR0UP', '000165100000000DR0V1', '1155651000000001HH6C', '11556510000000018XN9', '000165100000000EYC9T', '1155G41000000002CWMZ', '1155G41000000002C75D', '000165100000000FRLZK', '1155G410000000023I3R', '11556510000000005TOM', '11556510000000000N75', '1155651000000001934V', '000165100000000GEY49', '1155G410000000026XL5', '1155651000000000TF78', '11556510000000009QIB', '1155G410
000000026BE1', '1155651000000000T4CO', '1155651000000000R80I', '000165100000000FRTJA', '000165100000000PLV2L', '0001G41000000018WA63', '000165100000000GFPGG', '000165100000000PXO6H', '11556510000000004Z0V', '000165100000000DR0T0', '11556510000000008J5M', '1155G41000000001WOEO', '1155G41000000001WOF0', '1155G41000000001QLVO', '11556510000000000YQ2', '1155G410000000026R9S', '1155651000000000RJLJ', '000165100000000GFPG7', '1155651000000000RGSH', '1155G410000000026WAQ', '115565100000000014TF', '0001G41000000018WA7L', '000165100000000GF6UZ', '115565100000000012RE', '1155G410000000027630', '000165100000000G1M89', '1155G410000000023HGK', '11556510000000006BNJ', '1155G410000000026B9Q', '000165100000000BYOQC', '000165100000000DR0UB', '000165100000000FRYPG', '1155G41000000002EAUN', '1155651000000001C2TJ', '11556510000000000U43', '11556510000000000U3R', '000165100000000FRTJR', '115565100000000018VB', '1155G410000000020ICH', '1155651000000000ONNU', '11556510000000019FSZ', '1155F110000000020TET', '1155G410000000028CH2', '11556510000000000U8N', '1155G41000000002CXLP', '1155651000000000RPP2', '1155G41000000002CWU2', '000165100000000DR0VW', '000165100000000DR0W8', '1155651000000000OP1V', '115565100000000015AM', '115565100000000067SG', '1155F11000000001Y80C', '115565100000000011UC', '000165100000000D25LF', '11556510000000000WXH', '11556510000000000WW5', '11556510000000000WVT', '000165100000000DR0VA', '000165100000000LKSM1', '1155G410
00000002B617', '11556510000000000X0B', '1155651000000000190B', '1155G410000000026BT1', '1155651000000001FDJJ', '000165100000000FUH5S', '11556510000000004YJZ', '1155G41000000001MSN7', '1155F11000000001Y1PE', '115565100000000018WE', '11556510000000000WWE', '0001G41000000018WA9S', '11556510000000008AMD', '1155G41000000001PTEK', '1155G4100000000271UY', '11556510000000008J5H', '1155651000000000B7K9', '1155G410000000022X0P', '000165100000000FRTJK', '1155G410000000026J38', '000165100000000DR0U0', '000165100000000DR0TO', '000165100000000I8O76', '1155651000000000TN5Y', '11556510000000001CRF', '11556510000000001CNQ', '11556510000000001CO2', '000165100000000FRTHQ', '000165100000000DO9SN', '1155651000000000B5KL', '1155651000000000WZWU', '11556510000000009QKZ', '1155G410000000026E8O', '11556510000000000R0A', '0001G41000000018WA6C', '1155F11000000001Y0NB', '000165100000000GNZN8', '115565100000000011V4', '115565100000000011US', '000165100000000GFPFE', '1155G410000000027RF7', '11556510000000000N68', '11556510000000000N5W', '000165100000000KPOFM', '000165100000000FRYOW', '000165100000000FRYP8', '1155G41000000001W1W9', '1155651000000000ONNV', '1155651000000001F18P', '115565100000000018W2', '115565100000000018VQ', '11556510000000000WW2', '0001G41000000018WA8M', '1155G4100000000239CF', '1155651000000001AL02', '000165100000000DR0VG', '0001G41000000018WAB1', '0001G41000000018WAAP', '1155G410000000027280', '1155651000000000QKUF', '00016510
0000000FRYOG', '000165100000000D25LE', '1155651000000000UPKG', '1155G41000000002CXG9', '1155651000000001601L', '000165100000000FRTJ2', '000165100000000FRTIQ', '1155G410000000027QF7', '1155651000000000TMPP', '115565100000000018ZN', '11556510000000000WZN', '000165100000000GVITO', '0001G41000000018WACB', '1155G410000000026X6K', '000165100000000FRYOQ', '000165100000000FRYP2', '000165100000000FRWXB', '000165100000000DR0TA', '11556510000000000U7N', '1155651000000000WZV5', '000165100000000GD65U', '000165100000000ENDY5', '1155G410000000027WKS', '000165100000000ENDYL', '1155651000000000D9OS', '1155651000000000XAEW', '1155G41000000002FRB6', '000165100000000FVLSX', '1155651000000000SJ1T', '115565100000000018SJ', '1155F110000000020WGY', '11556510000000009SWI', '11556510000000016HBQ', '11556510000000019KHS', '1155G410000000026BAJ', '0001G41000000018WACL', '1155G41000000001O2T7', '1155G41000000001OTEE', '1155F11000000001YZLY', '115565100000000018V2', '115565100000000018UQ', '1155651000000000159H', '000165100000000G1M8Q', '000165100000000G1M92', '1155G41000000001MKII', '115565100000000018YJ', '1155G41000000001JSVT', '1155G41000000002CEP7', '1155G410000000023F7H', '1155651000000000O5M3', '1155F110000000021LDB', '1155G410000000026YFQ', '1155651000000000POKX', '11556510000000019LIN', '1155G41000000001OTSI', '000165100000000FRLZU', '11556510000000001COR', '11556510000000001CP3', '115565100000000018UN', '115565100000000018R6', '00016510
0000000FRLZJ', '000165100000000FRTHG', '000165100000000DR0WH', '115565100000000064TD', '1155651000000000WRWD', '1155G410000000026XG5', '000165100000000EYC9U', '1155G41000000001X3X7', '1155G410000000023I3Q', '1155G41000000001WO2C', '11556510000000000WX9', '11556510000000000WWX', '1155651000000000TD0E', '115565100000000011UD', '000165100000000FRTFK', '000165100000000FRTJB', '11556510000000009QIA', '1155G410000000026XL8', '1155G41000000002CVZX', '000165100000000PLV2K', '115565100000000018XZ', '000165100000000DR0T3', '1155G41000000001JSIX', '115565100000000012BJ', '1155651000000000R80J', '11556510000000001902', '11556510000000000X02', '1155651000000000AYC8', '000165100000000DR0UO', '000165100000000DR0V0', '1155651000000000A0L2', '000165100000000GFPGD', '1155G410000000026X6J', '0001G41000000018WA64', '115565100000000018RF', '1155G410000000026CJR', '000165100000000DR0VV', '000165100000000DR0W7', '1155F11000000001YD9P', '11556510000000001CQB', '1155G410000000026BE0', '115565100000000015AN', '0001G41000000018WA7K', '11556510000000001CZC', '11556510000000000U42', '11556510000000000U3Q', '1155651000000001A337', '000165100000000D25KV', '000165100000000D25L7', '1155651000000001BFVR', '000165100000000FRYPQ', '1155651000000000DAIC', '1155651000000000DAEH', '11556510000000006BNK', '11556510000000001P97', '1155G41000000002C1BA', '1155F11000000001ZHFX', '1155G410000000026C9S', '11556510000000011HQO', '11556510000000001CQE', '0001G410
00000018WAC1', '0001G41000000018WABP', '000165100000000FRYPH', '1155G41000000001JQFZ', '11556510000000000X0A', '1155651000000000190A', '1155651000000000OP1U', '1155G410000000026CK0', '1155G4100000000239CE', '1155651000000001519X', '000165100000000DR0UA', '1155G41000000002BDRL', '11556510000000005STU', '1155G41000000001O1KC', '1155651000000001AAZI', '1155651000000000BT5N', '1155651000000000VBCT', '000165100000000FRYPA', '11556510000000000U90', '11556510000000000U8O', '1155651000000001BGEV', '0001G41000000018WACK', '1155G41000000002C1CG', '1155F11000000001YW0N', '1155651000000000RPI0', '1155651000000000QKUE', '1155G410000000028CH1', '000165100000000FRTJQ', '1155G41000000001LKCO', '000165100000000DR0TL', '000165100000000D25LG', '000165100000000GD65V', '1155651000000000RGN0', '000165100000000DR0VF', '115565100000000067SF', '1155651000000000D7D8', '1155651000000000WRWK', '1155G41000000001MSN6', '1155G410000000026IX2', '115565100000000018WF', '1155G410000000026BT0', '11556510000000001CNR', '11556510000000001CO3', '11556510000000004YJY', '1155651000000000AIUZ', '1155G41000000001OTED', '000165100000000I8O75', '1155651000000000WBO5', '115565100000000018TM', '1155G41000000002CVOC', '11556510000000007X0Z', '1155651000000000PJ55', '1155G41000000002BMZX', '000165100000000ENDYK', '1155F11000000001Y6RK', '11556510000000000R0B', '1155651000000000T42U', '000165100000000FRYOP', '000165100000000FRYP1', '000165100000000GFPGW', '11556510
00000000TN5Z', '1155651000000001C7CH', '1155F11000000001Y1PD', '11556510000000000ZQ1', '1155G41000000002R4Q1', '0001G41000000018WA8N', '1155G410000000027VMK', '0001G41000000018WA9T', '1155651000000001F18U', '0001G41000000018WAB2', '0001G41000000018WAAQ', '11556510000000001P96', '11556510000000000WW1', '000165100000000GFPFF', '11556510000000001COA', '1155651000000001F53P', '1155651000000000YLDU', '1155G41000000002DRP7', '115565100000000164LU', '1155651000000000D9OT', '000165100000000DR0WX', '11556510000000001CNA', '11556510000000007NNU', '1155G41000000002CVU6', '000165100000000FRWXA', '11556510000000000U80', '11556510000000000U7O', '11556510000000004X6N', '1155G410000000028S48', '1155G410000000026WVZ', '0001G41000000018WA6B', '1155G41000000002FGY9', '11556510000000004XJ5', '1155G41000000001J1RD', '1155G410000000028BCR', '1155G41000000002CMEW', '115565100000000064TE', '000165100000000D25LD', '1155G41000000001N76V', '1155651000000000TF79', '1155651000000000YDH1', '1155G41000000001JQFY', '1155651000000001601K', '1155651000000000RPAQ', '1155651000000000Y7RO', '11556510000000019LSD', '000165100000000GF6QX', '000165100000000GF6R9', '1155G410000000026V0W', '0001G41000000018WACA', '1155G410000000026CBE', '115565100000000011V5', '115565100000000011UT', '1155G410000000022W0X', '1155651000000000159I', '11556510000000019LIM', '000165100000000FRTGO', '115565100000000012AK', '0001G41000000018WA9E', '1155651000000000SYR6', '00016510
0000000FRLZ9', '000165100000000GEY4E', '1155651000000000RWPK', '11556510000000001COQ', '11556510000000001CP2', '115565100000000018YI', '11556510000000000WYI', '1155F110000000026HO2', '000165100000000G1M93', '115565100000000015OI', '115565100000000018UM', '1155F11000000001Y1SK', '000165100000000DR0WG', '1155651000000000B5F9', '115565100000000012BI', '1155G41000000002CWJO', '000165100000000FRTF1', '11556510000000001CAI', '000165100000000FRTJL', '1155651000000001F5AT', '000165100000000FRTIZ', '000165100000000FRTFJ', '1155651000000000C9NU', '11556510000000001CQF', '000165100000000DR0TC', '1155G410000000029KSH', '1155651000000000R78W', '11556510000000000U70', '11556510000000000U6O', '115565100000000015P7', '115565100000000015OV', '1155G410000000026CJV', '000165100000000FVLNE', '11556510000000001903', '11556510000000000X03', '11556510000000001CQR', '11556510000000001CR3', '000165100000000FRLZI', '115565100000000018WY', '11556510000000000WWY', '11556510000000018WEY', '1155F11000000001XQUP', '11556510000000011HQN', '1155651000000001F58O', '0001G41000000018WA61', '1155G410000000026R9C', '1155651000000001BFVQ', '1155651000000000DAID', '1155651000000001HHC8', '1155651000000000WRWG', '000165100000000FVLIZ', '1155651000000000A0L3', '11556510000000009QKY', '1155G410000000023HPL', '000165100000000DR0UN', '0001G41000000018WA76', '0001G41000000018WA6U', '1155651000000000TD0D', '115565100000000018W3', '115565100000000018VR', '11556510
0000000018XJ', '115565100000000018RI', '11556510000000000ZQ0', '1155G41000000002I53P', '000165100000000G1M87', '1155G41000000002C1BU', '115565100000000018TJ', '115565100000000018YM', '11556510000000000WYM', '0001G41000000018WAC0', '0001G41000000018WABO', '000165100000000HKCDI', '11556510000000000U3E', '11556510000000004IBY', '115565100000000162EN', '11556510000000008PXK', '1155G410000000026YIY', '000165100000000D25KW', '000165100000000D25L8', '1155F11000000001Y5NM', '000165100000000DR0VY', '000165100000000G1M86', '11556510000000005SUF', '11556510000000012Y9S', '1155G410000000029D34', '11556510000000001CQQ', '11556510000000001CR2', '000165100000000FRTHF', '0001G41000000018WA91', '0001G41000000018WA8P', '000165100000000FRM01', '000165100000000H2MT8', '000165100000000ENDYF', '1155651000000000129C', '11556510000000007NNZ', '11556510000000005SU3', '1155G41000000002BDRM', '11556510000000000U5F', '1155G410000000028CSO', '000165100000000GFPG8', '11556510000000001CZD', '1155651000000001BGEW', '0001G41000000018WACJ', '11556510000000001RBC', '1155F11000000001ZHFW', '1155G41000000002CVZE', '0001G41000000018WABC', '1155651000000000PJ56', '000165100000000GF6RN', '0001G41000000018WA7N', '000165100000000FRYPE', '000165100000000Q4NE3', '000165100000000LKSM2', '0001G41000000018WA6E', '000165100000000FRYOU', '000165100000000FRYP6', '1155651000000000VQBD', '1155651000000000PCUJ', '0001G41000000018WA60', '11556510000000009A4F', '11556510
00000000AI6K', '11556510000000019XZK', '000165100000000D25LH', '1155G410000000026UK7', '000165100000000DR0VI', '11556510000000000U56', '11556510000000000U4U', '0001G41000000018WA73', '0001G41000000018WA6R', '1155F11000000001Y6RL', '1155651000000000A0LG', '1155F110000000021JFY', '1155G410000000027ZBO', '1155G410000000029AML', '1155651000000000126U', '1155G410000000026U3N', '000165100000000GHKOD', '0001G41000000018WAB3', '0001G41000000018WAAR', '0001G41000000018WA9U', '11556510000000001CPR', '11556510000000001CQ3', '11556510000000008J5J', '1155G410000000026ZHE', '1155651000000000BR66', '1155651000000000R2P9', '1155G41000000002B2FD', '1155651000000000CGF2', '11556510000000001CRB', '115565100000000015O6', '1155651000000000TSJC', '1155G410000000026BCP', '000165100000000DR0WW', '1155651000000000AIAV', '1155651000000000YDH0', '1155651000000001BIU0', '000165100000000GF6R0', '1155651000000000Y7RP', '1155G41000000002BMZW', '1155651000000001FDP9', '1155G41000000002CWGH', '11556510000000004Z0S', '1155651000000000PZGC', '1155G41000000002CYDB', '000165100000000DR0TP', '000165100000000DR0U1', '000165100000000FRWXM', '1155G41000000002L9R6', '1155651000000000RWPL', '000165100000000GAE20', '1155G410000000026IZJ', '11556510000000000N74', '11556510000000000N6S', '1155G410000000028BCM', '1155G41000000002A7JF', '000165100000000ENDXZ', '11556510000000019LSC', '1155G41000000001J1RC', '11556510000000001CRU', '11556510000000000U4E', '11556510
000000001CNB', '11556510000000005SUE', '000165100000000D25LC', '000165100000000GD65F', '1155651000000000RPAR', '1155G41000000001WOES', '000165100000000GD65S', '000165100000000GD664', '11556510000000000N6B', '1155G41000000002A7JG', '1155651000000000WRWH', '0001G41000000018WA90', '0001G41000000018WA8O', '0001G41000000018WA9F', '1155651000000000CTF6', '1155F110000000026HO3', '115565100000000018SZ', '11556510000000000DW2', '1155G410000000022W0W', '000165100000000FRYOE', '1155G410000000029A52', '115565100000000015OF', '000165100000000G1M8O', '000165100000000G1M90', '000165100000000KG3WB', '11556510000000000WYL', '000165100000000DR0WJ', '115565100000000012NT', '000165100000000GCOV9', '1155G410000000029KSG', '000165100000000DR0UM', '1155651000000000QBJU', '1155651000000000VPZ7', '1155651000000001F5AU', '1155651000000001FDJE', '1155G41000000002CWYF', '000165100000000GNZND', '11556510000000000U6N', '1155651000000001HHC7', '1155G410000000026R9B', '1155G41000000002CXLQ', '11556510000000000YQ3', '11556510000000001NM9', '000165100000000FVLNF', '0001G41000000018WABN', '1155G41000000002C75G', '1155G410000000024UZJ', '1155G41000000001NVXC', '0001G41000000018WABE', '1155G41000000002CVWA', '11556510000000007PSO', '000165100000000FVLIW', '1155651000000000VBC9', '1155651000000000V88R', '1155G410000000026DLX', '0001G41000000018WA62', '115565100000000018VE', '1155651000000000CQD2', '000165100000000DR0T1', '1155G410000000027QF6', '11556510
000000018Y5A', '1155651000000000WAVZ', '1155F11000000001Y483', '1155651000000000RPOV', '1155651000000000T4CN', '11556510000000016I9K', '1155651000000000SWWD', '000165100000000FTC1R', '11556510000000001E9A', '115565100000000018WZ', '11556510000000000U3F', '0001G41000000018WA7M', '1155G410000000026C9R', '115565100000000162EM', '1155651000000000TSJD', '11556510000000001COB', '000165100000000GFPG9', '1155651000000000SYR7', '1155651000000000162O', '000165100000000FRYPF', '11556510000000005SU4', '000165100000000GFPG6', '1155G41000000002C1C7', '1155G41000000002C1BV', '0001G41000000018WACI', '1155G41000000002BV0G', '000165100000000GF6TK', '1155651000000000BR65', '11556510000000009QKU', '000165100000000FVJ4X', '000165100000000D25KX', '000165100000000D25L9', '000165100000000DR0VX', '000165100000000DR0W9', '1155G41000000002A3E7', '115565100000000019JE', '11556510000000012Y9R', '000165100000000FRTGT', '000165100000000G1M88', '115565100000000012RD', '0001G41000000018WA75', '0001G41000000018WA6T', '000165100000000G1M8F', '000165100000000GS9Q7', '1155651000000001C2TI', '0001G41000000018WABD', '1155651000000001B77D', '000165100000000GF6RO', '1155G4100000000271OM', '0001G41000000018WA8A', '11556510000000001CAH', '1155651000000000XKFI', '11556510000000019FSY', '000165100000000Q4NE2', '000165100000000FRM02', '11556510000000008PXL', '1155G410000000026RA8', '11556510000000000U5E', '1155F110000000020TEU', '000165100000000FRLZW', '00016510
0000000I0KEZ', '11556510000000008J7J', '1155651000000000AFUE', '1155G410000000028RAJ', '115565100000000018XI', '11556510000000000WXI', '11556510000000018GB6', '11556510000000008J5G', '000165100000000H2MT7', '000165100000000GS9NI', '1155651000000000SEMY', '11556510000000001CRE', '1155651000000000XKFJ', '11556510000000019JPY', '1155651000000000A0LF', '115565100000000150XZ', '000165100000000DR0VH', '000165100000000FUH5R', '1155G41000000001JSVS', '11556510000000000N6C', '1155651000000000VBJM', '115565100000000018VN', '1155651000000001A336', '000165100000000GHKOC', '000165100000000DO9SM', '11556510000000019XZJ', '1155G410000000026UK8', '1155G41000000002F56T', '000165100000000FVLSW', '000165100000000FRYOV', '000165100000000FRYP7', '0001G41000000018WA6D', '11556510000000001CPQ', '11556510000000001CQ2', '11556510000000001CMM', '000165100000000DR0TQ', '000165100000000DR0U2', '1155G410000000026ZHF', '115565100000000015O7', '1155G410000000024XDE', '0001G41000000018WA74', '0001G41000000018WA6S', '1155651000000000BRB1', '1155651000000000126V', '000165100000000DR0TN', '1155G41000000002CVUD', '000165100000000GD65E', '1155651000000000CGF1', '1155G41000000002BWV9', '11556510000000000ZZR', '0001G41000000018WAB4', '0001G41000000018WAAS', '11556510000000001CRA', '11556510000000000WWH', '1155G41000000001MJJT', '11556510000000000U57', '11556510000000000U4V', '1155G41000000002B2FE', '1155G41000000002JAAN', '0001G41000000018WA9V', '11556510
00000000VQBC', '11556510000000000N67', '11556510000000000N5V', '11556510000000000N6R', '1155651000000001AAZF', '1155G410000000022X0Q' ) OR bd_cumandoc.pk_cumandoc IN ( '1155651000000000CQD3', '11556510000000000U4F', '1155651000000000PZGB', '1155651000000000CTF7', '000165100000000FRTIE', '1155651000000001A0DN', '000165100000000FRWXC', '11556510000000001CRV', '1155G41000000002C1C8', '1155G410000000027WKR', '000165100000000FRYOF', '000165100000000DR0VC', '1155651000000000WZV4', '000165100000000GD65T', '000165100000000GD665', '1155F11000000002Q36C', '11556510000000019JPX', '11556510000000019KHT', '115565100000000018SI', '1155F11000000002IW0P', '11556510000000000DW3', '0001G41000000018WA9G', '0001G41000000018WAB5', '0001G41000000018WAAT', '000165100000000GH9U9', '000165100000000KG3WC', '000165100000000G1M8P', '000165100000000G1M91', '000165100000000FRTHL', '1155651000000000PCUI', '1155651000000001I4NG', '1155G410000000023F7G', '1155G410000000026WRJ', '1155G41000000001MAMH', '11556510000000016JUZ', '0001G41000000018WA9H', '115565100000000018WB', '1155G41000000001O33D', '115565100000000018U3', '115565100000000018TR', '115565100000000012M5', '11556510000000000WXD', '1155651000000000W33K', '000165100000000FRTHD', '1155F11000000001Y1RO', '115565100000000012RQ', '11556510000000015UPT', '1155G410000000028BCV', '000165100000000D25LB', '1155F11000000001Y0NE', '11556510000000004ID2', '000165100000000GCOV8', '0001G41000000018WA70', '0
001G41000000018WA6O', '0001G41000000018WA8J', '1155651000000000BXYX', '1155G410000000023F7D', '0001G41000000018WACO', '1155651000000000RPHZ', '11556510000000000U93', '11556510000000000U8R', '1155651000000000Y7RS', '1155651000000000169Y', '1155651000000000WYGS', '000165100000000G1M8V', '1155651000000000YH64', '1155651000000001FDJF', '1155G41000000002F8JT', '11556510000000000U9C', '0001G4100000001I0WI2', '000165100000000GHXHE', '000165100000000D25KY', '1155G41000000001KYFF', '115565100000000018X2', '115565100000000018WQ', '11556510000000000WX2', '11556510000000000WWQ', '1155G41000000001JSIY', '1155G41000000001O2T6', '1155G41000000002F56L', '1155651000000000O75Z', '115565100000000017B1', '1155651000000000126H', '115565100000000011UH', '115565100000000012L7', '000165100000000RQCQS', '0001G41000000018WA9X', '1155F110000000021JEW', '1155G41000000002K7NS', '1155651000000000BXVL', '11556510000000016A8Y', '0001G41000000018WA89', '0001G41000000018WA7X', '000165100000000GFPGC', '11556510000000000X0F', '1155G41000000002CWTS', '000165100000000FRYPT', '000165100000000GS9NJ', '1155G41000000001LVLL', '000165100000000GD65P', '000165100000000GD661', '115565100000000018TA', '1155G41000000002ADQE', '1155651000000000V88Q', '115565100000000018Y6', '115565100000000018XU', '11556510000000000WY6', '11556510000000000WXU', '1155G41000000001JRRE', '1155G41000000002KS52', '1155G41000000001MWDE', '000165100000000FRTGS', '115565100000000018ZZ', '1
1556510000000000WZZ', '1155F110000000026HMB', '000165100000000G1M8W', '115565100000000018ZI', '11556510000000000WZI', '1155G41000000001MUCP', '000165100000000GF6RU', '1155651000000001C2UP', '1155651000000000RL82', '1155F110000000022MWB', '11556510000000005STZ', '1155G41000000002CY1R', '115565100000000014TJ', '1155651000000000B5KM', '0001G41000000018WAC7', '0001G41000000018WABV', '000165100000000GF6RK', '11556510000000009X97', '115565100000000011UG', '000165100000000H2MSU', '000165100000000GHKIM', '1155G41000000001LVJY', '000165100000000FRLZX', '11556510000000005STX', '000165100000000GAE21', '1155G410000000026C9O', '000165100000000DR0UL', '11556510000000018PCZ', '000165100000000DO9SK', '11556510000000000U7B', '000165100000000GDRBT', '1155G41000000002A3E8', '1155G410000000027WL0', '000165100000000FRTJN', '1155651000000000DAEG', '1155651000000000162N', '1155651000000000BR1M', '000165100000000FRYPD', '000165100000000GH9UE', '1155651000000001F18T', '1155G41000000002BXIW', '000165100000000UX3G0', '000165100000000GFPGR', '000165100000000DR0VS', '000165100000000DR0W4', '1155651000000001BITZ', '1155651000000000UCJ7', '1155F11000000001YZL3', '1155651000000000C9N6', '11556510000000018LI1', '1155651000000000B7JU', '000165100000000G1M8G', '000165100000000FRTIM', '000165100000000FRM06', '1155G41000000002JEWQ', '000165100000000DR0TK', '1155651000000000AIUY', '1155G41000000002CWDL', '1155F11000000001QWSO', '11556510000000000U83', '1
1556510000000000U7R', '11556510000000000WW9', '11556510000000000WVX', '11556510000000001CRJ', '1155F11000000001YD9M', '11556510000000005STY', '000165100000000GHKK2', '000165100000000FRLZP', '1155651000000000TJC2', '000165100000000FVJ4R', '1155651000000001F53Q', '115565100000000011UW', '11556510000000001COM', '1155G41000000002A2VL', '11556510000000006MNW', '11556510000000001CMJ', '0001G41000000018WA7I', '0001G41000000018WA9W', '1155G41000000002BSR6', '1155651000000000SWWE', '11556510000000004X6O', '0001G41000000018WA8Y', '115565100000000011T7', '000165100000000DR0WD', '1155651000000000R2TW', '1155G410000000028BCA', '1155G41000000002C1CJ', '1155G41000000002675S', '1155G41000000002CFE0', '1155G41000000002CWY2', '000165100000000GFPFA', '1155651000000000W33J', '1155G41000000001WOEQ', '1155651000000000D7D7', '115565100000000018V6', '115565100000000018UU', '1155651000000001C2SL', '000165100000000FRYOM', '1155651000000001I4NH', '11556510000000016IV5', '1155G4100000000287LY', '0001G41000000018WA7Z', '115565100000000018YF', '000165100000000FRTHM', '11556510000000000U3N', '000165100000000DR0TZ', '11556510000000001CMY', '11556510000000000WYX', '0001G41000000018WAAL', '1155F110000000022MWA', '1155G41000000002C1B6', '1155G41000000002CXGJ', '1155G41000000001WOEP', '000165100000000ENDY9', '1155651000000000YLDT', '11556510000000000U8B', '11556510000000009TH6', '1155651000000000X5UF', '1155651000000000STWN', '000165100000000D25LA', '1
1556510000000007NNX', '1155G410000000026X1V', '000165100000000FRTFW', '115565100000000015P6', '115565100000000015OU', '115565100000000018SN', '000165100000000CUWR8', '1155651000000000UB2H', '1155G41000000001M5PN', '1155F11000000001ZI2Z', '1155G41000000002D4HV', '11556510000000005TKU', '1155651000000000SEQ4', '0001G41000000018WA71', '0001G41000000018WA6P', '11556510000000000U9B', '1155G41000000002CX32', '000165100000000GF6RL', '1155651000000000126I', '000165100000000FRTJM', '1155G41000000002C1BZ', '115565100000000018RJ', '1155651000000000WYGR', '115565100000000015O3', '0001G41000000018WACN', '11556510000000001CNM', '11556510000000009X98', '1155F11000000001Y0NF', '1155651000000000CQDP', '1155G41000000002C1B7', '1155G41000000001O33C', '1155G410000000023F7E', '1155G410000000026YIX', '000165100000000£¿£¿£¿£¿†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ò»àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿«‰Þ£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿«£¿Š»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶µ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿ÔÈ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Š»£¿Ò»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿«£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿…¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿…¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿‚t£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ü¥£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡óµ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿àև󣿣¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡‚t£¿Ò»£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡‰Þ£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ò»‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡…¸£¿£¿Ü¥£¿£¿£¿£¿£¿£¿£¿£¿
£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿Ò»¡¡‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿Ü¥àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ÔÈ£¿‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿Š»£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿ƒx£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿Ü¥£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿…¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡µ¶£¿£¿Ü¥£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿«£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‡ó£¿£¿‡ó£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶…¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿µ¶¡¡†e‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡…¸Ò»‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿Š»£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†eÜ¥£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿µ¶àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿†e£¿£¿ƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Ü¥¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿‡óµ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡µ¶£¿£¿£¿£¿£¿£¿£¿1556510000000019LJI', '000165100000000H2MST', '000165100000000FVJ4O', '115565100000000012M4', '115565100000000018Y7', '115565100000000018XV', '1155F11000000001Y80D', '1155G41000000002C1BE', '1155651000000
0000U7C', '000165100000000GCOV7', '000165100000000DR0WT', '000165100000000DR0UK', '11556510000000007OBI', '1155651000000000AI6J', '11556510000000001RBD', '000165100000000ERZ7A', '1155G410000000024REK', '0001G41000000018WA9Y', '0001G41000000018WAC6', '0001G41000000018WABU', '1155F110000000021JEX', '1155G410000000026WAP', '1155G41000000002CY1Q', '115565100000000018ZY', '11556510000000000WZY', '115565100000000018ZJ', '11556510000000000WZJ', '1155G410000000026XL4', '000165100000000D25KZ', '1155651000000000RL83', '000165100000000FUO11', '000165100000000ENDYO', '0001G41000000018WAA0', '1155G41000000002BXIV', '1155F11
000000001YD9L', '11556510000000000N64', '11556510000000000N5S', '1155G41000000002FIFW', '0001G41000000018WA72', '0001G41000000018WA6Q', '000165100000000DR0TH', '000165100000000GD65R', '1155F11000000001XF8B', '000165100000000DR0WQ', '1155G410000000027T9Q', '11556510000000006MNX', '000165100000000FRYPM', '000165100000000JOG05', '1155G4100000000271UZ', '000165100000000GFPGS', '1155G4100000000287LZ', '1155651000000001B77E', '000165100000000FRTHU', '1155G41000000002CVZF', '000165100000000FRLZO', '000165100000000DO9SJ', '11556510000000001CPF', '1155651000000000VE2O', '1155651000000000CAUY', '1155651000000000UMMK', '115565100000000067SJ', '11556510000000019LJH', '0001G41000000018WA7H', '1155651000000000C9N5', '11556510000000000U84', '11556510000000000U7S', '1155G41000000002675R', '1155G41000000002A2VK', '11556510000000000ZXE', '000165100000000FRWXN', '000165100000000FRTHN', '000165100000000CUWR7', '000165100000000GFPFB', '115565100000000011T8', '0001G41000000018WA8Z', '000165100000000DR0WC', '11556510000000008125', '1155G41000000002CVNM', '1155651000000000PEHU', '1155G410000000026X1U', '1155G410000000028BCB', '0001G41000000018WACE', '000165100000000GEY47', '000165100000000GF6W2', '1155G41000000002CWY1', '000165100000000GEY4A', '000165100000000GCOW9', '1155651000000000UY9Z', '000165100000000FRYOL', '115565100000000018UB', '1155G41000000001OF5X', '1155651000000001C2SM', '1155G41000000002ISNY', '11556510000000000U3I', '1155G41
0000000029AMK', '1155651000000001A0P0', '0001G41000000018WAAM', '1155651000000000STWM', '11556510000000001CPA', '1155F110000000020WGZ', '115565100000000018YE', '11556510000000000WYE', '11556510000000001906', '11556510000000000X06', '000165100000000DR0VR', '000165100000000DR0W3', '000165100000000GF6QT', '000165100000000GF6R5', '11556510000000000U8C', '11556510000000000U3M', '115565100000000018T2', '115565100000000018SQ', '11556510000000000WX5', '11556510000000000WWT', '11556510000000006EPY', '1155G41000000002CXGI', '1155651000000000SEXP', '1155G41000000002C75P', '1155G410000000026TEV', '000165100000000G1M8T', '000165100000000GHKKN', '11556510000000009QI8', '1155G410000000028F69', '0001G4100000001ITGAA', '1155651000000000SEQ3', '1155G410000000026XBB', '115565100000000017ZF', '11556510000000005TJ2', '1155651000000000P8YI', '000165100000000GF6RI', '11556510000000006EPZ', '1155651000000000B4FN', '1155G41000000002CW1Y', '1155651000000000P6NG', '0001G41000000018WAC4', '0001G41000000018WABS', '000165100000000FRTIC', '000165100000000GFPGE', '11556510000000008J5K', '1155651000000001AAZJ', '11556510000000008TWK', '1155651000000000C9NJ', '000165100000000GHAYD', '1155651000000000UG4E', '000165100000000FRTFF', '1155651000000000OOYJ', '1155G410000000029JBG', '000165100000000FRYPR', '1155G41000000001MB62', '1155G41000000001OIZF', '1155651000000000BXYV', '1155G410000000029CL1', '000165100000000FRTJ7', '000165100000000FRTIV', '1155651
0000000007OBH', '1155651000000000AYC9', '1155651000000000RAB0', '0001G41000000018WA9J', '1155651000000000B60A', '000165100000000FRTI0', '000165100000000FRTHO', '11556510000000019849', '1155G410000000027R64', '000165100000000GF6T8', '1155G410000000028E3S', '1155G41000000002C1BB', '1155G410000000026S4B', '115565100000000015OB', '0001G41000000018WA7J', '1155G410000000027281', '11556510000000004Z0X', '11556510000000001CQV', '11556510000000001CR7', '115565100000000018W7', '115565100000000018VV', '000165100000000H2MSS', '1155G4100000000270L0', '000165100000000GCOV6', '1155G410000000020ICP', '1155G410000000026CJZ', '115565100000000018TN', '000165100000000PXO6I', '1155651000000000UYA0', '1155G41000000001OMI4', '11556510000000016I9L', '1155G41000000002C1BI', '1155651000000000VP7M', '0001G41000000018WA6Z', '000165100000000FRWXH', '1155651000000000TG2P', '1155651000000000VBCU', '1155651000000001F8X3', '11556510000000000N60', '11556510000000000N5O', '000165100000000GFPG5', '1155651000000000BT7V', '0001G41000000018WA9Z', '000165100000000DR0UJ', '1155G410000000026UU0', '000165100000000FRTJG', '1155651000000000VBLY', '115565100000000018XF', '000165100000000FRTIB', '000165100000000J3XRY', '11556510000000000U4J', '1155G410000000026YFR', '1155F11000000001YW0O', '115565100000000018RM', '000165100000000FRYPB', '000165100000000GHKIK', '000165100000000DR0SY', '1155651000000000TNWI', '000165100000000DR0WS', '000165100000000FRTHV', '1155G41
000000002CVQY', '1155651000000001C2UO', '1155651000000000UMML', '11556510000000000N70', '11556510000000000N6O', '000165100000000FRTJH', '000165100000000DR0VU', '000165100000000DR0W6', '0001G41000000018WAA1', '11556510000000000ZZS', '11556510000000000N63', '11556510000000000N5R', '1155F110000000021UIO', '1155651000000000UDES', '11556510000000000WYH', '1155651000000000ZG8M', '1155G41000000001O1KD', '1155651000000000B5FA', '1155G410000000027QRR', '1155F11000000001QTZL', '1155G4100000000257P2', '000165100000000FVLIS', '000165100000000FVLJ4', '000165100000000ENDYJ', '11556510000000005STV', '11556510000000005SU7', '1155651000000000USEA', '1155F11000000001YD9O', '000165100000000HB98N', '1155651000000000B7K8', '11556510000000001CAM', '1155G41000000002N7JE', '000165100000000DR0TM', '1155G410000000028OFA', '11556510000000000U4Y', '000165100000000FRLZN', '000165100000000DO9SI', '1155G41000000001MB63', '11556510000000007IXX', '11556510000000001CPE', '1155651000000000BR1Z', '1155G41000000001KYA8', '000165100000000KJTH5', '000165100000000FRYOS', '000165100000000FRYP4', '1155651000000001C7CG', '1155G410000000026R9R', '1155651000000000WRWL', '11556510000000000U3Y', '1155651000000000POEQ', '11556510000000000ZXD', '1155G410000000024XDF', '1155G410000000026DJ0', '115565100000000018YZ', '11556510000000000X0I', '11556510000000000U74', '11556510000000000U6S', '1155G410000000028S49', '1155651000000000V895', '1155G41000000001X3X6', '1155F11
000000001Y1LU', '000165100000000GFPFC', '000165100000000GF6QY', '1155651000000000D9CG', '000165100000000O2SAJ', '11556510000000004YK1', '1155F11000000002Q368', '11556510000000008TWL', '0001G41000000018WA6A', '000165100000000GCOVW', '000165100000000GCOW8', '11556510000000006ES6', '11556510000000001CPB', '1155G41000000001L4UD', '0001G41000000018WA8K', '11556510000000000U4Z', '000165100000000DR0WF', '0001G41000000018WA6N', '1155G41000000002CW1Z', '1155G41000000002CWXO', '1155G410000000028BCQ', '11556510000000000U6C', '11556510000000007NNV', '11556510000000000U4I', '1155651000000000RUED', '115565100000000018UA', '1155G410000000026CBF', '0001G41000000018WAAN', '115565100000000015P3', '115565100000000015OR', '11556510000000000X07', '11556510000000001907', '11556510000000001CNN', '00016510000000114569', '11556510000000019LLZ', '11556510000000001CPV', '11556510000000001CQ7', '1155G410000000026S0N', '0001G41000000018WACD', '000165100000000GEY4F', '0001G41000000018WAAA', '1155G41000000002C75Q', '115565100000000018VA', '1155G410000000026QTN', '1155651000000000PEHT', '115565100000000018X6', '115565100000000018WU', '11556510000000000WX6', '11556510000000000WWU', '1155F11000000001Y8SN', '1155G410000000026WVY', '1155651000000000PZFK', '1155G410000000026CJ9', '115565100000000011UK', '000165100000000G1M8S', '000165100000000G1M94', '1155G410000000029A51', '000165100000000GF6RJ', '115565100000000019JA', '1155G41000000001MAMG', '1155651
00000000018XE', '11556510000000000WXE', '1155F11000000001Y1RN', '1155G410000000026S0M', '115565100000000012RP', '0001G41000000018WAC3', '0001G41000000018WABR', '1155G41000000002R4PX', '000165100000000FRYPC', '1155651000000000P4CS', '1155651000000000TG2O', '115565100000000018RN', '1155651000000000B4FM', '11556510000000001CQU', '11556510000000001CR6', '115565100000000018U2', '115565100000000018TQ', '1155G410000000026TEW', '1155651000000000AIVK', '000165100000000DR0UI', '1155651000000000VBLX', '1155651000000000RUEE', '1155G41000000001MUCQ', '11556510000000004XJ4', '1155G410000000026C9N', '1155651000000001F8X4', '0001G41000000018WA9K', '0001G41000000018WA6Y', '000165100000000FRTGI', '000165100000000GHXHD', '1155651000000000C9NI', '000165100000000FRLZT', '000165100000000GEY48', '000165100000000ENDY0', '1155G41000000002JLQ5', '115565100000000011UX', '11556510000000004Z0U', '1155651000000000P8YJ', '1155G41000000002CVNL', '1155G41000000001P5KZ', '115565100000000068L0', '0001G4100000001I0WI3', '1155651000000000Y7RT', '1155651000000000OOYK', '1155G41000000002C75C', '000165100000000GFPGB', '11556510000000000U73', '11556510000000000U6R', '1155G410000000026XBA', '000165100000000GHKKK', '115565100000000014TG', '1155651000000000VP7L', '1155651000000000W4VT', '1155G41000000002391H', '1155651000000000RPP3', '0001G41000000018WA7Y', '1155G410000000020ICO', '1155G41000000002ADQF', '1155G41000000002CWGG', '000165100000000H2MSR', '1155G41
0000000028E3R', '115565100000000067SK', '1155G410000000026UU1', '1155G41000000002ED2O', '11556510000000019XU8', '1155651000000000BT7W', '000165100000000J3XRX', '1155651000000000USHR', '11556510000000000WY9', '11556510000000000WXX', '000165100000000FRYPS', '1155G41000000002C1BJ', '1155G41000000002CBYY', '1155G41000000001N4JS', '1155G410000000029CL0', '1155G41000000002KULN', '000165100000000HKCDH', '000165100000000FRLZD', '000165100000000GHKIN', '11556510000000018PCY', '000165100000000FRTHH', '000165100000000DR0WV', '1155G4100000000272EQ', '000165100000000GDRBS', '11556510000000005SU8', '1155651000000000BXYU', '115565100000000018W6', '115565100000000018VU', '11556510000000000WW6', '11556510000000000WVU', '1155G41000000002CWTT', '1155651000000000UCJ8', '0001G41000000018WAA2', '11556510000000000WWD', '1155G410000000027QRQ', '1155651000000000UDET', '1155G410000000024QDF', '1155651000000000B7JV', '000165100000000GCOVT', '000165100000000FVLIT', '000165100000000FVLJ5', '1155G41000000001NVXD', '1155G410000000027SZC', '1155651000000000CAQP', '1155651000000000TJC1', '000165100000000FRM05', '1155651000000000WBOY', '1155G410000000026E8P', '000165100000000I3OK9', '11556510000000001CON', '1155G410000000026U3M', '1155651000000001FF0U', '000165100000000DR0VT', '000165100000000DR0W5', '1155G41000000002CWDK', '1155G4100000000257P1', '11556510000000018LI0', '1155651000000000CQDQ', '11556510000000000U3Z', '1155F11000000001QWSP', '0001651
00000000GF6UY', '1155G41000000002CWXN', '000165100000000FRYOR', '000165100000000FRYP3', '1155G41000000001KYA9', '1155G4100000000272EP', '1155G4100000000275OL', '000165100000000FUGLR', '11556510000000000N6N', '000165100000000FVJ4Q', '000165100000000ENDYI', '1155G410000000027WT3', '000165100000000GFPFD', '000165100000000FRTH9', '000165100000000GF6QZ', '11556510000000001CMI', '11556510000000001CRI', '000165100000000KPOFL', '1155G41000000002CVQX', '000165100000000KJTH6', '1155651000000000R2TX', '1155G410000000026BCO', '000165100000000GCOVV', '000165100000000GCOW7', '115565100000000012RA' ) OR bd_cumandoc.pk_cumandoc IN ( '1155G410000000026C7Y', '1155G41000000002C1CK', '115565100000000018YY', '11556510000000000WYY', '1155651000000000CR3U', '0001G41000000018WA8L', '000165100000000GF6V0', '11556510000000001CMZ', '1155G41000000002CGRQ', '1155651000000000TMPQ', '000165100000000DR0WE', '1155G41000000002D8LJ', '0001G41000000018WACC', '000165100000000KYH9U', '000165100000000DR0TJ', '11556510000000001CAL', '000165100000000FRTIW', '11556510000000008J5N', '11556510000000018SPE', '1155F11000000001YZLX', '0001G41000000018WACM', '115565100000000018X7', '115565100000000018WV', '11556510000000001CPU', '11556510000000001CQ6', '11556510000000005TKV', '115565100000000018V3', '115565100000000018UR', '11556510000000000U6B', '0001G41000000018WAAB', '115565100000000018SM', '11556510000000009SWJ', '0001G41000000018WAB0', '0001G41000000018WAAO', '
000165100000000FRTFM', '1155651000000000R2JD' ) ) AND bd_cumandoc.pk_corp IN ( '1155', '0001' ) |
cn1gtsav2d5jh | BEGIN
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
END; |
cu13rvk2wfhn6 |
SELECT DISTINCT zb.vouchid, zb.bbje, zb.ddhbbm, zb.djbh, zb.djdl, zb.djkjnd, zb.djkjqj, zb.djlxbm, zb.djrq, zb.djzt, zb.dr, zb.dwbm, zb.dyvouchid, zb.dzrq, zb.effectdate, zb.enduser, zb.fbje, zb.fj, zb.fktjbm, zb.inner_effect_date, zb.isonlinepay, zb.jszxzf, zb.kmbm, zb.lrr, zb.lybz, zb.officialprintdate, zb.officialprintuser, zb.pj_num, zb.pj_oid, zb.pzglh, zb.qcbz, zb.qrr, zb.scomment, zb.sfkr, zb.shkjnd, zb.shkjqj, zb.shr, zb.shrq, zb.shzd, zb.sxbz, zb.sxkjnd, zb.sxkjqj, zb.sxr, zb.sxrq, zb.ts, zb.xslxbm, zb.ybje, zb.yhqrkjnd, zb.yhqrkjqj, zb.yhqrr, zb.yhqrrq, zb.ywbm, zb.zdr, zb.zdrq, zb.zyx1, zb.zyx10, zb.zyx11, zb.zyx12, zb.zyx13, zb.zyx14, zb.zyx15, zb.zyx16, zb.zyx17, zb.zyx18, zb.zyx19, zb.zyx2, zb.zyx20, zb.zyx3, zb.zyx4, zb.zyx5, zb.zyx6, zb.zyx7, zb.zyx8, zb.zyx9, zb.zzzt, zb.zgyf, zb.isselectedpay, zb.zyx21, zb.zyx22, zb.zyx23, zb.zyx24, zb.zyx25, zb.zyx26, zb.zyx27, zb.zyx28, zb.zyx29, zb.zyx30, zb.sscause, zb.kskhyh, zb.lastshr, zb.spzt, zb.payman, zb.paydate, zb.settlenum, zb.isnetready, zb.ispaid, zb.isjszxzf, zb.isreded from cmp_busibill zb where exists ( select vouchid from cmp_busibill_b where zb.vouchid = cmp_busibill_b.vouchid and cmp_busibill_b.ddhh in ( '1110G41000000001PMDC', '1110G41000000001PMDD', '1110G41000000001PMDE', '1110G41000000001PMDF', '1110G41000000001PMDG', '1110G41000000001PMDH', '1110G41000000001PMDI', '1110G41000000001PMDJ', '1110G4
1000000001PMDA', '1110G41000000001PMDB', '1110G41000000001PMD6', '1110G41000000001PMD9', '1110G41000000001PMDL', '1110G41000000001PMDK' ) and cmp_busibill_b.dr = 0 and zb.dr = 0 ) |
cxscp7btdg0ya | select templateflag, templateid, operator, pk_corp, nodekey from pub_systemplate where funnode = :1 and tempstyle = :2 and ( templateflag = 'Y' or ( pk_org = :3 and nodekey is null and operator_type = 1 and operator = :4 ) ) |
d2zkyg914fn76 |
SELECT ic_general_h.cgeneralhid, ic_general_h.cauditorid, ic_general_h.cbilltypecode, ic_general_h.cbizid, ic_general_h.cbiztype, ic_general_h.ccustomerid, ic_general_h.cdilivertypeid, ic_general_h.cdispatcherid, ic_general_h.cdptid, ic_general_h.cinventoryid, ic_general_h.coperatorid, ic_general_h.cproviderid, ic_general_h.cregister, ic_general_h.cwarehouseid, ic_general_h.cwastewarehouseid, ic_general_h.cwhsmanagerid, ic_general_h.daccountdate, ic_general_h.dauditdate, ic_general_h.dbilldate, ic_general_h.dr, ic_general_h.fbillflag, ic_general_h.fspecialflag, ic_general_h.pk_corp, ic_general_h.vbillcode, ic_general_h.vdiliveraddress, ic_general_h.vnote, ic_general_h.vuserdef1, ic_general_h.vuserdef10, ic_general_h.vuserdef2, ic_general_h.vuserdef3, ic_general_h.vuserdef4, ic_general_h.vuserdef5, ic_general_h.vuserdef6, ic_general_h.vuserdef7, ic_general_h.vuserdef8, ic_general_h.vuserdef9, ic_general_h.vuserdef11, ic_general_h.vuserdef12, ic_general_h.vuserdef13, ic_general_h.vuserdef14, ic_general_h.vuserdef15, ic_general_h.vuserdef16, ic_general_h.vuserdef17, ic_general_h.vuserdef18, ic_general_h.vuserdef19, ic_general_h.vuserdef20, ic_general_h.pk_defdoc1, ic_general_h.pk_defdoc2, ic_general_h.pk_defdoc3, ic_general_h.pk_defdoc4, ic_general_h.pk_defdoc5, ic_general_h.pk_defdoc6, ic_general_h.pk_defdoc7, ic_general_h.pk_defdoc8, ic_general_h.pk_defdoc9, ic_general_h.pk_defdoc10, ic_general_h.pk_defdoc11, ic_general_
h.pk_defdoc12, ic_general_h.pk_defdoc13, ic_general_h.pk_defdoc14, ic_general_h.pk_defdoc15, ic_general_h.pk_defdoc16, ic_general_h.pk_defdoc17, ic_general_h.pk_defdoc18, ic_general_h.pk_defdoc19, ic_general_h.pk_defdoc20, ic_general_h.pk_corp, ic_general_h.ts, ic_general_h.pk_calbody, ic_general_h.pk_purcorp, ic_general_h.freplenishflag, ic_general_h.boutretflag, ic_general_h.bassetcard, ic_general_h.taccounttime, ic_general_h.clastmodiid, ic_general_h.iprintcount, ic_general_h.tmaketime, ic_general_h.tlastmoditime, ic_general_b.bzgflag, ic_general_b.castunitid, ic_general_b.ccorrespondbid, ic_general_b.ccorrespondcode, ic_general_b.ccorrespondhid, ic_general_b.ccorrespondtype, ic_general_b.ccostobject, ic_general_b.cfirstbillbid, ic_general_b.cfirstbillhid, ic_general_b.cfirsttype, ic_general_b.cgeneralbid, ic_general_b.cgeneralhid, ic_general_b.cinventoryid, ic_general_b.cprojectid, ic_general_b.cprojectphaseid, ic_general_b.csourcebillbid, ic_general_b.csourcebillhid, ic_general_b.csourcetype, ic_general_b.cwp, ic_general_b.dbizdate, ic_general_b.dr, ic_general_b.dstandbydate, ic_general_b.dvalidate, ic_general_b.fchecked, ic_general_b.flargess, ic_general_b.isok, ic_general_b.ninassistnum, ic_general_b.ninnum, ic_general_b.nmny, ic_general_b.nneedinassistnum, ic_general_b.noutassistnum, ic_general_b.noutnum, ic_general_b.nplannedmny, ic_general_b.nplannedprice, ic_general_b.nprice, ic_general_b.nshouldinnum, ic_gen
eral_b.nshouldoutassistnum, ic_general_b.nshouldoutnum, ic_general_b.ntranoutnum, ic_general_b.vbatchcode, ic_general_b.vfree1, ic_general_b.vfree10, ic_general_b.vfree2, ic_general_b.vfree3, ic_general_b.vfree4, ic_general_b.vfree5, ic_general_b.vfree6, ic_general_b.vfree7, ic_general_b.vfree8, ic_general_b.vfree9, ic_general_b.vproductbatch, ic_general_b.vsourcebillcode, ic_general_b.vuserdef1, ic_general_b.vuserdef10, ic_general_b.vuserdef2, ic_general_b.vuserdef3, ic_general_b.vuserdef4, ic_general_b.vuserdef5, ic_general_b.vuserdef6, ic_general_b.vuserdef7, ic_general_b.vuserdef8, ic_general_b.vuserdef9, ic_general_b.vuserdef11, ic_general_b.vuserdef12, ic_general_b.vuserdef13, ic_general_b.vuserdef14, ic_general_b.vuserdef15, ic_general_b.vuserdef16, ic_general_b.vuserdef17, ic_general_b.vuserdef18, ic_general_b.vuserdef19, ic_general_b.vuserdef20, ic_general_b.pk_defdoc1, ic_general_b.pk_defdoc2, ic_general_b.pk_defdoc3, ic_general_b.pk_defdoc4, ic_general_b.pk_defdoc5, ic_general_b.pk_defdoc6, ic_general_b.pk_defdoc7, ic_general_b.pk_defdoc8, ic_general_b.pk_defdoc9, ic_general_b.pk_defdoc10, ic_general_b.pk_defdoc11, ic_general_b.pk_defdoc12, ic_general_b.pk_defdoc13, ic_general_b.pk_defdoc14, ic_general_b.pk_defdoc15, ic_general_b.pk_defdoc16, ic_general_b.pk_defdoc17, ic_general_b.pk_defdoc18, ic_general_b.pk_defdoc19, ic_general_b.pk_defdoc20, ic_general_b.pk_corp, ic_general_b.ts, ic_general_b.vnotebody,
ic_general_b.cinvbasid, ic_general_b.pk_invoicecorp, ic_general_b.hsl, ic_general_b.crowno, ic_general_b.csourcetype, ic_general_b.vsourcebillcode, ic_general_b.vsourcerowno, ic_general_b.vfirstbillcode, ic_general_b.vfirstrowno, ic_general_bb3.caccountunitid, ic_general_bb3.cgeneralbb3, ic_general_bb3.cgeneralbid, ic_general_bb3.cgeneralhid, ic_general_bb3.dr, ic_general_bb3.naccountmny, ic_general_bb3.naccountnum1, ic_general_bb3.naccountnum2, ic_general_bb3.nmaterialmoney, ic_general_bb3.npmoney, ic_general_bb3.npprice, ic_general_bb3.nsignnum, ic_general_bb3.ts, po_order.vordercode, po_order.ctermprotocolid, po_order.cgiveinvoicevendor, po_order.cvendormangid, po_order_b.corderid, po_order_b.corder_bid, po_order_b.pk_corp, po_order_b.cusedeptid, po_order_b.cmangid, po_order_b.cbaseid, po_order_b.nordernum, po_order_b.cassistunit, po_order_b.nassistnum, po_order_b.ndiscountrate, po_order_b.idiscounttaxtype, po_order_b.ntaxrate, po_order_b.ccurrencytypeid, po_order_b.noriginalnetprice, po_order_b.noriginalcurprice, po_order_b.noriginalcurmny, po_order_b.noriginaltaxmny, po_order_b.noriginaltaxpricemny, po_order_b.nexchangeotobrate, po_order_b.ntaxmny, po_order_b.nmoney, po_order_b.ntaxpricemny, po_order_b.naccumarrvnum, po_order_b.naccumstorenum, po_order_b.naccuminvoicenum, po_order_b.naccumwastnum, po_order_b.dplanarrvdate, po_order_b.vvendorordercode, po_order_b.vvendororderrow, po_order_b.cwarehouseid, po_order_b.v
receiveaddress, po_order_b.nconfirmnum, po_order_b.dconfirmdate, po_order_b.ccorrectrowid, po_order_b.dcorrectdate, po_order_b.cprojectid, po_order_b.cprojectphaseid, po_order_b.coperator, po_order_b.iisactive, po_order_b.iisreplenish, po_order_b.forderrowstatus, po_order_b.csourcebilltype, po_order_b.csourcebillid, po_order_b.csourcerowid, po_order_b.cupsourcebilltype, po_order_b.cupsourcebillid, po_order_b.cupsourcebillrowid, po_order_b.vmemo, po_order_b.vfree1, po_order_b.vfree2, po_order_b.vfree3, po_order_b.vfree4, po_order_b.vfree5, po_order_b.vdef1, po_order_b.vdef2, po_order_b.vdef3, po_order_b.vdef4, po_order_b.vdef5, po_order_b.vdef6, po_order_b.dr, po_order_b.ts, po_order_b.norgnettaxprice FROM ic_general_h INNER JOIN ic_general_b ON ic_general_h.cgeneralhid = ic_general_b.cgeneralhid INNER JOIN ic_general_bb3 ON ic_general_b.cgeneralbid = ic_general_bb3.cgeneralbid LEFT OUTER JOIN po_order_b ON ic_general_b.cfirstbillhid = po_order_b.corderid AND ic_general_b.cfirstbillbid = po_order_b.corder_bid LEFT OUTER JOIN po_order ON po_order.corderid = po_order_b.corderid LEFT OUTER JOIN bd_cumandoc ON ic_general_h.cproviderid = bd_cumandoc.pk_cumandoc left outer join bd_invmandoc on ic_general_b.cinventoryid = bd_invmandoc.pk_invmandoc WHERE ( ic_general_h.fbillflag = 3 OR ic_general_h.fbillflag = 4 ) AND ic_general_h.dr = 0 AND ic_general_b.dr = 0 AND nvl ( ic_general_b.flargess, 'N' ) = 'N' AND ic_general_bb3.dr = 0 AND ic_general_b.isok
= 'N' AND ic_general_b.ninnum IS NOT NULL AND ic_general_b.pk_invoicecorp = '1052' AND ic_general_h.cbiztype = '000165100000000XMBUA' AND ic_general_h.cbilltypecode = '45' AND ( ( ic_general_h.dbilldate >= '2013-11-01' ) and ( ic_general_h.dbilldate <= '2013-12-09' ) ) AND ( ( ic_general_b.cfirsttype IS NULL ) OR ( po_order.dr = 0 AND po_order_b.dr = 0 AND ic_general_b.cfirsttype = '21' ) ) AND ( bd_cumandoc.frozenflag IS NULL OR bd_cumandoc.frozenflag = 'N' ) ORDER BY ic_general_h.cgeneralhid, ic_general_b.cinventoryid |
d4632xbngx6gs | select distinct fbm_baseinfo.pk_baseinfo from fbm_baseinfo left outer join fbm_register on fbm_baseinfo.pk_baseinfo = fbm_register.pk_baseinfo where fbm_register.pk_register is null and nvl ( fbm_register.dr, 0 ) = 0 and nvl ( fbm_baseinfo.dr, 0 ) = 0 |
dpsn798zm9rdn | select pk_billcoderule, pk_billtypecode, billcodeshortname, ishaveshortname, controlpara, object1, object2, year, month, day, snnum, lastsn, ischeck, snresetflag, isautofill, ispreserve, pk_corp from pub_billcode_rule where pk_billtypecode = :1 |
ds9csubu4dvns | SELECT * FROM pub_billbusiness WHERE pk_billtype = :1 AND pk_businesstype = :2 AND pk_corp = :3 |
dxts78pp9p4t7 | SELECT bd_invmandoc.pk_invmandoc FROM bd_invmandoc WHERE bd_invmandoc.pk_invbasdoc = :1 AND bd_invmandoc.pk_corp = :2 |
f2unkk57mz0m7 | select bd_invbasdoc.invcode, bd_invbasdoc.invname, bd_invbasdoc.invspec, bd_invbasdoc.invtype, bd_invbasdoc.graphid, bd_invbasdoc.pk_measdoc, bd_invmandoc.pk_invbasdoc, bd_invmandoc.pk_invmandoc, bd_invbasdoc.pk_invcl from bd_invmandoc inner join bd_invbasdoc on bd_invmandoc.pk_invbasdoc = bd_invbasdoc.pk_invbasdoc where ( discountflag = 'N' and bd_invmandoc.sealflag = 'N' and bd_invmandoc.pk_corp = '1181' and bd_invmandoc.pk_invbasdoc = bd_invbasdoc.pk_invbasdoc and ( bd_invbasdoc.invcode like '%Á´ÂÖ%' or bd_invbasdoc.invname like '%Á´ÂÖ%' or bd_invbasdoc.invspec like '%Á´ÂÖ%' or bd_invbasdoc.invtype like '%Á´ÂÖ%' or bd_invbasdoc.graphid like '%Á´ÂÖ%' or bd_invbasdoc.pk_measdoc like '%Á´ÂÖ%' ) ) and ( bd_invmandoc.sealflag = 'N' or bd_invmandoc.sealflag is null ) and bd_invbasdoc.pk_invcl in ( select pk_invcl from bd_invcl where ( ( pk_corp = '1181' or pk_corp = '0001' ) and sealdate is null ) ) order by bd_invbasdoc.invcode |
f3bm7xxd7vgr6 | select distinct r.pk_role, r.role_code, r.role_name, r.resource_type, power.pk_corp from pub_power_billbusi power, sm_role r where power.resource_data_id = :1 and r.pk_role = power.pk_role order by r.role_code |
fcx962v8rpa52 | SELECT vcode FROM to_bill WHERE vcode = :1 and coutcorpid = :2 and dr = 0 and blatest = 'Y' |
fjt1k2cfvnxn3 | SELECT bd_produce.pk_invbasdoc, bd_produce.pk_calbody, bd_produce.matertype, bd_produce.cgzz FROM t_pu_id_in_28 left outer join bd_produce on t_pu_id_in_28.cbaseid = bd_produce.pk_invbasdoc and t_pu_id_in_28.stororgid = bd_produce.pk_calbody where dr = 0 |
fy9ta5zgkwqmp | SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF' |
g4r4rudnr5cnn | SELECT * FROM bd_reftable WHERE refnodename = :1 AND pk_corp = :2 |
grwydz59pu6mc | select text from view$ where rowid=:1 |