API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.46 KB | None | 0 0
raw download clone embed print report
  1. 1nh0xk3pzr8pd
  2. select * from ( select row_.*, rownum rownum_ from ( select this_.INF_CREATEDBY as field0_ , this_.IDB_TYPEDOCBASE as field1_ , this_.SI_USERFLAG2 as field2_ , this_.AGI_APPROVER_DSC as field3_ , this_.MFK_GUIDEXP_BO as field4_ , this_.RB_NAMETOFK as field5_ , this_.IDB_ROOMACT as field6_ , this_.RB_GLAVABKCODE as field7_ , this_.IDB_SUMSUBSRUB as field8_ , this_.MFK_REFLECTIONACCOUNT as field9_ , this_.RB_NUMBERACCOUNT as field10_ , this_.MFK_GUID_PROTOKOL as field11_ , this_.AGI_CHECKRES as field12_ , this_.IDB_REGISNMBRG as field13_ , this_.MFK_GUIDNOTICE as field14_ , this_.RB_CODETOFK as field15_ , this_.INF_SOURCE as field16_ , this_.INF_DATEDOCUMENT as field17_ , this_.IDB_REGISNMBRBO as field18_ , this_.AGI_LOGIN as field19_ , this_.INF_NUMBERCHANGE as field20_ , this_.INF_NUMBERDOCUMENT as field21_ , this_.RB_NAMERECIP as field22_ , this_.SI_LOGINUSER as field23_ , this_.MFK_DATELS as field24_ , this_.SI_FONARINCLUDPBO as field25_ , this_.RB_CODEGRBS as field26_ , dc1_.routeContextId as attr27_ , d5_.globalDocId as attr28_ , d5_.docTypeVersion as attr29_ , d5_.accessLevel as attr30_ , d5_.approvalState as attr31_ , this_.docId as attr32_ , dc1_.LocalDocStateID as attr33_ , dc1_.DOCSTATE_VERSION as attr34_ , d5_.DOCSTATE_VERSION as attr35_ , d5_.SIGN_COUNT as attr36_ , dc1_.OrgID as attr37_ , d5_.docStateId as attr38_ , d5_.docTypeId as attr39_ , d5_.createOrgId as attr40_ , dd2_.systemName as attr41_ from DC_EXP_InfBO this_ left outer join DC_DOC_BASE p3_ on this_.docId=p3_.docId left outer join FS_DOCCOMMONFIELDS pfd6_ on p3_.docId=pfd6_.docId inner join doc d5_ on this_.docId=d5_.docId inner join DocState dd2_ on d5_.docStateId=dd2_.DocStateID inner join RouteContext dc1_ on d5_.docId=dc1_.docId inner join Org do4_ on dc1_.OrgID=do4_.OrgID where dc1_.docTypeId=:1 and d5_.docTypeId=:2 and 0 = 0 and dc1_.archive=:3 and dc1_.Deleted=:4 and ((this_.SI_TEHFIELD1 is null or not this_.SI_TEHFIELD1=:5 )) and ((do4_.SystemName=:6 or do4_.SystemName=:7 or do4_.SystemName=:8 or do4_.SystemName=:9 or do4_.SystemName=:10 or do4_.SystemName=:11 )) and pfd6_.docTypeId=:12 ) row_ where rownum <= :13 ) where rownum_ > :14
  3.  
  4. bjfsp3yu6d8yg
  5. select * from ( select row_.*, rownum rownum_ from ( select this_.INF_CREATEDBY as field0_ , this_.IDB_TYPEDOCBASE as field1_ , this_.SI_USERFLAG2 as field2_ , this_.AGI_APPROVER_DSC as field3_ , this_.MFK_GUIDEXP_BO as field4_ , this_.RB_NAMETOFK as field5_ , this_.IDB_ROOMACT as field6_ , this_.RB_GLAVABKCODE as field7_ , this_.IDB_SUMSUBSRUB as field8_ , this_.MFK_REFLECTIONACCOUNT as field9_ , this_.RB_NUMBERACCOUNT as field10_ , this_.MFK_GUID_PROTOKOL as field11_ , this_.AGI_CHECKRES as field12_ , this_.IDB_REGISNMBRG as field13_ , this_.MFK_GUIDNOTICE as field14_ , this_.RB_CODETOFK as field15_ , this_.INF_SOURCE as field16_ , this_.INF_DATEDOCUMENT as field17_ , this_.IDB_REGISNMBRBO as field18_ , this_.AGI_LOGIN as field19_ , this_.INF_NUMBERCHANGE as field20_ , this_.INF_NUMBERDOCUMENT as field21_ , this_.RB_NAMERECIP as field22_ , this_.SI_LOGINUSER as field23_ , this_.MFK_DATELS as field24_ , this_.SI_FONARINCLUDPBO as field25_ , this_.RB_CODEGRBS as field26_ , dc1_.routeContextId as attr27_ , d5_.globalDocId as attr28_ , d5_.docTypeVersion as attr29_ , d5_.accessLevel as attr30_ , d5_.approvalState as attr31_ , this_.docId as attr32_ , dc1_.LocalDocStateID as attr33_ , dc1_.DOCSTATE_VERSION as attr34_ , d5_.DOCSTATE_VERSION as attr35_ , d5_.SIGN_COUNT as attr36_ , dc1_.OrgID as attr37_ , d5_.docStateId as attr38_ , d5_.docTypeId as attr39_ , d5_.createOrgId as attr40_ , dd2_.systemName as attr41_ from DC_EXP_InfBO this_ left outer join DC_DOC_BASE p3_ on this_.docId=p3_.docId left outer join FS_DOCCOMMONFIELDS pfd6_ on p3_.docId=pfd6_.docId inner join doc d5_ on this_.docId=d5_.docId inner join DocState dd2_ on d5_.docStateId=dd2_.DocStateID inner join RouteContext dc1_ on d5_.docId=dc1_.docId inner join Org do4_ on dc1_.OrgID=do4_.OrgID where dc1_.docTypeId=:1 and d5_.docTypeId=:2 and 0 = 0 and dc1_.archive=:3 and dc1_.Deleted=:4 and ((this_.SI_TEHFIELD1 is null or not this_.SI_TEHFIELD1=:5 )) and pfd6_.docTypeId=:6 and ((do4_.SystemName=:7 or do4_.SystemName=:8 or do4_.SystemName=:9 or do4_.SystemName=:10 )) ) row_ where rownum <= :11 ) where rownum_ > :12
  6.  
  7. g1f7xhdczrqkt
  8.  
  9. select * from ( select row_.*, rownum rownum_ from ( select this_.INF_CREATEDBY as field0_ , this_.IDB_TYPEDOCBASE as field1_ , this_.SI_USERFLAG2 as field2_ , this_.AGI_APPROVER_DSC as field3_ , this_.MFK_GUIDEXP_BO as field4_ , this_.RB_NAMETOFK as field5_ , this_.IDB_ROOMACT as field6_ , this_.RB_GLAVABKCODE as field7_ , this_.IDB_SUMSUBSRUB as field8_ , this_.MFK_REFLECTIONACCOUNT as field9_ , this_.RB_NUMBERACCOUNT as field10_ , this_.MFK_GUID_PROTOKOL as field11_ , this_.AGI_CHECKRES as field12_ , this_.IDB_REGISNMBRG as field13_ , this_.MFK_GUIDNOTICE as field14_ , this_.RB_CODETOFK as field15_ , this_.INF_SOURCE as field16_ , this_.INF_DATEDOCUMENT as field17_ , this_.IDB_REGISNMBRBO as field18_ , this_.AGI_LOGIN as field19_ , this_.INF_NUMBERCHANGE as field20_ , this_.INF_NUMBERDOCUMENT as field21_ , this_.RB_NAMERECIP as field22_ , this_.SI_LOGINUSER as field23_ , this_.MFK_DATELS as field24_ , this_.SI_FONARINCLUDPBO as field25_ , this_.RB_CODEGRBS as field26_ , dc1_.routeContextId as attr27_ , d5_.globalDocId as attr28_ , d5_.docTypeVersion as attr29_ , d5_.accessLevel as attr30_ , d5_.approvalState as attr31_ , this_.docId as attr32_ , dc1_.LocalDocStateID as attr33_ , dc1_.DOCSTATE_VERSION as attr34_ , d5_.DOCSTATE_VERSION as attr35_ , d5_.SIGN_COUNT as attr36_ , dc1_.OrgID as attr37_ , d5_.docStateId as attr38_ , d5_.docTypeId as attr39_ , d5_.createOrgId as attr40_ , dd2_.systemName as attr41_ from DC_EXP_InfBO this_ left outer join DC_DOC_BASE p3_ on this_.docId=p3_.docId left outer join FS_DOCCOMMONFIELDS pfd6_ on p3_.docId=pfd6_.docId inner join doc d5_ on this_.docId=d5_.docId inner join DocState dd2_ on d5_.docStateId=dd2_.DocStateID inner join RouteContext dc1_ on d5_.docId=dc1_.docId inner join Org do4_ on dc1_.OrgID=do4_.OrgID where dc1_.docTypeId=:1 and d5_.docTypeId=:2 and 0 = 0 and dc1_.archive=:3 and dc1_.Deleted=:4 and ((this_.SI_TEHFIELD1 is null or not this_.SI_TEHFIELD1=:5 )) and pfd6_.docTypeId=:6 and ((do4_.SystemName=:7 or do4_.SystemName=:8 or do4_.SystemName=:9 or do4_.SystemName=:10 or do4_.SystemName=:11 )) ) row_ where rownum <= :12 ) where rownum_ > :13
  10.  
  11. gh888m9162tuk
  12. select * from ( select row_.*, rownum rownum_ from ( select this_.INF_CREATEDBY as field0_ , this_.IDB_TYPEDOCBASE as field1_ , this_.SI_USERFLAG2 as field2_ , this_.AGI_APPROVER_DSC as field3_ , this_.MFK_GUIDEXP_BO as field4_ , this_.RB_NAMETOFK as field5_ , this_.IDB_ROOMACT as field6_ , this_.RB_GLAVABKCODE as field7_ , this_.IDB_SUMSUBSRUB as field8_ , this_.MFK_REFLECTIONACCOUNT as field9_ , this_.RB_NUMBERACCOUNT as field10_ , this_.MFK_GUID_PROTOKOL as field11_ , this_.AGI_CHECKRES as field12_ , this_.IDB_REGISNMBRG as field13_ , this_.MFK_GUIDNOTICE as field14_ , this_.RB_CODETOFK as field15_ , this_.INF_SOURCE as field16_ , this_.INF_DATEDOCUMENT as field17_ , this_.IDB_REGISNMBRBO as field18_ , this_.AGI_LOGIN as field19_ , this_.INF_NUMBERCHANGE as field20_ , this_.INF_NUMBERDOCUMENT as field21_ , this_.RB_NAMERECIP as field22_ , this_.SI_LOGINUSER as field23_ , this_.MFK_DATELS as field24_ , this_.SI_FONARINCLUDPBO as field25_ , this_.RB_CODEGRBS as field26_ , dc1_.routeContextId as attr27_ , d5_.globalDocId as attr28_ , d5_.docTypeVersion as attr29_ , d5_.accessLevel as attr30_ , d5_.approvalState as attr31_ , this_.docId as attr32_ , dc1_.LocalDocStateID as attr33_ , dc1_.DOCSTATE_VERSION as attr34_ , d5_.DOCSTATE_VERSION as attr35_ , d5_.SIGN_COUNT as attr36_ , dc1_.OrgID as attr37_ , d5_.docStateId as attr38_ , d5_.docTypeId as attr39_ , d5_.createOrgId as attr40_ , dd2_.systemName as attr41_ from DC_EXP_InfBO this_ left outer join DC_DOC_BASE p3_ on this_.docId=p3_.docId left outer join FS_DOCCOMMONFIELDS pfd6_ on p3_.docId=pfd6_.docId inner join doc d5_ on this_.docId=d5_.docId inner join DocState dd2_ on d5_.docStateId=dd2_.DocStateID inner join RouteContext dc1_ on d5_.docId=dc1_.docId inner join Org do4_ on dc1_.OrgID=do4_.OrgID where dc1_.docTypeId=:1 and d5_.docTypeId=:2 and 0 = 0 and dc1_.archive=:3 and dc1_.Deleted=:4 and ((this_.SI_TEHFIELD1 is null or not this_.SI_TEHFIELD1=:5 )) and pfd6_.docTypeId=:6 and ((do4_.SystemName=:7 or do4_.SystemName=:8 or do4_.SystemName=:9 or do4_.SystemName=:10 or do4_.SystemName=:11 or do4_.SystemName=:12 )) ) row_ where rownum <= :13 ) where rownum_ > :14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!