Forum Stats

  • 3,839,086 Users
  • 2,262,449 Discussions
  • 7,900,848 Comments

Discussions

Problem in Fetching Records from XML

Khawerr
Khawerr Member Posts: 21
edited Dec 24, 2019 8:53AM in SQL & PL/SQL

Hi,

This is my xml.

<LgfData>

   <Header>

      <DocumentVersion>9.0.1</DocumentVersion>

      <OriginSystem>LogFire</OriginSystem>

      <ClientEnvCode>radius</ClientEnvCode>

      <ParentCompanyCode>RADIUS</ParentCompanyCode>

      <Entity>shipment_verification</Entity>

      <TimeStamp>2019-12-11T13:41:44</TimeStamp>

      <MessageId>SVSHG0000000783</MessageId>

   </Header>

   <ListOfVerifiedIbShipments>

      <ib_shipment>

         <ib_shipment_hdr>

            <shipment_nbr>IS00000002</shipment_nbr>

            <shipped_date>2019-07-21</shipped_date>

         </ib_shipment_hdr>

         <ib_shipment_dtl>

            <seq_nbr>1</seq_nbr>

            <lpn_nbr>IE00000003</lpn_nbr>

            <item_alternate_code>99999999</item_alternate_code>

            <received_qty>5</received_qty>

            <expiry_date>2020-12-31</expiry_date>

            <batch_nbr>BATCH01</batch_nbr>

         <ib_shipment_dtl>

            <seq_nbr>2</seq_nbr>

            <lpn_nbr>IE00000002</lpn_nbr>

            <item_alternate_code>99999999</item_alternate_code>

            <received_qty>5</received_qty>

            <expiry_date>2020-12-31</expiry_date>

            <batch_nbr>BATCH01</batch_nbr>

         </ib_shipment_dtl>

      </ib_shipment>

   </ListOfVerifiedIbShipments>

</LgfData>

I want to write SQL to display values like..

shipment_nbrshipped_datelpn_nbritem_alternate_codereceived_qtyexpiry_datebatch_nbr
IS000000022019-07-21IE000000039999999952020-12-31BATCH01
IS000000022019-07-21IE000000029999999952020-12-31BATCH01

Help needed.

Thanks

Regards,

Khawer

Tagged:
Khawerr

Best Answer

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,608 Red Diamond
    edited Dec 16, 2019 10:43AM Answer ✓

    with sample_data as (

                         select  xmltype(

                                         to_clob('<LgfData>

       <Header>

          <DocumentVersion>9.0.1</DocumentVersion>

          <OriginSystem>LogFire</OriginSystem>

          <ClientEnvCode>radius</ClientEnvCode>

          <ParentCompanyCode>RADIUS</ParentCompanyCode>

          <Entity>shipment_verification</Entity>

          <TimeStamp>2019-12-11T13:41:44</TimeStamp>

          <MessageId>SVSHG0000000783</MessageId>

       </Header>

       <ListOfVerifiedIbShipments>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000002</shipment_nbr>

                <facility_code>STAR</facility_code>

                <company_code>ECC</company_code>

                <trailer_nbr>CONTAINER01</trailer_nbr>

                <ref_nbr>Invoice01</ref_nbr>

                <shipment_type>CONSIGNMENTS</shipment_type>

                <load_nbr>LIS00000002</load_nbr>

                <manifest_nbr>Packing List 01</manifest_nbr>

                <trailer_type />

                <vendor_info>Customer Name 01</vendor_info>

                <origin_info>Customer Rep01</origin_info>

                <origin_code />

                <orig_shipped_units>10</orig_shipped_units>

                <shipped_date>2019-07-21</shipped_date>

                <orig_shipped_lpns>2</orig_shipped_lpns>

                <shipment_hdr_cust_field_1>Carrier Name 01</shipment_hdr_cust_field_1>

                <shipment_hdr_cust_field_2>Vehicle Temprature</shipment_hdr_cust_field_2>

                <shipment_hdr_cust_field_3>PEST Status01</shipment_hdr_cust_field_3>

                <shipment_hdr_cust_field_4 />

                <shipment_hdr_cust_field_5 />

                <verification_date>2019-12-11</verification_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000003</lpn_nbr>

                <lpn_weight>54</lpn_weight>

                <lpn_volume>5</lpn_volume>

                <item_alternate_code>99999999</item_alternate_code>

                <item_part_a>99999999</item_part_a>

                <item_part_b />

                <item_part_c />

                <item_part_d />

                <item_part_e />

                <item_part_f />

                <pre_pack_code />

                <pre_pack_ratio>0</pre_pack_ratio>

                <pre_pack_ratio_seq>0</pre_pack_ratio_seq>

                <pre_pack_total_units>0</pre_pack_total_units>

                <invn_attr_a />

                <invn_attr_b />

                <invn_attr_c />

                <shipped_qty>5</shipped_qty>

                <priority_date />

                <po_nbr />

                <pallet_nbr />

                <putaway_type>Frozen</putaway_type>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

                <rcv_xdock_facility_code />

                <shipment_dtl_cust_field_1>Product Temperature</shipment_dtl_cust_field_1>

                <shipment_dtl_cust_field_2>Product Condition</shipment_dtl_cust_field_2>

                <shipment_dtl_cust_field_3 />

                <shipment_dtl_cust_field_4 />

                <shipment_dtl_cust_field_5 />

                <lpn_is_physical_pallet_flg />

                <po_seq_nbr />

                <lock_code />

                <serial_nbr />

                <invn_attr_d />

                <invn_attr_e />

                <invn_attr_f />

                <invn_attr_g />

             </ib_shipment_dtl>') ||

             to_clob('<ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000002</lpn_nbr>

                <lpn_weight>54</lpn_weight>

                <lpn_volume>5</lpn_volume>

                <item_alternate_code>99999999</item_alternate_code>

                <item_part_a>99999999</item_part_a>

                <item_part_b />

                <item_part_c />

                <item_part_d />

                <item_part_e />

                <item_part_f />

                <pre_pack_code />

                <pre_pack_ratio>0</pre_pack_ratio>

                <pre_pack_ratio_seq>0</pre_pack_ratio_seq>

                <pre_pack_total_units>0</pre_pack_total_units>

                <invn_attr_a />

                <invn_attr_b />

                <invn_attr_c />

                <shipped_qty>5</shipped_qty>

                <priority_date />

                <po_nbr />

                <pallet_nbr />

                <putaway_type>Frozen</putaway_type>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

                <rcv_xdock_facility_code />

                <shipment_dtl_cust_field_1>Product Temperature</shipment_dtl_cust_field_1>

                <shipment_dtl_cust_field_2>Product Condition</shipment_dtl_cust_field_2>

                <shipment_dtl_cust_field_3 />

                <shipment_dtl_cust_field_4 />

                <shipment_dtl_cust_field_5 />

                <lpn_is_physical_pallet_flg />

                <po_seq_nbr />

                <lock_code />

                <serial_nbr />

                <invn_attr_d />

                <invn_attr_e />

                <invn_attr_f />

                <invn_attr_g />

             </ib_shipment_dtl>

          </ib_shipment>

       </ListOfVerifiedIbShipments>

    </LgfData>')) xml_doc from dual

              )

    select  shipment_nbr,

            shipped_date,

            lpn_nbr,

            item_alternate_code,

            received_qty,

            expiry_date,

            batch_nbr

      from  sample_data,

            xmltable(

                     '/LgfData/ListOfVerifiedIbShipments'

                     passing xml_doc

                     columns

                       shipment_nbr varchar2(15) path 'ib_shipment/ib_shipment_hdr/shipment_nbr',

                       shipped_date date path 'ib_shipment/ib_shipment_hdr/shipped_date',

                       ib_shipment_dtl xmltype path 'ib_shipment/ib_shipment_dtl'

                    ) x,

            xmltable(

                     '/ib_shipment_dtl'

                     passing ib_shipment_dtl

                     columns

                       lpn_nbr varchar2(15) path 'lpn_nbr',

                       item_alternate_code number path 'item_alternate_code',

                       received_qty number path 'received_qty',

                       expiry_date date path 'expiry_date',

                       batch_nbr varchar2(15) path 'batch_nbr'

                    )

    /

    SHIPMENT_NBR    SHIPPED_D LPN_NBR         ITEM_ALTERNATE_CODE RECEIVED_QTY EXPIRY_DA BATCH_NBR

    --------------- --------- --------------- ------------------- ------------ --------- ---------------

    IS00000002      21-JUL-19 IE00000003                 99999999            5 31-DEC-20 BATCH01

    IS00000002      21-JUL-19 IE00000002                 99999999            5 31-DEC-20 BATCH01

    SQL>

    SY.

    Khawerr

Answers

  • mNem
    mNem Member Posts: 1,380 Gold Trophy
    edited Dec 16, 2019 10:28AM

    it may help if you could modify your xml sample data to have varying values for each expected row. Also, please remove the empty nodes that do not have any importance to your problem for testing purposes.

    Khawerr
  • Khawerr
    Khawerr Member Posts: 21
    edited Dec 16, 2019 10:38AM

    ok. I have edited the Post now.

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,608 Red Diamond
    edited Dec 16, 2019 10:43AM Answer ✓

    with sample_data as (

                         select  xmltype(

                                         to_clob('<LgfData>

       <Header>

          <DocumentVersion>9.0.1</DocumentVersion>

          <OriginSystem>LogFire</OriginSystem>

          <ClientEnvCode>radius</ClientEnvCode>

          <ParentCompanyCode>RADIUS</ParentCompanyCode>

          <Entity>shipment_verification</Entity>

          <TimeStamp>2019-12-11T13:41:44</TimeStamp>

          <MessageId>SVSHG0000000783</MessageId>

       </Header>

       <ListOfVerifiedIbShipments>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000002</shipment_nbr>

                <facility_code>STAR</facility_code>

                <company_code>ECC</company_code>

                <trailer_nbr>CONTAINER01</trailer_nbr>

                <ref_nbr>Invoice01</ref_nbr>

                <shipment_type>CONSIGNMENTS</shipment_type>

                <load_nbr>LIS00000002</load_nbr>

                <manifest_nbr>Packing List 01</manifest_nbr>

                <trailer_type />

                <vendor_info>Customer Name 01</vendor_info>

                <origin_info>Customer Rep01</origin_info>

                <origin_code />

                <orig_shipped_units>10</orig_shipped_units>

                <shipped_date>2019-07-21</shipped_date>

                <orig_shipped_lpns>2</orig_shipped_lpns>

                <shipment_hdr_cust_field_1>Carrier Name 01</shipment_hdr_cust_field_1>

                <shipment_hdr_cust_field_2>Vehicle Temprature</shipment_hdr_cust_field_2>

                <shipment_hdr_cust_field_3>PEST Status01</shipment_hdr_cust_field_3>

                <shipment_hdr_cust_field_4 />

                <shipment_hdr_cust_field_5 />

                <verification_date>2019-12-11</verification_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000003</lpn_nbr>

                <lpn_weight>54</lpn_weight>

                <lpn_volume>5</lpn_volume>

                <item_alternate_code>99999999</item_alternate_code>

                <item_part_a>99999999</item_part_a>

                <item_part_b />

                <item_part_c />

                <item_part_d />

                <item_part_e />

                <item_part_f />

                <pre_pack_code />

                <pre_pack_ratio>0</pre_pack_ratio>

                <pre_pack_ratio_seq>0</pre_pack_ratio_seq>

                <pre_pack_total_units>0</pre_pack_total_units>

                <invn_attr_a />

                <invn_attr_b />

                <invn_attr_c />

                <shipped_qty>5</shipped_qty>

                <priority_date />

                <po_nbr />

                <pallet_nbr />

                <putaway_type>Frozen</putaway_type>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

                <rcv_xdock_facility_code />

                <shipment_dtl_cust_field_1>Product Temperature</shipment_dtl_cust_field_1>

                <shipment_dtl_cust_field_2>Product Condition</shipment_dtl_cust_field_2>

                <shipment_dtl_cust_field_3 />

                <shipment_dtl_cust_field_4 />

                <shipment_dtl_cust_field_5 />

                <lpn_is_physical_pallet_flg />

                <po_seq_nbr />

                <lock_code />

                <serial_nbr />

                <invn_attr_d />

                <invn_attr_e />

                <invn_attr_f />

                <invn_attr_g />

             </ib_shipment_dtl>') ||

             to_clob('<ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000002</lpn_nbr>

                <lpn_weight>54</lpn_weight>

                <lpn_volume>5</lpn_volume>

                <item_alternate_code>99999999</item_alternate_code>

                <item_part_a>99999999</item_part_a>

                <item_part_b />

                <item_part_c />

                <item_part_d />

                <item_part_e />

                <item_part_f />

                <pre_pack_code />

                <pre_pack_ratio>0</pre_pack_ratio>

                <pre_pack_ratio_seq>0</pre_pack_ratio_seq>

                <pre_pack_total_units>0</pre_pack_total_units>

                <invn_attr_a />

                <invn_attr_b />

                <invn_attr_c />

                <shipped_qty>5</shipped_qty>

                <priority_date />

                <po_nbr />

                <pallet_nbr />

                <putaway_type>Frozen</putaway_type>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

                <rcv_xdock_facility_code />

                <shipment_dtl_cust_field_1>Product Temperature</shipment_dtl_cust_field_1>

                <shipment_dtl_cust_field_2>Product Condition</shipment_dtl_cust_field_2>

                <shipment_dtl_cust_field_3 />

                <shipment_dtl_cust_field_4 />

                <shipment_dtl_cust_field_5 />

                <lpn_is_physical_pallet_flg />

                <po_seq_nbr />

                <lock_code />

                <serial_nbr />

                <invn_attr_d />

                <invn_attr_e />

                <invn_attr_f />

                <invn_attr_g />

             </ib_shipment_dtl>

          </ib_shipment>

       </ListOfVerifiedIbShipments>

    </LgfData>')) xml_doc from dual

              )

    select  shipment_nbr,

            shipped_date,

            lpn_nbr,

            item_alternate_code,

            received_qty,

            expiry_date,

            batch_nbr

      from  sample_data,

            xmltable(

                     '/LgfData/ListOfVerifiedIbShipments'

                     passing xml_doc

                     columns

                       shipment_nbr varchar2(15) path 'ib_shipment/ib_shipment_hdr/shipment_nbr',

                       shipped_date date path 'ib_shipment/ib_shipment_hdr/shipped_date',

                       ib_shipment_dtl xmltype path 'ib_shipment/ib_shipment_dtl'

                    ) x,

            xmltable(

                     '/ib_shipment_dtl'

                     passing ib_shipment_dtl

                     columns

                       lpn_nbr varchar2(15) path 'lpn_nbr',

                       item_alternate_code number path 'item_alternate_code',

                       received_qty number path 'received_qty',

                       expiry_date date path 'expiry_date',

                       batch_nbr varchar2(15) path 'batch_nbr'

                    )

    /

    SHIPMENT_NBR    SHIPPED_D LPN_NBR         ITEM_ALTERNATE_CODE RECEIVED_QTY EXPIRY_DA BATCH_NBR

    --------------- --------- --------------- ------------------- ------------ --------- ---------------

    IS00000002      21-JUL-19 IE00000003                 99999999            5 31-DEC-20 BATCH01

    IS00000002      21-JUL-19 IE00000002                 99999999            5 31-DEC-20 BATCH01

    SQL>

    SY.

    Khawerr
  • Khawerr
    Khawerr Member Posts: 21
    edited Dec 16, 2019 11:04AM

    Thanks a lot bro.

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 19,608 Red Diamond
    edited Dec 16, 2019 11:21AM

    Actually, I gave you wrong solution which will not work for multiple shipments:

    with sample_data as (

                         select  xmltype(

                                         '<LgfData>

       <Header>

          <DocumentVersion>9.0.1</DocumentVersion>

          <OriginSystem>LogFire</OriginSystem>

          <ClientEnvCode>radius</ClientEnvCode>

          <ParentCompanyCode>RADIUS</ParentCompanyCode>

          <Entity>shipment_verification</Entity>

          <TimeStamp>2019-12-11T13:41:44</TimeStamp>

          <MessageId>SVSHG0000000783</MessageId>

       </Header>

       <ListOfVerifiedIbShipments>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000002</shipment_nbr>

                <shipped_date>2019-07-21</shipped_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000003</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

             <ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000002</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

          </ib_shipment>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000008</shipment_nbr>

                <shipped_date>2018-07-21</shipped_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000007</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

             <ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000005</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

          </ib_shipment>

       </ListOfVerifiedIbShipments>

    </LgfData>') xml_doc from dual

              )

    select  shipment_nbr,

            shipped_date,

            lpn_nbr,

            item_alternate_code,

            received_qty,

            expiry_date,

            batch_nbr

      from  sample_data,

            xmltable(

                     '/LgfData/ListOfVerifiedIbShipments'

                     passing xml_doc

                     columns

                       shipment_nbr varchar2(15) path 'ib_shipment/ib_shipment_hdr/shipment_nbr',

                       shipped_date date path 'ib_shipment/ib_shipment_hdr/shipped_date',

                       ib_shipment_dtl xmltype path 'ib_shipment/ib_shipment_dtl'

                    ) x,

            xmltable(

                     '/ib_shipment_dtl'

                     passing ib_shipment_dtl

                     columns

                       lpn_nbr varchar2(15) path 'lpn_nbr',

                       item_alternate_code number path 'item_alternate_code',

                       received_qty number path 'received_qty',

                       expiry_date date path 'expiry_date',

                       batch_nbr varchar2(15) path 'batch_nbr'

                    )

    /

          <ib_shipment>

              *

    ERROR at line 14:

    ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

    SQL>

    It should be:

    with sample_data as (

                         select  xmltype(

                                         '<LgfData>

       <Header>

          <DocumentVersion>9.0.1</DocumentVersion>

          <OriginSystem>LogFire</OriginSystem>

          <ClientEnvCode>radius</ClientEnvCode>

          <ParentCompanyCode>RADIUS</ParentCompanyCode>

          <Entity>shipment_verification</Entity>

          <TimeStamp>2019-12-11T13:41:44</TimeStamp>

          <MessageId>SVSHG0000000783</MessageId>

       </Header>

       <ListOfVerifiedIbShipments>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000002</shipment_nbr>

                <shipped_date>2019-07-21</shipped_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000003</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

             <ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000002</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

          </ib_shipment>

          <ib_shipment>

             <ib_shipment_hdr>

                <shipment_nbr>IS00000008</shipment_nbr>

                <shipped_date>2018-07-21</shipped_date>

             </ib_shipment_hdr>

             <ib_shipment_dtl>

                <seq_nbr>1</seq_nbr>

                <lpn_nbr>IE00000007</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

             <ib_shipment_dtl>

                <seq_nbr>2</seq_nbr>

                <lpn_nbr>IE00000005</lpn_nbr>

                <item_alternate_code>99999999</item_alternate_code>

                <received_qty>5</received_qty>

                <expiry_date>2020-12-31</expiry_date>

                <batch_nbr>BATCH01</batch_nbr>

             </ib_shipment_dtl>

          </ib_shipment>

       </ListOfVerifiedIbShipments>

    </LgfData>') xml_doc from dual

              )

    select  shipment_nbr,

            shipped_date,

            lpn_nbr,

            item_alternate_code,

            received_qty,

            expiry_date,

            batch_nbr

      from  sample_data,

            xmltable(

                     '/LgfData/ListOfVerifiedIbShipments/ib_shipment'

                     passing xml_doc

                     columns

                       shipment_nbr varchar2(15) path 'ib_shipment_hdr/shipment_nbr',

                       shipped_date date path 'ib_shipment_hdr/shipped_date',

                       ib_shipment_dtl xmltype path 'ib_shipment_dtl'

                    ) x,

            xmltable(

                     '/ib_shipment_dtl'

                     passing ib_shipment_dtl

                     columns

                       lpn_nbr varchar2(15) path 'lpn_nbr',

                       item_alternate_code number path 'item_alternate_code',

                       received_qty number path 'received_qty',

                       expiry_date date path 'expiry_date',

                       batch_nbr varchar2(15) path 'batch_nbr'

                    )

    /

    SHIPMENT_NBR    SHIPPED_D LPN_NBR         ITEM_ALTERNATE_CODE RECEIVED_QTY EXPIRY_DA BATCH_NBR

    --------------- --------- --------------- ------------------- ------------ --------- ---------------

    IS00000002      21-JUL-19 IE00000003                 99999999            5 31-DEC-20 BATCH01

    IS00000002      21-JUL-19 IE00000002                 99999999            5 31-DEC-20 BATCH01

    IS00000008      21-JUL-18 IE00000007                 99999999            5 31-DEC-20 BATCH01

    IS00000008      21-JUL-18 IE00000005                 99999999            5 31-DEC-20 BATCH01

    SQL>

    SY.

    Khawerr
  • Khawerr
    Khawerr Member Posts: 21
    edited Dec 24, 2019 8:53AM

    Thanks, But in my case xml will always contain single shipment with multiple item