Subversion Repositories DevTools

Rev

Rev 4762 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<?xml version="1.0" encoding="UTF-8" ?>
<testsuite errors="10" failures="0" name="com.erggroup.tests.AllTests" tests="196" time="17.278">
  <properties>
    <property name="PACKAGE.jsftp" value="1.2.0001.cr"></property>
    <property name="PATCHBUILD_STR" value="1000"></property>
    <property name="file.encoding.pkg" value="sun.io"></property>
    <property name="PACKAGE_javaenums" value="V:/dpkg_archive/javaenums/25.5.0035.sls"></property>
    <property name="INTERFACEDIR" value="C:/ClearCase/UtfIntegration/src/../interface"></property>
    <property name="PACKAGE_asm" value="V:/dpkg_archive/asm/2.2.2.0000.cots"></property>
    <property name="PACKAGE.xmlbeans" value="2.2.0.cots"></property>
    <property name="java.home" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre"></property>
    <property name="src.test.dir" value="C:\ClearCase\UtfIntegration/junit"></property>
    <property name="PACKAGE_j2ssh" value="V:/dpkg_archive/j2ssh/0.2.9.0000.cots"></property>
    <property name="PACKAGE.jsnmpagent" value="1.0.1000.cr"></property>
    <property name="java.endorsed.dirs" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\endorsed"></property>
    <property name="src.dir" value="C:\ClearCase\UtfIntegration/src"></property>
    <property name="MAJOR" value="5"></property>
    <property name="PACKAGE.javaenums" value="25.5.0035.sls"></property>
    <property name="sun.os.patch.level" value="Service Pack 1"></property>
    <property name="java.vendor.url" value="http://java.sun.com/"></property>
    <property name="PACKAGE_jboss-spring-deployer" value="V:/dpkg_archive/jboss-spring-deployer/2.0.0.0000.cots"></property>
    <property name="java.version" value="1.5.0_22"></property>
    <property name="GBE_TYPE" value="D"></property>
    <property name="PACKAGE.slf4j" value="1.4.3.cots"></property>
    <property name="java.vendor.url.bug" value="http://java.sun.com/cgi-bin/bugreport.cgi"></property>
    <property name="PATCH" value="1"></property>
    <property name="PACKAGE_echo2" value="V:/dpkg_archive/echo2/2.1.0.rc2.0000.cots"></property>
    <property name="src.remote.dir" value="C:\ClearCase\UtfIntegration/src/remote"></property>
    <property name="PACKAGE.docflex-doclet" value="1.6.1.cots"></property>
    <property name="PACKAGE.jboss-spring-deployer" value="2.0.0.0000.cots"></property>
    <property name="user.name" value="RPuchmay"></property>
    <property name="BUILD_STR" value="0"></property>
    <property name="sun.io.unicode.encoding" value="UnicodeLittle"></property>
    <property name="sun.jnu.encoding" value="Cp1252"></property>
    <property name="java.runtime.name" value="Java(TM) 2 Runtime Environment, Standard Edition"></property>
    <property name="PACKAGE_quartz" value="V:/dpkg_archive/quartz/1.5.2.0000.cots"></property>
    <property name="src.client.dir" value="C:\ClearCase\UtfIntegration/src/client"></property>
    <property name="java.specification.name" value="Java Platform API Specification"></property>
    <property name="user.timezone" value=""></property>
    <property name="build.doc.dir" value="C:\ClearCase\UtfIntegration/build/doc/SLSInterface-5.0.1000.sls"></property>
    <property name="path.separator" value=";"></property>
    <property name="src.stubs.dir" value="C:\ClearCase\UtfIntegration/stubs"></property>
    <property name="PACKAGE.junit" value="4.3.0.cots"></property>
    <property name="build.javadoc.dir" value="C:\ClearCase\UtfIntegration/build/javadoc"></property>
    <property name="file.encoding" value="Cp1252"></property>
    <property name="BUILDNAME" value="SLSInterface 5.0.1000 sls"></property>
    <property name="PACKAGE.quartz" value="1.5.2.0000.cots"></property>
    <property name="ant.file" value="c:\ClearCase\UtfIntegration\src\..\SLSInterface.xml"></property>
    <property name="PROJECT" value="sls"></property>
    <property name="BUILD" value="0"></property>
    <property name="java.io.tmpdir" value="C:\Users\rpuchmay\AppData\Local\Temp\"></property>
    <property name="user.language" value="en"></property>
    <property name="line.separator" value="
"></property>
    <property name="PACKAGE" value="SLSInterface"></property>
    <property name="java.vm.info" value="mixed mode, sharing"></property>
    <property name="sun.desktop" value="windows"></property>
    <property name="java.vm.specification.name" value="Java Virtual Machine Specification"></property>
    <property name="build.test.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/junit"></property>
    <property name="PACKAGE.asm" value="2.2.2.0000.cots"></property>
    <property name="PACKAGE.j2ssh" value="0.2.9.0000.cots"></property>
    <property name="build.core.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/core"></property>
    <property name="java.awt.printerjob" value="sun.awt.windows.WPrinterJob"></property>
    <property name="ant.version" value="Apache Ant version 1.6.5 compiled on June 2 2005"></property>
    <property name="PACKAGE_jboss" value="V:/dpkg_archive/jboss/4.0.5002.GA"></property>
    <property name="src.xml.dir" value="C:\ClearCase\UtfIntegration/src/xml"></property>
    <property name="BUILDTIME" value="1418028695"></property>
    <property name="PACKAGE.echo2" value="2.1.0.rc2.0000.cots"></property>
    <property name="PACKAGEDIR" value="C:/ClearCase/UtfIntegration/src/../pkg/SLSInterface"></property>
    <property name="os.name" value="Windows 7"></property>
    <property name="PACKAGE_xstream" value="V:/dpkg_archive/xstream/1.2.2.0000.cots"></property>
    <property name="java.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="BUILDDATE" value="Mon Dec  8 16:51:31 2014"></property>
    <property name="java.vm.name" value="Java HotSpot(TM) Client VM"></property>
    <property name="MAJOR_STR" value="5"></property>
    <property name="java.library.path" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin;.;C:\Windows\system32;C:\Windows;C:\LocalData\ProgramFiles\apache-ant-1.6.5\bin;C:\Program Files (x86)\Java\jdk1.5.0_22\bin;c:\jats_cache\core_devl\3.5.9000.cr\BIN.win32;C:\Perl\bin;C:\oracle\product\11.2.0\client_2\bin;C:\LocalData\ProgramFiles\jats;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\NTRU Cryptosystems\NTRU TCG Software Stack\bin;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin;C:\Program Files (x86)\Intel\Services\IPT;C:\Program Files\Dell\Dell Data Protection\Access\Advanced\Wave\Gemalto\Access Client\v5;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\12.0\DLLShared;C:\Program Files (x86)\Roxio\OEM\AudioCore;C:\LocalData\ProgramFiles\apache-ant-1.6.5\bin;V:\dpkg_archive\core_devl\jats2_current\TOOLS;C:\Program Files (x86)\Vim\vim74;C:\Program Files (x86)\Lua\5.1;C:\Program Files (x86)\Lua\5.1\clibs;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;c:\Program Files\Microsoft SQL Server\100\Tools\Binn;c:\Program Files\Microsoft SQL Server\100\DTS\Binn;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Nmap;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared"></property>
    <property name="ALL" value="SLSInterface (5.0.1000.sls) accountId (19.0.3000.mas) asm (2.2.2.0000.cots) djrpc (5.0.0.cots) docflex-doclet (1.6.1.cots) echo2 (2.1.0.rc2.0000.cots) ehcache (1.2.4.cots) j2ssh (0.2.9.0000.cots) javaenums (25.5.0035.sls) jboss (4.0.5002.GA) jboss-spring-deployer (2.0.0.0000.cots) jsftp (1.2.0001.cr) jsnmpagent (1.0.1000.cr) junit (4.3.0.cots) olsrpc4j (28.0.0039.sls) quartz (1.5.2.0000.cots) slf4j (1.4.3.cots) springframework (2.0.5.cots) xmlbeans (2.2.0.cots) xstream (1.2.2.0000.cots)"></property>
    <property name="ant.java.version" value="1.5"></property>
    <property name="basedir" value="C:\ClearCase\UtfIntegration"></property>
    <property name="java.class.version" value="49.0"></property>
    <property name="ant.home" value="C:/LocalData/ProgramFiles/apache-ant-1.6.5"></property>
    <property name="build.ejb.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/ejb"></property>
    <property name="PACKAGE_olsrpc4j" value="V:/dpkg_archive/olsrpc4j/28.0.0039.sls"></property>
    <property name="PACKAGE_accountId" value="V:/dpkg_archive/accountId/19.0.3000.mas"></property>
    <property name="sun.boot.library.path" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin"></property>
    <property name="build.dir" value="C:\ClearCase\UtfIntegration/build"></property>
    <property name="sun.management.compiler" value="HotSpot Client Compiler"></property>
    <property name="java.awt.graphicsenv" value="sun.awt.Win32GraphicsEnvironment"></property>
    <property name="user.variant" value=""></property>
    <property name="build.stubs.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/stubs"></property>
    <property name="PACKAGE_djrpc" value="V:/dpkg_archive/djrpc/5.0.0.cots"></property>
    <property name="PACKAGE.olsrpc4j" value="28.0.0039.sls"></property>
    <property name="src.api.dir" value="C:\ClearCase\UtfIntegration/api"></property>
    <property name="PACKAGE_jsftp" value="V:/dpkg_archive/jsftp/1.2.0001.cr"></property>
    <property name="jar.test.dir" value="C:\ClearCase\UtfIntegration/junit/jars"></property>
    <property name="PACKAGE_docflex-doclet" value="V:/dpkg_archive/docflex-doclet/1.6.1.cots"></property>
    <property name="build.war.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/war"></property>
    <property name="ant.project.name" value="SLSInterface"></property>
    <property name="PACKAGE_ehcache" value="V:/dpkg_archive/ehcache/1.2.4.cots"></property>
    <property name="java.vm.specification.version" value="1.0"></property>
    <property name="src.core.dir" value="C:\ClearCase\UtfIntegration/src/core"></property>
    <property name="awt.toolkit" value="sun.awt.windows.WToolkit"></property>
    <property name="sun.cpu.isalist" value="pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86"></property>
    <property name="java.ext.dirs" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\ext"></property>
    <property name="os.version" value="6.1"></property>
    <property name="user.home" value="C:\Users\rpuchmay"></property>
    <property name="java.vm.vendor" value="Sun Microsystems Inc."></property>
    <property name="build.remote.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/remote"></property>
    <property name="PACKAGE_springframework" value="V:/dpkg_archive/springframework/2.0.5.cots"></property>
    <property name="src.war.dir" value="C:\ClearCase\UtfIntegration/src/war"></property>
    <property name="user.dir" value="C:\ClearCase\UtfIntegration\build\test"></property>
    <property name="MINOR" value="0"></property>
    <property name="PATCHBUILD" value="1000"></property>
    <property name="test.dir" value="C:\ClearCase\UtfIntegration/build/test"></property>
    <property name="PACKAGE.xstream" value="1.2.2.0000.cots"></property>
    <property name="PACKAGE.accountId" value="19.0.3000.mas"></property>
    <property name="sun.cpu.endian" value="little"></property>
    <property name="build.client.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/client"></property>
    <property name="PACKAGE_slf4j" value="V:/dpkg_archive/slf4j/1.4.3.cots"></property>
    <property name="PACKAGE.jboss" value="4.0.5002.GA"></property>
    <property name="java.vm.version" value="1.5.0_22-b03"></property>
    <property name="java.class.path" value="C:\ClearCase\UtfIntegration\build\test\AllTests.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-api.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-client.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-core.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-ejb.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-remote.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-stubs.jar;C:\ClearCase\UtfIntegration\build\jar\SLSInterface-xml.jar;V:\dpkg_archive\accountId\19.0.3000.mas\jar\accountId.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-all.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-analysis.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-attrs.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-commons.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-tree.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-util.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm-xml.jar;V:\dpkg_archive\asm\2.2.2.0000.cots\jar\asm.jar;V:\dpkg_archive\djrpc\5.0.0.cots\jar\djrpc.jar;V:\dpkg_archive\djrpc\5.0.0.cots\jar\xmlrpc.jar;V:\dpkg_archive\echo2\2.1.0.rc2.0000.cots\jar\Echo2_App.jar;V:\dpkg_archive\echo2\2.1.0.rc2.0000.cots\jar\Echo2_WebContainer.jar;V:\dpkg_archive\echo2\2.1.0.rc2.0000.cots\jar\Echo2_WebRender.jar;V:\dpkg_archive\ehcache\1.2.4.cots\jar\ehcache.jar;V:\dpkg_archive\j2ssh\0.2.9.0000.cots\jar\j2ssh-ant.jar;V:\dpkg_archive\j2ssh\0.2.9.0000.cots\jar\j2ssh-common.jar;V:\dpkg_archive\j2ssh\0.2.9.0000.cots\jar\j2ssh-core.jar;V:\dpkg_archive\j2ssh\0.2.9.0000.cots\jar\j2ssh-daemon.jar;V:\dpkg_archive\javaenums\25.5.0035.sls\jar\mass-enums.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\activation.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\antlr-2.7.6.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\avalon-framework.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\commons-httpclient.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\commons-logging.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\concurrent.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\ejb3-persistence.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\getopt.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\hibernate-annotations.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\hibernate-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jacorb.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\javassist.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\javax.servlet.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-annotations-ejb3.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-aop-jdk50-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-aspect-jdk50-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-common-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-deployment.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-ejb3-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-ejb3x.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-iiop-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-j2ee.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-jaxrpc.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-jsr77-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-remoting.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-saaj.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-serialization.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-srp-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-system-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-transaction-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jboss-xml-binding.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbossall-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbosscx-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbossha-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbossjmx-ant.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbossmq-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbosssx-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jbossws-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jmx-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jmx-invoker-adaptor-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\jnp-client.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\juddisaaj.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\log4j.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\logkit.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\mail.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\scout.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\trove.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\wsdl4j.jar;V:\dpkg_archive\jboss\4.0.5002.GA\client\xmlsec.jar;V:\dpkg_archive\jboss-spring-deployer\2.0.0.0000.cots\jboss-spring-jdk5.deployer\jboss-spring-jdk5.jar;V:\dpkg_archive\jsftp\1.2.0001.cr\jar\jsftp.jar;V:\dpkg_archive\jsnmpagent\1.0.1000.cr\jar\mass-jsnmpagent.jar;V:\dpkg_archive\olsrpc4j\28.0.0039.sls\jar\licence.jar;V:\dpkg_archive\olsrpc4j\28.0.0039.sls\jar\olsrpc4j.jar;V:\dpkg_archive\quartz\1.5.2.0000.cots\jar\quartz.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-api.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-jcl.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-jdk14.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-log4j12.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-nop.jar;V:\dpkg_archive\slf4j\1.4.3.cots\jar\slf4j-simple.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-aop.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-aspects.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-beans.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-context.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-core.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-dao.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-hibernate2.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-hibernate3.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-jdbc.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-jmx.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-jpa.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-mock.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-remoting.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-support.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-web.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring-webmvc.jar;V:\dpkg_archive\springframework\2.0.5.cots\jar\spring.jar;V:\dpkg_archive\xmlbeans\2.2.0.cots\jar\jsr173_1.0_api.jar;V:\dpkg_archive\xmlbeans\2.2.0.cots\jar\resolver.jar;V:\dpkg_archive\xmlbeans\2.2.0.cots\jar\xbean.jar;V:\dpkg_archive\xmlbeans\2.2.0.cots\jar\xbean_xpath.jar;V:\dpkg_archive\xmlbeans\2.2.0.cots\jar\xmlpublic.jar;V:\dpkg_archive\xstream\1.2.2.0000.cots\jar\xpp3_min-1.1.3.4.O.jar;V:\dpkg_archive\xstream\1.2.2.0000.cots\jar\xstream.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\activation.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\antlr-2.7.6.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\avalon-framework.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\bcel.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\bindingservice-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\bsh-1.3.0.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\bsh-deployer.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\cglib.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\commons-httpclient.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\commons-logging.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\dom4j.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\ejb3-persistence.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\hibernate-annotations.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\hibernate-entitymanager.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\hibernate3.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\hsqldb-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\hsqldb.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jacorb.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\javassist.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\javax.servlet.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\javax.servlet.jsp.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jaxen.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-backport-concurrent.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-cache.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-common-jdbc-wrapper.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-hibernate.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-iiop.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-j2ee.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-jaxrpc.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-jca.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-jsr77.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-jsr88.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-management.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-monitoring.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-remoting-int.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-remoting.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-saaj.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-serialization.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-srp.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss-transaction.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jboss.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jbossmq.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jbossretro-rt.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jbosssx.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jgroups.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jmx-adaptor-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jnpserver.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\joesnmp.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jpl-pattern.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\jpl-util.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\log4j-snmp-appender.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\log4j.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\mail-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\mail.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\properties-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\quartz-all-1.5.2.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\scheduler-plugin-example.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\scheduler-plugin.jar;V:\dpkg_archive\jboss\4.0.5002.GA\server\default\lib\xmlentitymgr.jar;V:\dpkg_archive\junit\4.3.0.cots\jar\junit.jar;C:\ClearCase\UtfIntegration\junit\jars\dbunit-2.4.9.jar;C:\ClearCase\UtfIntegration\junit\jars\h2-1.3.168.jar;C:\ClearCase\UtfIntegration\junit\jars\commons-collections-3.2.1.jar;C:\ClearCase\UtfIntegration\build\test\ejb.jar;C:\ClearCase\UtfIntegration\build\test\war.jar;C:\ClearCase\UtfIntegration\build\test;C:\LocalData\ProgramFiles\apache-ant-1.6.5\lib\ant-launcher.jar;C:\LocalData\ProgramFiles\apache-ant-1.6.5\lib\ant.jar;C:\LocalData\ProgramFiles\apache-ant-1.6.5\lib\ant-junit.jar"></property>
    <property name="ant.library.dir" value="C:\LocalData\ProgramFiles\apache-ant-1.6.5\lib"></property>
    <property name="os.arch" value="x86"></property>
    <property name="PACKAGE.springframework" value="2.0.5.cots"></property>
    <property name="PACKAGE_jsnmpagent" value="V:/dpkg_archive/jsnmpagent/1.0.1000.cr"></property>
    <property name="package.dir" value="C:\ClearCase\UtfIntegration/build/jar"></property>
    <property name="sun.java.launcher" value="SUN_STANDARD"></property>
    <property name="MINOR_STR" value="0"></property>
    <property name="ant.file.SLSInterface" value="C:\ClearCase\UtfIntegration\SLSInterface.xml"></property>
    <property name="java.vm.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="file.separator" value="\"></property>
    <property name="java.runtime.version" value="1.5.0_22-b03"></property>
    <property name="sun.boot.class.path" value="C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\rt.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\i18n.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\sunrsasign.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\jsse.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\jce.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\charsets.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\classes"></property>
    <property name="PACKAGE_junit" value="V:/dpkg_archive/junit/4.3.0.cots"></property>
    <property name="build.gensrc.dir" value="C:\ClearCase\UtfIntegration/build/gensrc/xml"></property>
    <property name="build.api.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes/api"></property>
    <property name="user.country" value="AU"></property>
    <property name="xmlIsUpToDate" value="true"></property>
    <property name="VERSION" value="5.0.1000"></property>
    <property name="build.classes.dir" value="C:\ClearCase\UtfIntegration/build/classes"></property>
    <property name="src.ejb.dir" value="C:\ClearCase\UtfIntegration/src/ejb"></property>
    <property name="PACKAGE_xmlbeans" value="V:/dpkg_archive/xmlbeans/2.2.0.cots"></property>
    <property name="java.vendor" value="Sun Microsystems Inc."></property>
    <property name="PACKAGE.ehcache" value="1.2.4.cots"></property>
    <property name="PATCH_STR" value="1"></property>
    <property name="PACKAGE.djrpc" value="5.0.0.cots"></property>
    <property name="java.specification.version" value="1.5"></property>
    <property name="sun.arch.data.model" value="32"></property>
  </properties>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"/>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0" />
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.045"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadEnableTransactions(PatronServicesImpl.java:323)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadEnableTransactionNoStartDate(PatronServicesImplTest.java:146)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadEnableTransactions(PatronServicesImpl.java:323)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadEnableTransactionNoEndDate(PatronServicesImplTest.java:156)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadEnableTransactions(PatronServicesImpl.java:323)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadEnableTransactionNoDates(PatronServicesImplTest.java:164)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadDisableTransactions(PatronServicesImpl.java:330)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadDisableTransactionNoStartDate(PatronServicesImplTest.java:174)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadDisableTransactions(PatronServicesImpl.java:330)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadDisableTransactionNoEndDate(PatronServicesImplTest.java:184)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadDisableTransactions(PatronServicesImpl.java:330)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadDisableTransactionNoDates(PatronServicesImplTest.java:192)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadTopupTransactions(PatronServicesImpl.java:337)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadTopupTransactionNoStartDate(PatronServicesImplTest.java:202)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadTopupTransactions(PatronServicesImpl.java:337)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadTopupTransactionNoEndDate(PatronServicesImplTest.java:212)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0">
    <error message="Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;" type="java.lang.Exception">java.lang.Exception: Unexpected exception, expected&lt;com.erggroup.sls.card.InvalidDateRangeException&gt; but was&lt;java.lang.NullPointerException&gt;
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:91)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
Caused by: java.lang.NullPointerException
        at com.erggroup.sls.impl.PatronServicesImpl.getPurseAutoloadTopupTransactions(PatronServicesImpl.java:337)
        at com.erggroup.tests.PatronServicesImplTest.testGetAutoloadTopupTransactionNoDates(PatronServicesImplTest.java:220)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        ... 16 more
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.766"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.386"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.431"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.345"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.36"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.265"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.285"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.255"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.315"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.318"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.272"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.225"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="2.204"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.045"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.04"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.025"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.12"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.04"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.025"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.025"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.04"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.025"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.012"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0060"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.015"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.02"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.01"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="2.633"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.025">
    <error message="expected:&lt;5&gt; but was:&lt;3&gt;" type="java.lang.AssertionError">java.lang.AssertionError: expected:&lt;5&gt; but was:&lt;3&gt;
        at org.junit.Assert.fail(Assert.java:71)
        at org.junit.Assert.failNotEquals(Assert.java:451)
        at org.junit.Assert.assertEquals(Assert.java:99)
        at org.junit.Assert.assertEquals(Assert.java:116)
        at com.erggroup.tests.ProductOrderBuilderUtilTest.test(ProductOrderBuilderUtilTest.java:63)
        at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
        at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
        at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
        at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
        at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java:29)
        at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
        at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
        at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
        at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:32)
</error>
  </testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.262"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.23"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.305"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.226"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.215"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.22"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.22"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.225"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.2"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.225"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.091"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0050"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.0"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.225"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.165"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.215"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.155"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.216"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.15"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.14"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.22"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.155"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.19"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.26"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.145"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.14"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.215"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.146"></testcase>
  <testcase classname="junit.framework.JUnit4TestCaseFacade" name="unknown" time="0.144"></testcase>
  <system-out><![CDATA[Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_8_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_8_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_8_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_8_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_8_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_8_,
        autoloadre0_.CARD_TYPE as CARD14_8_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_8_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_8_,
        autoloadre0_.TXN_DATE_TIME as TXN3_8_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_8_,
        autoloadre0_.UD_TYPE as UD6_8_,
        autoloadre0_.UD_SUBTYPE as UD7_8_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_8_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_8_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_8_,
        autoloadre0_.SALES_TAX as SALES11_8_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_8_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_10_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_10_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_10_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_10_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_50_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_50_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_50_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_50_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_50_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_50_,
        autoloadre0_.CARD_TYPE as CARD14_50_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_50_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_50_,
        autoloadre0_.TXN_DATE_TIME as TXN3_50_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_50_,
        autoloadre0_.UD_TYPE as UD6_50_,
        autoloadre0_.UD_SUBTYPE as UD7_50_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_50_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_50_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_50_,
        autoloadre0_.SALES_TAX as SALES11_50_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_50_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_52_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_52_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_52_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_52_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_52_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_52_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_52_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_52_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_92_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_92_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_92_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_92_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_92_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_92_,
        autoloadre0_.CARD_TYPE as CARD14_92_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_92_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_92_,
        autoloadre0_.TXN_DATE_TIME as TXN3_92_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_92_,
        autoloadre0_.UD_TYPE as UD6_92_,
        autoloadre0_.UD_SUBTYPE as UD7_92_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_92_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_92_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_92_,
        autoloadre0_.SALES_TAX as SALES11_92_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_92_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_94_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_94_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_94_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_94_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_94_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_94_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_94_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_94_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_134_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_134_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_134_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_134_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_134_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_134_,
        autoloadre0_.CARD_TYPE as CARD14_134_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_134_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_134_,
        autoloadre0_.TXN_DATE_TIME as TXN3_134_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_134_,
        autoloadre0_.UD_TYPE as UD6_134_,
        autoloadre0_.UD_SUBTYPE as UD7_134_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_134_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_134_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_134_,
        autoloadre0_.SALES_TAX as SALES11_134_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_134_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_136_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_136_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_136_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_136_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_176_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_176_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_176_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_176_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_176_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_176_,
        autoloadre0_.CARD_TYPE as CARD14_176_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_176_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_176_,
        autoloadre0_.TXN_DATE_TIME as TXN3_176_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_176_,
        autoloadre0_.UD_TYPE as UD6_176_,
        autoloadre0_.UD_SUBTYPE as UD7_176_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_176_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_176_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_176_,
        autoloadre0_.SALES_TAX as SALES11_176_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_176_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_178_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_178_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_178_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_178_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_218_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_218_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_218_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_218_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_218_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_218_,
        autoloadre0_.CARD_TYPE as CARD14_218_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_218_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_218_,
        autoloadre0_.TXN_DATE_TIME as TXN3_218_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_218_,
        autoloadre0_.UD_TYPE as UD6_218_,
        autoloadre0_.UD_SUBTYPE as UD7_218_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_218_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_218_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_218_,
        autoloadre0_.SALES_TAX as SALES11_218_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_218_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_220_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_220_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_220_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_220_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_ENABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_260_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_260_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_260_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_260_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_260_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_260_,
        autoloadre0_.CARD_TYPE as CARD14_260_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_260_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_260_,
        autoloadre0_.TXN_DATE_TIME as TXN3_260_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_260_,
        autoloadre0_.UD_TYPE as UD6_260_,
        autoloadre0_.UD_SUBTYPE as UD7_260_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_260_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_260_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_260_,
        autoloadre0_.SALES_TAX as SALES11_260_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_260_ 
    from
        RP_TXN autoloadre0_,
        RP_STREAMING_SESSION streamings1_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings1_.STREAMING_SESSION_ID 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.SYSTEM_ID=? 
        and (
            streamings1_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings1_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_262_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_262_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_262_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_262_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_262_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_262_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_262_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_262_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_DISABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_302_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_302_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_302_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_302_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_302_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_302_,
        autoloadre0_.CARD_TYPE as CARD14_302_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_302_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_302_,
        autoloadre0_.TXN_DATE_TIME as TXN3_302_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_302_,
        autoloadre0_.UD_TYPE as UD6_302_,
        autoloadre0_.UD_SUBTYPE as UD7_302_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_302_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_302_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_302_,
        autoloadre0_.SALES_TAX as SALES11_302_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_302_ 
    from
        RP_TXN autoloadre0_,
        PRODUCT_AUTOLOAD_FACILITY productaut1_,
        RP_STREAMING_SESSION streamings2_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings2_.STREAMING_SESSION_ID 
        and autoloadre0_.CARD_SERIAL_NUMBER=productaut1_.CSC_SERIAL_NUMBER 
        and autoloadre0_.PRODUCT_SERIAL_NUMBER=productaut1_.PROD_SERIAL_NUMBER 
        and autoloadre0_.CARD_ISSUER_ID=productaut1_.CSC_ISSUER_ID 
        and autoloadre0_.CARD_LIFE_CYCLE_COUNT=productaut1_.CSC_LIFECYCLE_COUNT 
        and autoloadre0_.CARD_TYPE=productaut1_.CSC_TYPE 
        and autoloadre0_.APPLICATION_PROVIDER_ID=productaut1_.APP_PROVIDER_ID 
        and autoloadre0_.APPLICATION_SERIAL_NUMBER=productaut1_.APP_SERIAL_NUMBER 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and productaut1_.SYSTEM_ID=? 
        and (
            streamings2_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings2_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_304_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_304_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_304_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_304_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_DISABLE_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_344_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_344_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_344_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_344_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_344_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_344_,
        autoloadre0_.CARD_TYPE as CARD14_344_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_344_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_344_,
        autoloadre0_.TXN_DATE_TIME as TXN3_344_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_344_,
        autoloadre0_.UD_TYPE as UD6_344_,
        autoloadre0_.UD_SUBTYPE as UD7_344_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_344_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_344_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_344_,
        autoloadre0_.SALES_TAX as SALES11_344_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_344_ 
    from
        RP_TXN autoloadre0_,
        PRODUCT_AUTOLOAD_FACILITY productaut1_,
        RP_STREAMING_SESSION streamings2_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings2_.STREAMING_SESSION_ID 
        and autoloadre0_.CARD_SERIAL_NUMBER=productaut1_.CSC_SERIAL_NUMBER 
        and autoloadre0_.PRODUCT_SERIAL_NUMBER=productaut1_.PROD_SERIAL_NUMBER 
        and autoloadre0_.CARD_ISSUER_ID=productaut1_.CSC_ISSUER_ID 
        and autoloadre0_.CARD_LIFE_CYCLE_COUNT=productaut1_.CSC_LIFECYCLE_COUNT 
        and autoloadre0_.CARD_TYPE=productaut1_.CSC_TYPE 
        and autoloadre0_.APPLICATION_PROVIDER_ID=productaut1_.APP_PROVIDER_ID 
        and autoloadre0_.APPLICATION_SERIAL_NUMBER=productaut1_.APP_SERIAL_NUMBER 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and productaut1_.SYSTEM_ID=? 
        and (
            streamings2_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings2_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_346_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_346_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_346_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_346_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_TOPUP_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_386_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_386_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_386_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_386_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_386_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_386_,
        autoloadre0_.CARD_TYPE as CARD14_386_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_386_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_386_,
        autoloadre0_.TXN_DATE_TIME as TXN3_386_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_386_,
        autoloadre0_.UD_TYPE as UD6_386_,
        autoloadre0_.UD_SUBTYPE as UD7_386_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_386_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_386_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_386_,
        autoloadre0_.SALES_TAX as SALES11_386_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_386_ 
    from
        RP_TXN autoloadre0_,
        PRODUCT_AUTOLOAD_FACILITY productaut1_,
        RP_STREAMING_SESSION streamings2_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings2_.STREAMING_SESSION_ID 
        and autoloadre0_.CARD_SERIAL_NUMBER=productaut1_.CSC_SERIAL_NUMBER 
        and autoloadre0_.PRODUCT_SERIAL_NUMBER=productaut1_.PROD_SERIAL_NUMBER 
        and autoloadre0_.CARD_ISSUER_ID=productaut1_.CSC_ISSUER_ID 
        and autoloadre0_.CARD_LIFE_CYCLE_COUNT=productaut1_.CSC_LIFECYCLE_COUNT 
        and autoloadre0_.CARD_TYPE=productaut1_.CSC_TYPE 
        and autoloadre0_.APPLICATION_PROVIDER_ID=productaut1_.APP_PROVIDER_ID 
        and autoloadre0_.APPLICATION_SERIAL_NUMBER=productaut1_.APP_SERIAL_NUMBER 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.PAYMENT_METHOD0=? 
        and productaut1_.SYSTEM_ID=? 
        and (
            streamings2_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings2_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_388_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_388_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_388_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_388_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* named HQL query AutoloadReportsTransaction.GET_AUTOLOAD_TOPUP_TRANSACTIONS_QUERY */ select
        autoloadre0_.RP_TXN_ID as RP1_428_,
        autoloadre0_.CARD_SERIAL_NUMBER as CARD2_428_,
        autoloadre0_.STREAMING_SESSION_ID as STREAMING18_428_,
        autoloadre0_.PRODUCT_SERIAL_NUMBER as PRODUCT5_428_,
        autoloadre0_.CARD_ISSUER_ID as CARD12_428_,
        autoloadre0_.CARD_LIFE_CYCLE_COUNT as CARD13_428_,
        autoloadre0_.CARD_TYPE as CARD14_428_,
        autoloadre0_.APPLICATION_PROVIDER_ID as APPLICA15_428_,
        autoloadre0_.APPLICATION_SERIAL_NUMBER as APPLICA16_428_,
        autoloadre0_.TXN_DATE_TIME as TXN3_428_,
        autoloadre0_.PAYMENT_VALUE0 as PAYMENT4_428_,
        autoloadre0_.UD_TYPE as UD6_428_,
        autoloadre0_.UD_SUBTYPE as UD7_428_,
        autoloadre0_.PAYMENT_METHOD0 as PAYMENT8_428_,
        autoloadre0_.NUMBER_OF_PAYMENTS as NUMBER9_428_,
        autoloadre0_.PRODUCT_ISSUER_ID as PRODUCT10_428_,
        autoloadre0_.SALES_TAX as SALES11_428_,
        autoloadre0_.SYSTEM_ID as SYSTEM17_428_ 
    from
        RP_TXN autoloadre0_,
        PRODUCT_AUTOLOAD_FACILITY productaut1_,
        RP_STREAMING_SESSION streamings2_ 
    where
        autoloadre0_.STREAMING_SESSION_ID=streamings2_.STREAMING_SESSION_ID 
        and autoloadre0_.CARD_SERIAL_NUMBER=productaut1_.CSC_SERIAL_NUMBER 
        and autoloadre0_.PRODUCT_SERIAL_NUMBER=productaut1_.PROD_SERIAL_NUMBER 
        and autoloadre0_.CARD_ISSUER_ID=productaut1_.CSC_ISSUER_ID 
        and autoloadre0_.CARD_LIFE_CYCLE_COUNT=productaut1_.CSC_LIFECYCLE_COUNT 
        and autoloadre0_.CARD_TYPE=productaut1_.CSC_TYPE 
        and autoloadre0_.APPLICATION_PROVIDER_ID=productaut1_.APP_PROVIDER_ID 
        and autoloadre0_.APPLICATION_SERIAL_NUMBER=productaut1_.APP_SERIAL_NUMBER 
        and autoloadre0_.UD_TYPE=? 
        and autoloadre0_.UD_SUBTYPE=? 
        and autoloadre0_.PAYMENT_METHOD0=? 
        and productaut1_.SYSTEM_ID=? 
        and (
            streamings2_.TXN_TRANSFER_DATE between ? and ?
        ) 
    order by
        autoloadre0_.CARD_SERIAL_NUMBER ASC,
        streamings2_.TXN_TRANSFER_DATE DESC
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Hibernate: 
    /* load com.erggroup.mass.ejb3.reports.StreamingSessionRecord */ select
        streamings0_.STREAMING_SESSION_ID as STREAMING1_430_0_,
        streamings0_.TXN_TRANSFER_DATE as TXN2_430_0_,
        streamings0_.SETTLEMENT_DATE as SETTLEMENT3_430_0_,
        streamings0_.TXN_PASSUSE_TRANSFER_DATE as TXN4_430_0_ 
    from
        RP_STREAMING_SESSION streamings0_ 
    where
        streamings0_.STREAMING_SESSION_ID=?
Sub-order: C3 status com.erggroup.sls.CardActionlistEntryImpl@327236
Sub-order: C1 status com.erggroup.sls.CardActionlistEntryImpl@1e84195
Sub-order: C9 status com.erggroup.sls.CardActionlistEntryImpl@129dcc0
Sub-order: C23 status com.erggroup.sls.CardActionlistEntryImpl@15be8d3
Sub-order: C3 status com.erggroup.sls.CardActionlistEntryImpl@6df9bc
Sub-order: C1 status com.erggroup.sls.CardActionlistEntryImpl@26c088
Sub-order: C9 status com.erggroup.sls.CardActionlistEntryImpl@2a3135
Sub-order: C23 status com.erggroup.sls.CardActionlistEntryImpl@4b7b1
Sub-order: C3 status com.erggroup.sls.CardActionlistEntryImpl@48ff68
Sub-order: C1 status com.erggroup.sls.CardActionlistEntryImpl@781046
Sub-order: C9 status com.erggroup.sls.CardActionlistEntryImpl@746d23
Sub-order: C23 status com.erggroup.sls.CardActionlistEntryImpl@1a9192b
Sub-order: C3 status com.erggroup.sls.CardActionlistEntryImpl@6c7a64
Sub-order: C1 status com.erggroup.sls.CardActionlistEntryImpl@1d742a1
Sub-order: C9 status com.erggroup.sls.CardActionlistEntryImpl@1579371
Sub-order: C23 status com.erggroup.sls.CardActionlistEntryImpl@90fd20
Sub-order: C3 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@166de01
Sub-order: C1 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@7946a2
Sub-order: C9 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@c7272
Sub-order: C23 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@12da4a6
Sub-order: C3 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@15b555
Sub-order: C1 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@1341e11
Sub-order: C9 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@a20232
Sub-order: C23 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@3e48f2
Sub-order: C3 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@14d774f
Sub-order: C1 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@d3f189
Sub-order: C9 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@96985e
Sub-order: C23 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@ed7d11
Sub-order: C3 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@15e4dbe
Sub-order: C1 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@420e44
Sub-order: C9 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@b6a5fb
Sub-order: C23 I101 P1 status com.erggroup.sls.ProductActionlistEntryImpl@14b1fda
Hibernate: 
    /* named HQL query CDProductCategory.QUERY_VERSIONED_CATEGORIES */ select
        distinct cdproductc0_.PK as PK474_,
        cdproductc0_.DISPLAY_ORDER as DISPLAY2_474_,
        cdproductc0_.ENABLE as ENABLE474_,
        cdproductc0_.GLOBALVERSION_FK as GLOBALVE4_474_,
        cdproductc0_.NAME_SV as NAME5_474_,
        cdproductc0_.LAST_UPDATE_DATE as LAST6_474_,
        cdproductc0_.LAST_UPDATE_USER as LAST7_474_,
        cdproductc0_.ORIGINAL_PK as ORIGINAL8_474_,
        cdproductc0_.NAME as NAME474_,
        cdproductc0_.DESCRIPTION as DESCRIP10_474_ 
    from
        PRODUCT_CATEGORY cdproductc0_,
        PRODUCT_CATEGORY_ELEMENT cdproductc1_ 
    where
        cdproductc0_.GLOBALVERSION_FK=? 
        and cdproductc0_.PK=cdproductc1_.PRODUCT_CATEGORY_FK 
        and cdproductc0_.ENABLE=1 
    order by
        cdproductc0_.DISPLAY_ORDER
Hibernate: 
    /* named HQL query CDMassProduct.queryProductsForCategory */ select
        productsal1_.PRODUCT_FK as col_0_0_,
        productsal1_.DEVICE_DISPLAY_PRIORITY as col_1_0_,
        cdmassprod4_.pk as pk476_,
        cdmassprod4_.MAX_PURSE_VALUE as MAX2_476_,
        cdmassprod4_.PRODUCT_TYPE as PRODUCT3_476_,
        cdmassprod4_.GLOBALVERSION_FK as GLOBALVE4_476_,
        cdmassprod4_.NAME_SV as NAME5_476_,
        cdmassprod4_.MAXIMUM_DEPOSIT_VALUE as MAXIMUM6_476_,
        cdmassprod4_.MINIMUM_DEPOSIT_VALUE as MINIMUM7_476_,
        cdmassprod4_.WITHDRAWN_FROM_SALE as WITHDRAWN8_476_,
        cdmassprod4_.ENUM_PRODUCT_MEDIUM_FK as ENUM9_476_,
        cdmassprod4_.TAX_RATE_FK as TAX15_476_,
        cdmassprod4_.DESCRIPTION_SV as DESCRIP10_476_,
        cdmassprod4_.MIN_INITIAL_PURSE_VALUE as MIN11_476_,
        cdmassprod4_.MIN_FINAL_PURSE_VALUE as MIN12_476_,
        cdmassprod4_.name as name476_,
        cdmassprod4_.description as descrip14_476_ 
    from
        PRODUCT_SALES_PROFILE productsal0_,
        PDT_SALES_PROFILE_ATTR productsal1_ 
    inner join
        MASS_PRODUCT cdmassprod4_ 
            on productsal1_.PRODUCT_FK=cdmassprod4_.pk,
        PRODUCT_CATEGORY_ELEMENT cdproductc2_,
        PRODUCT_CATEGORY cdproductc3_ 
    where
        cdproductc2_.GLOBALVERSION_FK=? 
        and productsal1_.PRODUCT_SALES_PROFILE_FK=productsal0_.pk 
        and productsal0_.name=? 
        and cdproductc3_.PK=? 
        and cdproductc3_.ENABLE=1 
        and cdproductc2_.MASS_PRODUCT_FK=productsal1_.PRODUCT_FK 
        and cdproductc2_.PRODUCT_CATEGORY_FK=cdproductc3_.PK 
    order by
        productsal1_.DEVICE_DISPLAY_PRIORITY
Hibernate: 
    /* load com.erggroup.mass.ejb3.cd.CDTaxCode */ select
        cdtaxcode0_.pk as pk477_0_,
        cdtaxcode0_.TAX_RATE as TAX2_477_0_ 
    from
        TAX_CODE cdtaxcode0_ 
    where
        cdtaxcode0_.pk=?
Hibernate: 
    /* named HQL query CDMassProduct.queryProductsForCategory */ select
        productsal1_.PRODUCT_FK as col_0_0_,
        productsal1_.DEVICE_DISPLAY_PRIORITY as col_1_0_,
        cdmassprod4_.pk as pk476_,
        cdmassprod4_.MAX_PURSE_VALUE as MAX2_476_,
        cdmassprod4_.PRODUCT_TYPE as PRODUCT3_476_,
        cdmassprod4_.GLOBALVERSION_FK as GLOBALVE4_476_,
        cdmassprod4_.NAME_SV as NAME5_476_,
        cdmassprod4_.MAXIMUM_DEPOSIT_VALUE as MAXIMUM6_476_,
        cdmassprod4_.MINIMUM_DEPOSIT_VALUE as MINIMUM7_476_,
        cdmassprod4_.WITHDRAWN_FROM_SALE as WITHDRAWN8_476_,
        cdmassprod4_.ENUM_PRODUCT_MEDIUM_FK as ENUM9_476_,
        cdmassprod4_.TAX_RATE_FK as TAX15_476_,
        cdmassprod4_.DESCRIPTION_SV as DESCRIP10_476_,
        cdmassprod4_.MIN_INITIAL_PURSE_VALUE as MIN11_476_,
        cdmassprod4_.MIN_FINAL_PURSE_VALUE as MIN12_476_,
        cdmassprod4_.name as name476_,
        cdmassprod4_.description as descrip14_476_ 
    from
        PRODUCT_SALES_PROFILE productsal0_,
        PDT_SALES_PROFILE_ATTR productsal1_ 
    inner join
        MASS_PRODUCT cdmassprod4_ 
            on productsal1_.PRODUCT_FK=cdmassprod4_.pk,
        PRODUCT_CATEGORY_ELEMENT cdproductc2_,
        PRODUCT_CATEGORY cdproductc3_ 
    where
        cdproductc2_.GLOBALVERSION_FK=? 
        and productsal1_.PRODUCT_SALES_PROFILE_FK=productsal0_.pk 
        and productsal0_.name=? 
        and cdproductc3_.PK=? 
        and cdproductc3_.ENABLE=1 
        and cdproductc2_.MASS_PRODUCT_FK=productsal1_.PRODUCT_FK 
        and cdproductc2_.PRODUCT_CATEGORY_FK=cdproductc3_.PK 
    order by
        productsal1_.DEVICE_DISPLAY_PRIORITY
Hibernate: 
    /* named HQL query CDMassProduct.queryProductsForCategory */ select
        productsal1_.PRODUCT_FK as col_0_0_,
        productsal1_.DEVICE_DISPLAY_PRIORITY as col_1_0_,
        cdmassprod4_.pk as pk476_,
        cdmassprod4_.MAX_PURSE_VALUE as MAX2_476_,
        cdmassprod4_.PRODUCT_TYPE as PRODUCT3_476_,
        cdmassprod4_.GLOBALVERSION_FK as GLOBALVE4_476_,
        cdmassprod4_.NAME_SV as NAME5_476_,
        cdmassprod4_.MAXIMUM_DEPOSIT_VALUE as MAXIMUM6_476_,
        cdmassprod4_.MINIMUM_DEPOSIT_VALUE as MINIMUM7_476_,
        cdmassprod4_.WITHDRAWN_FROM_SALE as WITHDRAWN8_476_,
        cdmassprod4_.ENUM_PRODUCT_MEDIUM_FK as ENUM9_476_,
        cdmassprod4_.TAX_RATE_FK as TAX15_476_,
        cdmassprod4_.DESCRIPTION_SV as DESCRIP10_476_,
        cdmassprod4_.MIN_INITIAL_PURSE_VALUE as MIN11_476_,
        cdmassprod4_.MIN_FINAL_PURSE_VALUE as MIN12_476_,
        cdmassprod4_.name as name476_,
        cdmassprod4_.description as descrip14_476_ 
    from
        PRODUCT_SALES_PROFILE productsal0_,
        PDT_SALES_PROFILE_ATTR productsal1_ 
    inner join
        MASS_PRODUCT cdmassprod4_ 
            on productsal1_.PRODUCT_FK=cdmassprod4_.pk,
        PRODUCT_CATEGORY_ELEMENT cdproductc2_,
        PRODUCT_CATEGORY cdproductc3_ 
    where
        cdproductc2_.GLOBALVERSION_FK=? 
        and productsal1_.PRODUCT_SALES_PROFILE_FK=productsal0_.pk 
        and productsal0_.name=? 
        and cdproductc3_.PK=? 
        and cdproductc3_.ENABLE=1 
        and cdproductc2_.MASS_PRODUCT_FK=productsal1_.PRODUCT_FK 
        and cdproductc2_.PRODUCT_CATEGORY_FK=cdproductc3_.PK 
    order by
        productsal1_.DEVICE_DISPLAY_PRIORITY
Hibernate: 
    /* named HQL query CDMassProduct.queryProductsForCategory */ select
        productsal1_.PRODUCT_FK as col_0_0_,
        productsal1_.DEVICE_DISPLAY_PRIORITY as col_1_0_,
        cdmassprod4_.pk as pk476_,
        cdmassprod4_.MAX_PURSE_VALUE as MAX2_476_,
        cdmassprod4_.PRODUCT_TYPE as PRODUCT3_476_,
        cdmassprod4_.GLOBALVERSION_FK as GLOBALVE4_476_,
        cdmassprod4_.NAME_SV as NAME5_476_,
        cdmassprod4_.MAXIMUM_DEPOSIT_VALUE as MAXIMUM6_476_,
        cdmassprod4_.MINIMUM_DEPOSIT_VALUE as MINIMUM7_476_,
        cdmassprod4_.WITHDRAWN_FROM_SALE as WITHDRAWN8_476_,
        cdmassprod4_.ENUM_PRODUCT_MEDIUM_FK as ENUM9_476_,
        cdmassprod4_.TAX_RATE_FK as TAX15_476_,
        cdmassprod4_.DESCRIPTION_SV as DESCRIP10_476_,
        cdmassprod4_.MIN_INITIAL_PURSE_VALUE as MIN11_476_,
        cdmassprod4_.MIN_FINAL_PURSE_VALUE as MIN12_476_,
        cdmassprod4_.name as name476_,
        cdmassprod4_.description as descrip14_476_ 
    from
        PRODUCT_SALES_PROFILE productsal0_,
        PDT_SALES_PROFILE_ATTR productsal1_ 
    inner join
        MASS_PRODUCT cdmassprod4_ 
            on productsal1_.PRODUCT_FK=cdmassprod4_.pk,
        PRODUCT_CATEGORY_ELEMENT cdproductc2_,
        PRODUCT_CATEGORY cdproductc3_ 
    where
        cdproductc2_.GLOBALVERSION_FK=? 
        and productsal1_.PRODUCT_SALES_PROFILE_FK=productsal0_.pk 
        and productsal0_.name=? 
        and cdproductc3_.PK=? 
        and cdproductc3_.ENABLE=1 
        and cdproductc2_.MASS_PRODUCT_FK=productsal1_.PRODUCT_FK 
        and cdproductc2_.PRODUCT_CATEGORY_FK=cdproductc3_.PK 
    order by
        productsal1_.DEVICE_DISPLAY_PRIORITY
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummariesWithAutoload */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        paf.state                     as AUTOLOAD_STATUS_CODE,
        paf.system_id                 as SYSTEM_ID,
        sub.actionlist_action         as ACTIONLIST_ACTION,
        sub.actionlist_state          as ACTIONLIST_STATE,
        sub.actionlist_system_id      as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON  ca.csc_serial_number   = pa.csc_serial_number 
            AND ca.csc_type            = pa.csc_type 
            AND ca.csc_issuer_id       = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category       = 1 
    LEFT JOIN
        product_autoload_facility paf 
            ON  pa.csc_serial_number   = paf.csc_serial_number 
            AND pa.csc_type            = paf.csc_type 
            AND pa.csc_issuer_id       = paf.csc_issuer_id 
            AND pa.csc_lifecycle_count = paf.csc_lifecycle_count 
            AND pa.app_serial_number   = paf.app_serial_number 
            AND pa.prod_serial_number  = paf.prod_serial_number 
            AND pa.app_provider_id     = paf.app_provider_id 
    LEFT JOIN
        (
            SELECT
                pal.card_serial_number,
                pal.card_issuer_id,
                pal.card_type,
                pal.application_provider_id,
                pal.application_serial_number,
                pal.product_serial_number,
                a.state as ACTIONLIST_STATE,
                a.action as ACTIONLIST_ACTION,
                a.system_id as ACTIONLIST_SYSTEM_ID  
            FROM
                product_actionlist pal,
                actionlist a   
            WHERE
                pal.entry_id = a.entry_id   
                AND   a.state in (
                    ?, ?, ? 
                )   
                AND   a.action in (
                    ?, ? 
                ) 
        ) sub 
            ON pa.csc_serial_number   = sub.card_serial_number 
            AND pa.csc_issuer_id      = sub.card_issuer_id 
            AND pa.csc_type           = sub.card_type 
            AND pa.app_provider_id    = sub.application_provider_id 
            AND pa.app_serial_number  = sub.application_serial_number 
            AND pa.prod_serial_number = sub.product_serial_number 
    WHERE
        ca.csc_serial_number in (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummaries */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        NULL                          as AUTOLOAD_STATUS_CODE,
        NULL                          as SYSTEM_ID,
        NULL                          as ACTIONLIST_ACTION,
        NULL                          as ACTIONLIST_STATE,
        NULL                          as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON     ca.csc_serial_number = pa.csc_serial_number 
            AND ca.csc_type = pa.csc_type 
            AND ca.csc_issuer_id = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category = 1 
    WHERE
        ca.csc_serial_number in (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummaries */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        NULL                          as AUTOLOAD_STATUS_CODE,
        NULL                          as SYSTEM_ID,
        NULL                          as ACTIONLIST_ACTION,
        NULL                          as ACTIONLIST_STATE,
        NULL                          as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON     ca.csc_serial_number = pa.csc_serial_number 
            AND ca.csc_type = pa.csc_type 
            AND ca.csc_issuer_id = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category = 1 
    WHERE
        ca.csc_serial_number in (
            ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummariesWithAutoload */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        paf.state                     as AUTOLOAD_STATUS_CODE,
        paf.system_id                 as SYSTEM_ID,
        sub.actionlist_action         as ACTIONLIST_ACTION,
        sub.actionlist_state          as ACTIONLIST_STATE,
        sub.actionlist_system_id      as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON  ca.csc_serial_number   = pa.csc_serial_number 
            AND ca.csc_type            = pa.csc_type 
            AND ca.csc_issuer_id       = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category       = 1 
    LEFT JOIN
        product_autoload_facility paf 
            ON  pa.csc_serial_number   = paf.csc_serial_number 
            AND pa.csc_type            = paf.csc_type 
            AND pa.csc_issuer_id       = paf.csc_issuer_id 
            AND pa.csc_lifecycle_count = paf.csc_lifecycle_count 
            AND pa.app_serial_number   = paf.app_serial_number 
            AND pa.prod_serial_number  = paf.prod_serial_number 
            AND pa.app_provider_id     = paf.app_provider_id 
    LEFT JOIN
        (
            SELECT
                pal.card_serial_number,
                pal.card_issuer_id,
                pal.card_type,
                pal.application_provider_id,
                pal.application_serial_number,
                pal.product_serial_number,
                a.state as ACTIONLIST_STATE,
                a.action as ACTIONLIST_ACTION,
                a.system_id as ACTIONLIST_SYSTEM_ID  
            FROM
                product_actionlist pal,
                actionlist a   
            WHERE
                pal.entry_id = a.entry_id   
                AND   a.state in (
                    ?, ?, ? 
                )   
                AND   a.action in (
                    ?, ? 
                ) 
        ) sub 
            ON pa.csc_serial_number   = sub.card_serial_number 
            AND pa.csc_issuer_id      = sub.card_issuer_id 
            AND pa.csc_type           = sub.card_type 
            AND pa.app_provider_id    = sub.application_provider_id 
            AND pa.app_serial_number  = sub.application_serial_number 
            AND pa.prod_serial_number = sub.product_serial_number 
    WHERE
        ca.csc_serial_number in (
            ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummaries */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        NULL                          as AUTOLOAD_STATUS_CODE,
        NULL                          as SYSTEM_ID,
        NULL                          as ACTIONLIST_ACTION,
        NULL                          as ACTIONLIST_STATE,
        NULL                          as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON     ca.csc_serial_number = pa.csc_serial_number 
            AND ca.csc_type = pa.csc_type 
            AND ca.csc_issuer_id = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category = 1 
    WHERE
        ca.csc_serial_number in (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummariesWithAutoload */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        paf.state                     as AUTOLOAD_STATUS_CODE,
        paf.system_id                 as SYSTEM_ID,
        sub.actionlist_action         as ACTIONLIST_ACTION,
        sub.actionlist_state          as ACTIONLIST_STATE,
        sub.actionlist_system_id      as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON  ca.csc_serial_number   = pa.csc_serial_number 
            AND ca.csc_type            = pa.csc_type 
            AND ca.csc_issuer_id       = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category       = 1 
    LEFT JOIN
        product_autoload_facility paf 
            ON  pa.csc_serial_number   = paf.csc_serial_number 
            AND pa.csc_type            = paf.csc_type 
            AND pa.csc_issuer_id       = paf.csc_issuer_id 
            AND pa.csc_lifecycle_count = paf.csc_lifecycle_count 
            AND pa.app_serial_number   = paf.app_serial_number 
            AND pa.prod_serial_number  = paf.prod_serial_number 
            AND pa.app_provider_id     = paf.app_provider_id 
    LEFT JOIN
        (
            SELECT
                pal.card_serial_number,
                pal.card_issuer_id,
                pal.card_type,
                pal.application_provider_id,
                pal.application_serial_number,
                pal.product_serial_number,
                a.state as ACTIONLIST_STATE,
                a.action as ACTIONLIST_ACTION,
                a.system_id as ACTIONLIST_SYSTEM_ID  
            FROM
                product_actionlist pal,
                actionlist a   
            WHERE
                pal.entry_id = a.entry_id   
                AND   a.state in (
                    ?, ?, ? 
                )   
                AND   a.action in (
                    ?, ? 
                ) 
        ) sub 
            ON pa.csc_serial_number   = sub.card_serial_number 
            AND pa.csc_issuer_id      = sub.card_issuer_id 
            AND pa.csc_type           = sub.card_type 
            AND pa.app_provider_id    = sub.application_provider_id 
            AND pa.app_serial_number  = sub.application_serial_number 
            AND pa.prod_serial_number = sub.product_serial_number 
    WHERE
        ca.csc_serial_number in (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
        )
Hibernate: 
    /* named native SQL query PurseAccount.FindPurseSummariesWithAutoload */ SELECT
        ca.csc_serial_number          as CSC_SERIAL_NUMBER,
        ca.csc_lifecycle_count        as LIFECYCLE_COUNT,
        NVL(ca.blocked_ind,
        0)        as BLOCKED_IND,
        NVL(pa.csc_serial_number,
        0)  as PROD_CSC_SERIAL_NUMBER,
        NVL(pa.blocked_ind,
        0)        as PROD_BLOCKED_IND,
        NVL(pa.remaining_value,
        0)    as REMAINING_VALUE,
        paf.state                     as AUTOLOAD_STATUS_CODE,
        paf.system_id                 as SYSTEM_ID,
        sub.actionlist_action         as ACTIONLIST_ACTION,
        sub.actionlist_state          as ACTIONLIST_STATE,
        sub.actionlist_system_id      as ACTIONLIST_SYSTEM_ID 
    FROM
        card_account ca 
    LEFT JOIN
        product_account pa 
            ON  ca.csc_serial_number   = pa.csc_serial_number 
            AND ca.csc_type            = pa.csc_type 
            AND ca.csc_issuer_id       = pa.csc_issuer_id 
            AND ca.csc_lifecycle_count = pa.csc_lifecycle_count 
            AND pa.prod_category       = 1 
    LEFT JOIN
        product_autoload_facility paf 
            ON  pa.csc_serial_number   = paf.csc_serial_number 
            AND pa.csc_type            = paf.csc_type 
            AND pa.csc_issuer_id       = paf.csc_issuer_id 
            AND pa.csc_lifecycle_count = paf.csc_lifecycle_count 
            AND pa.app_serial_number   = paf.app_serial_number 
            AND pa.prod_serial_number  = paf.prod_serial_number 
            AND pa.app_provider_id     = paf.app_provider_id 
    LEFT JOIN
        (
            SELECT
                pal.card_serial_number,
                pal.card_issuer_id,
                pal.card_type,
                pal.application_provider_id,
                pal.application_serial_number,
                pal.product_serial_number,
                a.state as ACTIONLIST_STATE,
                a.action as ACTIONLIST_ACTION,
                a.system_id as ACTIONLIST_SYSTEM_ID  
            FROM
                product_actionlist pal,
                actionlist a   
            WHERE
                pal.entry_id = a.entry_id   
                AND   a.state in (
                    ?, ?, ? 
                )   
                AND   a.action in (
                    ?, ? 
                ) 
        ) sub 
            ON pa.csc_serial_number   = sub.card_serial_number 
            AND pa.csc_issuer_id      = sub.card_issuer_id 
            AND pa.csc_type           = sub.card_type 
            AND pa.app_provider_id    = sub.application_provider_id 
            AND pa.app_serial_number  = sub.application_serial_number 
            AND pa.prod_serial_number = sub.product_serial_number 
    WHERE
        ca.csc_serial_number in (
            ?, ?
        )
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_842_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_842_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_842_,
            actionlist0_.ASN as ASN842_,
            actionlist0_.CHANGED as CHANGED842_,
            actionlist0_.LAST_ACTIVITY as LAST6_842_,
            actionlist0_.MASN as MASN842_,
            actionlist0_.state as state842_,
            actionlist0_.type as type842_,
            actionlist0_.action as action842_,
            actionlist0_.SYSTEM_ID as SYSTEM11_842_,
            actionlist0_.reason as reason842_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_884_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_884_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_884_,
            actionlist0_.ASN as ASN884_,
            actionlist0_.CHANGED as CHANGED884_,
            actionlist0_.LAST_ACTIVITY as LAST6_884_,
            actionlist0_.MASN as MASN884_,
            actionlist0_.state as state884_,
            actionlist0_.type as type884_,
            actionlist0_.action as action884_,
            actionlist0_.SYSTEM_ID as SYSTEM11_884_,
            actionlist0_.reason as reason884_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1388_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1388_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1388_,
            actionlist0_.ASN as ASN1388_,
            actionlist0_.CHANGED as CHANGED1388_,
            actionlist0_.LAST_ACTIVITY as LAST6_1388_,
            actionlist0_.MASN as MASN1388_,
            actionlist0_.state as state1388_,
            actionlist0_.type as type1388_,
            actionlist0_.action as action1388_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1388_,
            actionlist0_.reason as reason1388_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1430_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1430_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1430_,
            actionlist0_.ASN as ASN1430_,
            actionlist0_.CHANGED as CHANGED1430_,
            actionlist0_.LAST_ACTIVITY as LAST6_1430_,
            actionlist0_.MASN as MASN1430_,
            actionlist0_.state as state1430_,
            actionlist0_.type as type1430_,
            actionlist0_.action as action1430_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1430_,
            actionlist0_.reason as reason1430_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1472_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1472_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1472_,
            actionlist0_.ASN as ASN1472_,
            actionlist0_.CHANGED as CHANGED1472_,
            actionlist0_.LAST_ACTIVITY as LAST6_1472_,
            actionlist0_.MASN as MASN1472_,
            actionlist0_.state as state1472_,
            actionlist0_.type as type1472_,
            actionlist0_.action as action1472_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1472_,
            actionlist0_.reason as reason1472_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1514_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1514_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1514_,
            actionlist0_.ASN as ASN1514_,
            actionlist0_.CHANGED as CHANGED1514_,
            actionlist0_.LAST_ACTIVITY as LAST6_1514_,
            actionlist0_.MASN as MASN1514_,
            actionlist0_.state as state1514_,
            actionlist0_.type as type1514_,
            actionlist0_.action as action1514_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1514_,
            actionlist0_.reason as reason1514_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1556_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1556_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1556_,
            actionlist0_.ASN as ASN1556_,
            actionlist0_.CHANGED as CHANGED1556_,
            actionlist0_.LAST_ACTIVITY as LAST6_1556_,
            actionlist0_.MASN as MASN1556_,
            actionlist0_.state as state1556_,
            actionlist0_.type as type1556_,
            actionlist0_.action as action1556_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1556_,
            actionlist0_.reason as reason1556_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1598_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1598_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1598_,
            actionlist0_.ASN as ASN1598_,
            actionlist0_.CHANGED as CHANGED1598_,
            actionlist0_.LAST_ACTIVITY as LAST6_1598_,
            actionlist0_.MASN as MASN1598_,
            actionlist0_.state as state1598_,
            actionlist0_.type as type1598_,
            actionlist0_.action as action1598_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1598_,
            actionlist0_.reason as reason1598_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1640_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1640_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1640_,
            actionlist0_.ASN as ASN1640_,
            actionlist0_.CHANGED as CHANGED1640_,
            actionlist0_.LAST_ACTIVITY as LAST6_1640_,
            actionlist0_.MASN as MASN1640_,
            actionlist0_.state as state1640_,
            actionlist0_.type as type1640_,
            actionlist0_.action as action1640_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1640_,
            actionlist0_.reason as reason1640_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1682_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1682_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1682_,
            actionlist0_.ASN as ASN1682_,
            actionlist0_.CHANGED as CHANGED1682_,
            actionlist0_.LAST_ACTIVITY as LAST6_1682_,
            actionlist0_.MASN as MASN1682_,
            actionlist0_.state as state1682_,
            actionlist0_.type as type1682_,
            actionlist0_.action as action1682_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1682_,
            actionlist0_.reason as reason1682_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.CARD_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.CardActionlistEntry
        */ insert 
        into
            CARD_ACTIONLIST
            (CARD_SERIAL_NUMBER, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, END_CARD_SERIAL_NUMBER, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1724_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1724_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1724_,
            actionlist0_.ASN as ASN1724_,
            actionlist0_.CHANGED as CHANGED1724_,
            actionlist0_.LAST_ACTIVITY as LAST6_1724_,
            actionlist0_.MASN as MASN1724_,
            actionlist0_.state as state1724_,
            actionlist0_.type as type1724_,
            actionlist0_.action as action1724_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1724_,
            actionlist0_.reason as reason1724_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.CARD_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.CardActionlistEntry
        */ insert 
        into
            CARD_ACTIONLIST
            (CARD_SERIAL_NUMBER, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, END_CARD_SERIAL_NUMBER, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1766_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1766_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1766_,
            actionlist0_.ASN as ASN1766_,
            actionlist0_.CHANGED as CHANGED1766_,
            actionlist0_.LAST_ACTIVITY as LAST6_1766_,
            actionlist0_.MASN as MASN1766_,
            actionlist0_.state as state1766_,
            actionlist0_.type as type1766_,
            actionlist0_.action as action1766_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1766_,
            actionlist0_.reason as reason1766_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.APPLICATION_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ApplicationActionlistEntry
        */ insert 
        into
            APPLICATION_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_SERIAL_NUMBER, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntry */ update
            ACTIONLIST 
        set
            EXPIRY_DATE=?,
            ACTIVATION_DATE=?,
            ASN=?,
            CHANGED=?,
            LAST_ACTIVITY=?,
            MASN=?,
            state=?,
            type=?,
            action=?,
            SYSTEM_ID=?,
            reason=? 
        where
            ENTRY_ID=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1808_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1808_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1808_,
            actionlist0_.ASN as ASN1808_,
            actionlist0_.CHANGED as CHANGED1808_,
            actionlist0_.LAST_ACTIVITY as LAST6_1808_,
            actionlist0_.MASN as MASN1808_,
            actionlist0_.state as state1808_,
            actionlist0_.type as type1808_,
            actionlist0_.action as action1808_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1808_,
            actionlist0_.reason as reason1808_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.APPLICATION_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ApplicationActionlistEntry
        */ insert 
        into
            APPLICATION_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_SERIAL_NUMBER, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntry */ update
            ACTIONLIST 
        set
            EXPIRY_DATE=?,
            ACTIVATION_DATE=?,
            ASN=?,
            CHANGED=?,
            LAST_ACTIVITY=?,
            MASN=?,
            state=?,
            type=?,
            action=?,
            SYSTEM_ID=?,
            reason=? 
        where
            ENTRY_ID=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1850_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1850_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1850_,
            actionlist0_.ASN as ASN1850_,
            actionlist0_.CHANGED as CHANGED1850_,
            actionlist0_.LAST_ACTIVITY as LAST6_1850_,
            actionlist0_.MASN as MASN1850_,
            actionlist0_.state as state1850_,
            actionlist0_.type as type1850_,
            actionlist0_.action as action1850_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1850_,
            actionlist0_.reason as reason1850_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.APPLICATION_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ApplicationActionlistEntry
        */ insert 
        into
            APPLICATION_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_SERIAL_NUMBER, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntry */ update
            ACTIONLIST 
        set
            EXPIRY_DATE=?,
            ACTIVATION_DATE=?,
            ASN=?,
            CHANGED=?,
            LAST_ACTIVITY=?,
            MASN=?,
            state=?,
            type=?,
            action=?,
            SYSTEM_ID=?,
            reason=? 
        where
            ENTRY_ID=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1892_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1892_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1892_,
            actionlist0_.ASN as ASN1892_,
            actionlist0_.CHANGED as CHANGED1892_,
            actionlist0_.LAST_ACTIVITY as LAST6_1892_,
            actionlist0_.MASN as MASN1892_,
            actionlist0_.state as state1892_,
            actionlist0_.type as type1892_,
            actionlist0_.action as action1892_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1892_,
            actionlist0_.reason as reason1892_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntry */ update
            ACTIONLIST 
        set
            EXPIRY_DATE=?,
            ACTIVATION_DATE=?,
            ASN=?,
            CHANGED=?,
            LAST_ACTIVITY=?,
            MASN=?,
            state=?,
            type=?,
            action=?,
            SYSTEM_ID=?,
            reason=? 
        where
            ENTRY_ID=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1934_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1934_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1934_,
            actionlist0_.ASN as ASN1934_,
            actionlist0_.CHANGED as CHANGED1934_,
            actionlist0_.LAST_ACTIVITY as LAST6_1934_,
            actionlist0_.MASN as MASN1934_,
            actionlist0_.state as state1934_,
            actionlist0_.type as type1934_,
            actionlist0_.action as action1934_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1934_,
            actionlist0_.reason as reason1934_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntry */ update
            ACTIONLIST 
        set
            EXPIRY_DATE=?,
            ACTIVATION_DATE=?,
            ASN=?,
            CHANGED=?,
            LAST_ACTIVITY=?,
            MASN=?,
            state=?,
            type=?,
            action=?,
            SYSTEM_ID=?,
            reason=? 
        where
            ENTRY_ID=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_1976_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_1976_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_1976_,
            actionlist0_.ASN as ASN1976_,
            actionlist0_.CHANGED as CHANGED1976_,
            actionlist0_.LAST_ACTIVITY as LAST6_1976_,
            actionlist0_.MASN as MASN1976_,
            actionlist0_.state as state1976_,
            actionlist0_.type as type1976_,
            actionlist0_.action as action1976_,
            actionlist0_.SYSTEM_ID as SYSTEM11_1976_,
            actionlist0_.reason as reason1976_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_2018_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_2018_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_2018_,
            actionlist0_.ASN as ASN2018_,
            actionlist0_.CHANGED as CHANGED2018_,
            actionlist0_.LAST_ACTIVITY as LAST6_2018_,
            actionlist0_.MASN as MASN2018_,
            actionlist0_.state as state2018_,
            actionlist0_.type as type2018_,
            actionlist0_.action as action2018_,
            actionlist0_.SYSTEM_ID as SYSTEM11_2018_,
            actionlist0_.reason as reason2018_ 
        from
            ACTIONLIST actionlist0_
Hibernate: 
    call next value for ACTIONLIST.WORK_ORDER_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.PRODUCT_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.ENTRY_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.DETAIL_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    call next value for ACTIONLIST.WORK_ITEM_ID_SEQ
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkOrder
        */ insert 
        into
            WORK_ORDER
            (ORDER_DATE, ORDER_DETAILS, action, status, SYSTEM_ID, ORDER_ID) 
        values
            (?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntry
        */ insert 
        into
            ACTIONLIST
            (EXPIRY_DATE, ACTIVATION_DATE, ASN, CHANGED, LAST_ACTIVITY, MASN, state, type, action, SYSTEM_ID, reason, ENTRY_ID) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty
        */ insert 
        into
            ACTIONLIST_DETAIL
            (ENTRY_ID, value, attribute, id) 
        values
            (?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.ProductActionlistEntry
        */ insert 
        into
            PRODUCT_ACTIONLIST
            (CARD_SERIAL_NUMBER, PRODUCT_TYPE, PRODUCT_SERIAL_NUMBER, PRODUCT_ISSUER_ID, CARD_ISSUER_ID, CARD_LCC, CARD_TYPE, APPLICATION_PROVIDER_ID, APPLICATION_SERIAL_NUMBER, APPLICATION_TYPE, ENTRY_ID, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.erggroup.mass.ejb3.actionlist.WorkItem
        */ insert 
        into
            WORK_ITEM
            (CARD_SERIAL_NUMBER, FK_WORK_ORDER_ID, PRODUCT_SERIAL_NUMBER, FK_ACTIONLIST, FK_CARD_ACTIONLIST, FK_APPLICATION_ACTIONLIST, FK_PRODUCT_ACTIONLIST, EXPORTED_STATUS, EXPORTED_DATE, EXPORTED_AL_STATUS, STATUS, id) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* update
        com.erggroup.mass.ejb3.actionlist.ActionlistEntryProperty */ update
            ACTIONLIST_DETAIL 
        set
            ENTRY_ID=?,
            value=?,
            attribute=? 
        where
            id=?
Hibernate: 
    /* Select
        a 
    from
        ActionlistEntry a */ select
            actionlist0_.ENTRY_ID as ENTRY1_2060_,
            actionlist0_.EXPIRY_DATE as EXPIRY2_2060_,
            actionlist0_.ACTIVATION_DATE as ACTIVATION3_2060_,
            actionlist0_.ASN as ASN2060_,
            actionlist0_.CHANGED as CHANGED2060_,
            actionlist0_.LAST_ACTIVITY as LAST6_2060_,
            actionlist0_.MASN as MASN2060_,
            actionlist0_.state as state2060_,
            actionlist0_.type as type2060_,
            actionlist0_.action as action2060_,
            actionlist0_.SYSTEM_ID as SYSTEM11_2060_,
            actionlist0_.reason as reason2060_ 
        from
            ACTIONLIST actionlist0_
]]></system-out>
  <system-err><![CDATA[Creating a new EntityManagerFactory ---------------------------------------------------- 
log4j:WARN No appenders could be found for logger (org.hibernate.ejb.Version).
log4j:WARN Please initialize the log4j system properly.
Record: CSC: 10007 Date: 2012-09-26 00:00:00.0

Record: CSC: 10007 Date: 2012-09-25 00:00:00.0

Record: CSC: 10007 Date: 2012-09-24 00:00:00.0

Record: CSC: 10007 Date: 2012-09-23 00:00:00.0

Record: CSC: 10007 Date: 2012-09-22 00:00:00.0

Record: CSC: 10008 Date: 2013-09-25 00:00:00.0

Record: CSC: 10008 Date: 2013-09-24 00:00:00.0

Record: CSC: 10008 Date: 2013-09-23 00:00:00.0

Record: CSC: 10008 Date: 2013-09-22 00:00:00.0

Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
C:\ClearCase\UtfIntegration\build\test-------------------------------------------------------------------
Creating a new EntityManagerFactory ---------------------------------------------------- 
C:\ClearCase\UtfIntegration\build\test-------------------------------------------------------------------
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Category: Test cat 1:1 -> 3 ========================== 
Category: Test cat 2:2 -> 5 ========================== 
Category: AA:52 -> 6 ========================== 
Category: A:8 -> 7 ========================== 
Creating a new EntityManagerFactory ---------------------------------------------------- 
10000
10001
10002
10003
10004
10005
10006
10007
10008
10009
10010
10011
10012
10013
10014
10015
10016
10017
Creating a new EntityManagerFactory ---------------------------------------------------- 
10000
10001
10002
10003
10004
10005
10006
10007
10008
10009
10010
10011
10012
10013
10014
10015
10016
10017
Creating a new EntityManagerFactory ---------------------------------------------------- 
10017
10018
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
Creating a new EntityManagerFactory ---------------------------------------------------- 
]]></system-err>
</testsuite>