INSERT INTO GROUPS (WGROUPID, WGROUPTYPEID, SDESCRIPTION, WPARENTGROUP2ID, WPARENTGROUP1ID, DSYSDATE, WSORTNO, BDISABLE, WCOLOR, WTEXTCOLOR) VALUES (gen_id(GEN_GROUPSID,1), 2000, '<@PRODUCTS_OPTIONS_NAME@>', '0', NULL, NULL, <@PROCESS@>@select WGROUPID from 6 for 12) from IMP_LINK where IMP_EXTID like 'OPTG:<@PRODUCTS_OPTIONS_NAME@>' and imp_sourceid =<@SOURCEID@> ##, NULL, NULL, NULL);

@@GO@@

INSERT INTO GROUPSOPTIONS (WGROUPID, WLOOKUPTYPE, SUSE_THUMBNAIL, SREM) VALUES (<@PROCESS@>@select WGROUPID from 6 for 12) from IMP_LINK where IMP_EXTID like 'OPTG:<@PRODUCTS_OPTIONS_NAME@>' and imp_sourceid =<@SOURCEID@> ##, '<@PRODUCTS_OPTIONS_TYPE@>', 'false', NULL);

@@GO@@

INSERT INTO GROUPS_DESCRIPTIONS (WGROUPID, WLANGUAGEID, SDESCRIPTION, WGROUPDESCID, CATEGORIES_DESCRIPTION) VALUES (<@PROCESS@>@select WGROUPID from 6 for 12) from IMP_LINK where IMP_EXTID like 'OPTG:<@PRODUCTS_OPTIONS_NAME@>' and imp_sourceid =<@SOURCEID@> ##, '431', '<@PRODUCTS_OPTIONS_NAME@>', '291', NULL);

@@GO@@

INSERT INTO GROUPS_DESCRIPTIONS (WGROUPID, WLANGUAGEID, SDESCRIPTION, WGROUPDESCID, CATEGORIES_DESCRIPTION) VALUES (<@PROCESS@>@select WGROUPID from 6 for 12) from IMP_LINK where IMP_EXTID like 'OPTG:<@PRODUCTS_OPTIONS_NAME@>' and imp_sourceid =<@SOURCEID@> ##, '434', '<@PRODUCTS_OPTIONS_NAME@>', '292', NULL);