INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10002,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='381370042495'),(select CATENTRY_ID from catentry where PARTNUMBER='381371019410'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10003,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='381370042495'),(select CATENTRY_ID from catentry where PARTNUMBER='381370010746'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10004,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='381370042303'),(select CATENTRY_ID from catentry where PARTNUMBER='381371019410'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10005,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='381370038023'),(select CATENTRY_ID from catentry where PARTNUMBER='381371019410'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10006,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='381370036623'),(select CATENTRY_ID from catentry where PARTNUMBER='381371019410'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10007,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='381370036623'),(select CATENTRY_ID from catentry where PARTNUMBER='381370010746'),'COMES_WITH',1,10551);