<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
    Microsoft ResX Schema 
    
    Version 2.0
    
    The primary goals of this format is to allow a simple XML format 
    that is mostly human readable. The generation and parsing of the 
    various data types are done through the TypeConverter classes 
    associated with the data types.
    
    Example:
    
    ... ado.net/XML headers & schema ...
    <resheader name="resmimetype">text/microsoft-resx</resheader>
    <resheader name="version">2.0</resheader>
    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
        <value>[base64 mime encoded serialized .NET Framework object]</value>
    </data>
    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
        <comment>This is a comment</comment>
    </data>
                
    There are any number of "resheader" rows that contain simple 
    name/value pairs.
    
    Each data row contains a name, and value. The row also contains a 
    type or mimetype. Type corresponds to a .NET class that support 
    text/value conversion through the TypeConverter architecture. 
    Classes that don't support this are serialized and stored with the 
    mimetype set.
    
    The mimetype is used for serialized objects, and tells the 
    ResXResourceReader how to depersist the object. This is currently not 
    extensible. For a given mimetype the value must be set accordingly:
    
    Note - application/x-microsoft.net.object.binary.base64 is the format 
    that the ResXResourceWriter will generate, however the reader can 
    read any of the formats listed below.
    
    mimetype: application/x-microsoft.net.object.binary.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
            : and then encoded with base64 encoding.
    
    mimetype: application/x-microsoft.net.object.soap.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64
    value   : The object must be serialized into a byte array 
            : using a System.ComponentModel.TypeConverter
            : and then encoded with base64 encoding.
    -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="metadata">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" />
              </xsd:sequence>
              <xsd:attribute name="name" use="required" type="xsd:string" />
              <xsd:attribute name="type" type="xsd:string" />
              <xsd:attribute name="mimetype" type="xsd:string" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="assembly">
            <xsd:complexType>
              <xsd:attribute name="alias" type="xsd:string" />
              <xsd:attribute name="name" type="xsd:string" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <data name="case1" xml:space="preserve">
    <value>SELECT *
FROM   emp, salary
WHERE  emp.emp_id = salary.emp_id
AND    emp.dept_no IN (SELECT dept_no
                       FROM   dept
                       WHERE  dept.location = 'SEOUL'
                       )
AND    emp.emp_id NOT IN (SELECT emp_id
                          FROM   emp_retirement c
                          WHERE  c.retire_type = 'NORMAL'
                          );</value>
  </data>
  <data name="case10" xml:space="preserve">
    <value>SELECT sum(salary)
FROM   emp, salary, dept
WHERE  emp.emp_id  = salary.emp_id 
AND    emp.dept_no = dept.dept_no
AND    dept.location = 'SEOUL' ;</value>
  </data>
  <data name="case11" xml:space="preserve">
    <value>SELECT sum(salary)
FROM   emp, salary, dept
WHERE  emp.emp_id  = salary.emp_id 
AND    emp.dept_no = dept.dept_no
AND    dept.location = 'SEOUL' ;</value>
  </data>
  <data name="case12" xml:space="preserve">
    <value>SELECT sum(salary)
FROM   emp, salary, dept
WHERE  emp.emp_id  = salary.emp_id 
AND    emp.dept_no = dept.dept_no
AND    dept.location = 'SEOUL' 
AND    salary.yyyymmdd = (SELECT MAX(yyyymmdd)
                          FROM   salary s2
                          WHERE  s2.emp_id = salary.emp_id );</value>
  </data>
  <data name="case2" xml:space="preserve">
    <value>SELECT tax_line_id
  FROM zx_lines zl
 WHERE application_id = :B3
   AND entity_code = :B2
   AND event_class_code = :B1
   AND (process_for_recovery_flag = 'Y'
         OR item_dist_changed_flag = 'Y')
   AND EXISTS (SELECT 1
                 FROM zx_lines_det_factors
                WHERE application_id = zl.application_id
                  AND entity_code = zl.entity_code
                  AND event_class_code = zl.event_class_code
                  AND trx_id = zl.trx_id
                  AND trx_line_id = zl.trx_line_id
                  AND trx_level_type = zl.trx_level_type
                  AND event_id = :B4);</value>
  </data>
  <data name="case3" xml:space="preserve">
    <value>SELECT a.emp_id, a.emp_name,
       b.salary_amt
FROM   emp a, 
      (SELECT emp_id, SUM(salary) salary_amt
       FROM   salary a, dept b  -- two tables joined
       WHERE  a.dept_id = b.dept_id
       AND    b.location = 'US'
       GROUP  BY emp_id
       ) b
WHERE  emp.date_entered &gt;= to_date('20080101','yyyymmdd')
AND    a.emp_id          = b.emp_id (+);</value>
  </data>
  <data name="case4" xml:space="preserve">
    <value>SELECT *
FROM   fnd_concurrent_requests
WHERE  status IN ('R','E')
AND    request_date &gt;= SYSDATE - 1 ;</value>
  </data>
  <data name="case5" xml:space="preserve">
    <value>SELECT *
FROM   fnd_concurrent_requests
WHERE  ( status = 'R' OR status = 'E' )
AND    request_date &gt;= SYSDATE - 1 ;</value>
  </data>
  <data name="case6" xml:space="preserve">
    <value>SELECT *
FROM   fnd_concurrent_requests
WHERE  NVL(request_date, closed_date) = :b1
AND    status = 'E' ;</value>
  </data>
  <data name="case7" xml:space="preserve">
    <value>SELECT *
FROM   fnd_concurrent_requests
WHERE  TO_CHAR(request_date, 'YYYYMMDD') = '20080520' 
AND    status_code = 'E'
AND    phase_code  = 'C' ;</value>
  </data>
  <data name="case8" xml:space="preserve">
    <value>SELECT COUNT(odp.pallet_id) pallet_qty,
       COUNT(odp.box_id) box_qty,
       SUM(packing_nw) sum_packing_nw,
       SUM(packing_gw) sum_packing_gw,
       SUM(pallet_qty) sum_packing_qty
  FROM xxopsm_delivery_headers odh,
       xxopsm_delivery_pack_v odp
 WHERE odh.organization_id = :1
   AND odh.organization_id = odp.organization_id
   AND odh.plan_batch_id = odp.plan_batch_id
   AND odh.delivery_id = :1
;</value>
  </data>
  <data name="case9" xml:space="preserve">
    <value>SELECT sum(salary)
FROM   emp, salary
WHERE  emp.emp_id = salary.emp_id
AND    NOT EXISTS (SELECT 1
                   FROM   dept
                   WHERE  dept.location = 'SEOUL'
                   AND    emp.dept_no   = dept.dept_no
                   ) ;</value>
  </data>
</root>