The following insert statement is not working.
insert into CV3CatalogClassTypeValue (SiteID, RepFlags, Build, TouchedBy, TouchedWhen, CreatedBy, CreatedWhen, Active, GUID, CatalogMasterGUID, ClassTypeGUID, Value, MSrepl_tran_version)
(select ct.SiteID,ct.RepFlags,ct.Build,ct.TouchedBy, ct.TouchedWhen, ct.CreatedBy, ct.CreatedWhen, ct.Active, ct.GUID, 70302270, oc.GUID, ct.code, ct.MSrepl_tran_version
from
CV3CatalogClassTypeValue cc,
cv3ordercatalogmasteritem oc,
CV3ClassType ct
where cc.ClassTypeGUID=70302270
and cc.catalogmasterguid=oc.guid
and oc.name='acetaminophen ER tab')