Link to home
Start Free TrialLog in
Avatar of maximus1974
maximus1974

asked on

How to update a table from another in between specific values

Need to update a table named QQM_OUTBOX which contains XML code within a column named payload. Need to replace the NA in between <SM_NUMBER>NA</SM_NUMBER> with the SM_NO from VIEW_RC_SHIPMENT_NO.

Both tables are joined by the VIEW_RC_SHIPMENT_NO.GUI and the QQM_OUTBOX.PAYLOAD( <QQM_MSG_GUID>7394175</QQM_MSG_GUID>) columns. It needs to join to the value in between QQM_MSG_GUID>7394175</QQM_MSG_GUID where QQM_OUTBOX.MSG_TYPE = 'WO_RECEIVED'
.
Will this be possible?
User generated image
User generated image
Avatar of Sean Stuber
Sean Stuber

please post text, not images.  We can't use images as sample data.
what are the columns and types of each table?  Can you provide ddl for us to work from?

Avatar of maximus1974

ASKER

Sorry I named the first file incorrectly. The correct name is QQM_OUTBOX. The sample data is correct
do you have the table ddl? or at least a description of the columns?

at the very minimum, is payload xmltype, varchar2, clob?
The help is much appreciated Sean.

I'm not sure how to read your sample data for the table.

you have empty strings, double-quoted strings, non-quoted strings
most of your lines end without a comma, some do have them though.

Since we don't really need all of the data for this question, I'll pick out the relevant pieces and post them for all to share and then work on the answer.
Does this help?
qqm_outbox.xls
Here's my test bed based on the files.  I don't think this will work though

CREATE TABLE "QQM_OUTBOX" 
   (    "QMO_AUTO_KEY" NUMBER, 
    "MSG_TYPE" VARCHAR2(50 BYTE), 
    "PAYLOAD" CLOB DEFAULT empty_clob(), 
    "CMP_TO" NUMBER, 
    "AMAZON_BUCKET" VARCHAR2(256 BYTE), 
    "STATUS" VARCHAR2(50 BYTE), 
    "ENTRY_DATE" DATE, 
    "SYSUR_AUTO_KEY" NUMBER, 
    "QQM_SENDER_ID" VARCHAR2(10 BYTE), 
    "ERROR_DESCR" VARCHAR2(256 BYTE), 
    "RO_NUMBER" VARCHAR2(80 BYTE), 
    "SI_NUMBER" VARCHAR2(80 BYTE), 
    "WQH_NUMBER" VARCHAR2(80 BYTE), 
    "INTEGRATION_TYPE" VARCHAR2(20 BYTE) DEFAULT 'QQM', 
    "QQM_RECEIVER_ID" VARCHAR2(10 BYTE)
   );

insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7394175</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094866</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3055982</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094867</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2758140</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094877</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4932595</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094879</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3507042</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094880</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1110952</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047591</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F0260342299970</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6331850</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094891</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3753031</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094895</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9709745</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031168</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9292731</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094896</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7106447</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095179</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5157301</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095787</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7864998</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094959</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7402470</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094962</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3515248</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095793</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2091826</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047781</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>913850199536</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6991406</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095672</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2337718</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031357</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1469138</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094978</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7967869</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094984</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7385559</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095008</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3848311</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095058</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4844973</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095011</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1486612</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031264</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9954990</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095595</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6254467</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095652</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SW2414590-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6343207</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095664</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8615555</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095674</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>3371210-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>193858</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095675</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4524270</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095682</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5876125</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095683</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1247510</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095684</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8670691</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095687</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9738067</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095692</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9133425</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095694</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9326539</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048109</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7578315</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095737</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5695922</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095816</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8682149</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094905</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7857182</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094907</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8273311</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094909</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9135158</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047914</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8669978</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095369</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7538991</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095944</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8179551</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095888</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>948432</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047604</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>184472875911</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4482118</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094897</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7515325</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095551</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5391665</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095552</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5671177</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095554</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>857503</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095702</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3130484</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095705</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7703536</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095708</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1925467</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095710</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4868648</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095714</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1461190</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095166</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6133135</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095744</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9713345</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095745</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6496366</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095746</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7947399</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095802</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>479233</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095201</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>675017</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095092</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>81732</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095330</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7929657</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095688</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1853642</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095698</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1960482</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095701</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5920066</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095399</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1566391</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095417</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6895911</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095532</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1336881</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095398</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6636591</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094869</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9742439</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094871</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4268219</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094873</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4F411A337AAB4135A8F7EE9D0A86A8B2</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1046261</SI_NUMBER>
<IMG_LIST/>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8887884</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095064</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5097648</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095848</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1057178</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095849</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7879267</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095850</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4841241</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095854</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5187449</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095856</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9269304</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094961</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6635211</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094974</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8100335</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094980</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7850066</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094981</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9849070</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094986</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9985768</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094987</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3148897</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094989</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7160489</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094991</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4477019</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094995</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2687875</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094997</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6326306</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095000</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2177979</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095007</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6492885</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095015</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1201464</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095016</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6479404</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095025</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6746547</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095808</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1936589</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094864</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>83663</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094865</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2327298</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031160</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8514108</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095335</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>AAB03F9E9EEA4C838D4CFB7023ECA3EA</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047698</SI_NUMBER>
<IMG_LIST/>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8666465</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047753</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F0260342418359</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5956292</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047793</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F0260341638435</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9120858</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095522</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9925744</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095732</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7107706</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095749</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4654350</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095770</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1571866</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031222</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9907077</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095183</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3761725</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095193</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3268743</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096011</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9462480</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094795</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1099781</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094797</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4123651</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094798</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>212769</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095159</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6187845</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095162</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7419566</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095164</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7464842</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095165</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4256304</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095247</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3928639</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095249</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6524742</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095375</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8674059</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095378</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2745455</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095385</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2023544</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096009</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>97050</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096014</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>3374965-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6439529</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096023</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1607810</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096030</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2827681</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095222</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6694646</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095224</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5172662</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095241</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4497825</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031336</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>||sm_no||</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4005279</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031337</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER> </SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4783462</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096068</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4798950</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096074</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4736518</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095774</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6533345</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095776</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>MR5952641-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6609495</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095928</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6515278</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095946</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2640989</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095960</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>RO00207889-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>706980</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095361</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>667817</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095363</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4297685</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095465</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4189464</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048268</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>772955348425</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4851390</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096041</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SR2418054-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9582039</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096042</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SW2418429-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2724741</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094904</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9836789</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094910</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5957178</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094912</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7402152</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094960</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3742495</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095996</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1396909</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095416</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7068990</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095430</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7714500</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094992</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5945569</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094890</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6080832</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047768</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5222142</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095148</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>384472</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095151</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>117022</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095153</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>202074</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095625</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3707995</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095627</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2267784</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095628</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8999933</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095634</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3205923</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095635</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9949322</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095590</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7855764</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095703</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5400007</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095712</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7933161</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094841</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9323362</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094845</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>175162</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095225</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2756075</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031249</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6237189</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095407</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6678059</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031254</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8682839</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095411</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1503959</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095415</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3003365</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031151</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9523981</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031341</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>4701168959-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>614507</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095855</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>414584</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095859</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>372875</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095899</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>913963</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095088</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5315514</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031358</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2396842</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094884</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2361842</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095836</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4739969</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095838</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6049931</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095743</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6775016</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095425</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4224968</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095427</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3112267</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095432</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7644425</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047973</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>484608</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095844</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8485142</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095847</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8093427</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095954</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6075812</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095956</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1460120</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095966</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9271018</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094810</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5339069</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094811</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4065367</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094812</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>385590</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094814</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1518819</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094815</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6541689</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094817</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2573277</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094818</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3443191</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047556</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8864829</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094821</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9804528</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094828</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4689887</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094831</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>311097</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094833</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9346468</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094834</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5865141</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094835</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7003986</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094836</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6115550</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094843</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8972288</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094844</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8183773</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094878</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2765665</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094930</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4980198</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096065</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8358843</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096066</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1042498</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095557</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7691529</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095559</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5224021</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095562</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4840280</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095567</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9014223</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095569</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>997734</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095571</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4479862</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095925</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4473342</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047630</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F0260340662017</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1359821</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095930</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9884189</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095931</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9542910</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095932</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5060859</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095979</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1925301</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095992</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2979709</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031379</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>RO00207486-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6133509</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095885</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1769439</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095878</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SR2416913-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>636374</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048207</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>134170241142</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6197560</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095886</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SR2416914-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4587718</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095891</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5799404</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095893</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1121012</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095898</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5124261</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095901</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>00207858-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2381272</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095902</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8273811</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031367</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8628087</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031369</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>RO00207579-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9041771</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095911</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>3374364-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8065092</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048242</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3016067</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031370</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>RO00207580-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4470356</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095915</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1854233</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094876</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3426339</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095450</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2990679</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095458</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1280218</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095488</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7481056</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095491</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7173476</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094885</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5954979</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095492</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4662829</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095493</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>511942</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095494</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6316324</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095495</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4883137</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095496</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8777024</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095498</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2490141</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095503</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8434606</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048024</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>73CD0733B4B246C79BEB6F5AF13ECB46</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1046989</SI_NUMBER>
<IMG_LIST/>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3717460</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094942</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8295522</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094899</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4634915</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047745</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>772842425402</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7375799</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095113</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9678728</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095526</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9493034</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095529</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1752112</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095530</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7960041</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095531</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7567555</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095533</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9976388</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095534</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1525165</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095535</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3869118</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095564</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9940790</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095565</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1431339</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095721</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4821346</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095801</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2149017</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095805</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3316822</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095839</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8196691</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048287</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4033690</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094968</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4437080</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094969</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4464142</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095645</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7409635</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095814</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5715345</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031387</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>922846</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096038</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5376315</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOA1031388</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>MR5955714-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1325840</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096039</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>MR5956079-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7258609</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048282</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>772967340494</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6807888</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096052</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>7083449</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095602</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8194058</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048135</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1ZE371780343014942</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3584542</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095797</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8569045</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095799</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5748692</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095800</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>380309</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095940</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3928730</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095948</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9266424</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095843</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3053657</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096022</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>SR2416895-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9016298</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094914</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9905425</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094911</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4434183</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094918</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6403218</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094920</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>130747</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094921</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9406747</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094922</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9905179</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094923</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3917281</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095329</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5269973</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048034</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F03A0368148073</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5514543</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095733</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8059375</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095051</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2040987</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095239</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8858127</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095240</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>920559</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095242</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1528678</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095243</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5117557</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095258</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2078353</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095260</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5999484</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047834</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>184472873919</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>8238880</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095237</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2379850</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095265</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5904392</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095328</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6479441</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095359</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5890139</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095704</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4212987</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095706</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3880618</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048128</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>108845918648</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>9429539</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1094783</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2345480</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095753</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2668902</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095755</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3111810</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095759</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5938192</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095760</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6110837</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095817</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4592439</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048171</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6889771</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095216</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1506215</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1047810</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6277409</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095226</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>6096012</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095536</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>3528614</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096019</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>2334933</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096025</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1719563</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1096031</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>MR5939614-1</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>1585886</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095896</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>288479</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095604</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>5267204</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WOP1048071</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>1Z58F0260341055476</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4032032</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095644</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');
insert into qqm_outbox (payload,msg_type) values ('<?xml version="1.0"?>
<ROW>
<QQM_MSG_GUID>4876292</QQM_MSG_GUID>
<MSG_TYPE>WO_RECEIVED</MSG_TYPE>
<SI_NUMBER>WO1095646</SI_NUMBER>
<IMG_LIST/>
<SM_NUMBER>NA</SM_NUMBER>
<NVP/>
</ROW>
','WO_RECEIVED');

create or replace view VIEW_RC_SHIPMENT_NO( 
RCH_AUTO_KEY ,SM_NO ,GUI ,ENTRY_DATE ,TODAY )
as 
select 
297029,'3375133-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297091,'MR5939614-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297120,'3372435-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297157,'SN-005182-2021-1','5424','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297225,'4701170784-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297251,'RO00207965-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297053,'3374968-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297058,'3374985-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297061,'3374965-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297071,'3375210-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297078,'3375207-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297170,'RO00207898-1','348748','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297191,'3373407-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297203,'4701170201-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297223,'SR2415533-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297127,'772955348425-0310834','310834','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297226,'3374545-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297036,'3373877-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297242,'3374411-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297126,'MR5956079-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297144,'SR2418054-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297156,'SW2418429-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297082,'SR2415528-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297090,'SR2415531-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297117,'SR2416934-1','218184','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297259,'772947045452-0309965','309965','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
296997,'4701170396-1','','2/24/2021','"2/24/2021 6:07:40 PM"' from dual union all select 
297030,'RO00207486-1','347952','2/24/2021','"2/24/2021 6:07:40 PM"' from dual;

Open in new window


all of the GUI values of your view are NULL

can you do

select gui, sm_no from view_rc_shipment_no;

and post the results as text?
I have six values that are not NULL in VIEW_RC_SHIP_NO. Text file attached.
VIEW_RC_SHIPMENT_NO.txt

User generated image
unfortunately, none of those GUI values correspond to any of the QQM_MSG_GUID values in your sample data.

Just so we can move on and start trying to solve the real problem, I've modified the view to use 6 GUI values that ARE in your table's sample data.

That means the query will not produce "real" results, but the functionality of the query will still be structurally valid

CREATE OR REPLACE VIEW view_rc_shipment_no
(
    rch_auto_key,
    sm_no,
    gui
)
AS
    SELECT 297127, '772955348425-0310834', '7394175' FROM DUAL
    UNION ALL
    SELECT 297170, 'RO00207898-1', '3055982' FROM DUAL
    UNION ALL
    SELECT 297259, '772947045452-0309965', '2758140' FROM DUAL
    UNION ALL
    SELECT 297030, 'RO00207486-1', '4932595' FROM DUAL
    UNION ALL
    SELECT 297157, 'SN-005182-2021-1', '3507042' FROM DUAL
    UNION ALL
    SELECT 297117, 'SR2416934-1', '1110952' FROM DUAL;

Open in new window

SELECT UPDATEXML(xmltype(t.payload),
                 '/ROW/SM_NUMBER',
                 v.sm_no)
  FROM qqm_outbox t, view_rc_shipment_no v
 WHERE t.msg_type = 'WO_RECEIVED'
   AND XMLCAST(XMLQUERY('/ROW/QQM_MSG_GUID/text()' PASSING xmltype(t.payload) RETURNING CONTENT) AS VARCHAR2(100)) =
       v.gui
   AND XMLCAST(XMLQUERY('/ROW/SM_NUMBER/text()' PASSING xmltype(t.payload) RETURNING CONTENT) AS VARCHAR2(100)) = 'NA'
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent!
Glad I could help.