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?
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?
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?
at the very minimum, is payload xmltype, varchar2, clob?
ASKER
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.
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.
ASKER
Does this help?
qqm_outbox.xls
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;
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?
can you do
select gui, sm_no from view_rc_shipment_no;
and post the results as text?
ASKER
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
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;
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'
'/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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent!
Glad I could help.
what are the columns and types of each table? Can you provide ddl for us to work from?