Untitled

INSERT INTO cq_shell_glb2.cq_shell.email_rule (    is_active,    name,    change_fields,    display_fields,    entity_def,    include_defect,    filter_query,    show_previous,    cc_actioner,    to_addr_fields,    cc_addr_fields,    to_additional,    cc_additional,    from_addr,    subject_fields,    is_active_rule,    actions,    action_types,    source_states,    target_states,    operator_value,    headers_template,    ignore_fields,    is_standard_rule,    template,    use_template,    ratl_mastership,    dbid)SELECT    src.is_active,    src.name,    src.change_fields,    src.display_fields,    src.entity_def,    src.include_defect,    src.filter_query,    src.show_previous,    src.cc_actioner,    src.to_addr_fields,    src.cc_addr_fields,    src.to_additional,    src.cc_additional,    src.from_addr,    src.subject_fields,    src.is_active_rule,    src.actions,    src.action_types,    src.source_states,    src.target_states,    src.operator_value,    src.headers_template,    src.ignore_fields,    src.is_standard_rule,    src.template,    src.use_template,    16780608,    (src.dbid + 200000)FROM    cq_shell_lon.cq_shell.email_rule srcWHERE src.dbid <> 0 AND NOT EXISTS (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.email_rule t1 WHERE t1.dbid <> 0 AND t1.name = (SELECT t1.name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.email_rule t1 WHERE t1.dbid <> 0 AND t1.dbid = src.dbid))GOUPDATE cq_shell_glb2.cq_shell.application_change SET default_ucm_project = (CASE WHEN default_ucm_project = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.ucm_project t1 WHERE t1.dbid <> 0 AND t1.name = (SELECT t1.name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.ucm_project t1 WHERE t1.dbid <> 0 AND t1.dbid = default_ucm_project)) END), application_release = (CASE WHEN application_release = 0 THEN 0 ELSE (application_release + 200000) END), found_in_build = (CASE WHEN found_in_build = 0 THEN 0 ELSE (found_in_build + 200000) END), project_name_1 = (CASE WHEN project_name_1 = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.project_name t1 WHERE t1.dbid <> 0 AND t1.name = (SELECT t1.name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.project_name t1 WHERE t1.dbid <> 0 AND t1.dbid = project_name_1)) END), error_message = (CASE WHEN error_message = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.error_messages t1 WHERE t1.dbid <> 0 AND t1.message_id = (SELECT t1.message_id FROM cq_shell_lon.cq_shell.error_messages t1 WHERE t1.dbid <> 0 AND t1.dbid = error_message)) END), from_env = (CASE WHEN from_env = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.environment t1, cq_shell_glb2.cq_shell.application t2 WHERE t1.dbid <> 0 AND t1.application = t2.dbid AND {fn CONCAT(t1.name, {fn CONCAT(' ', {fn CONCAT(t2.name, {fn CONCAT(' ', t1.env_type)})})})} = (SELECT {fn CONCAT(t1.name, {fn CONCAT(' ', {fn CONCAT(t2.name, {fn CONCAT(' ', t1.env_type)})})})} COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.environment t1, cq_shell_lon.cq_shell.application t2 WHERE t1.dbid <> 0 AND t1.application = t2.dbid AND t1.dbid = from_env)) END), application = (CASE WHEN application = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.application t1 WHERE t1.dbid <> 0 AND t1.name = (SELECT t1.name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.application t1 WHERE t1.dbid <> 0 AND t1.dbid = application)) END), build = (CASE WHEN build = 0 THEN 0 ELSE (build + 200000) END), application_portfolio = (CASE WHEN application_portfolio = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.application_portfolio t1 WHERE t1.dbid <> 0 AND t1.name = (SELECT t1.name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.application_portfolio t1 WHERE t1.dbid <> 0 AND t1.dbid = application_portfolio)) END), submitter = (CASE WHEN submitter = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.login_name = (SELECT t1.login_name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.dbid = submitter)) END), change_controller = (CASE WHEN change_controller = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.login_name = (SELECT t1.login_name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.dbid = change_controller)) END), parent_application_change = (CASE WHEN parent_application_change = 0 THEN 0 ELSE (parent_application_change + 200000) END), evaluator = (CASE WHEN evaluator = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.login_name = (SELECT t1.login_name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.dbid = evaluator)) END), to_env = (CASE WHEN to_env = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.environment t1, cq_shell_glb2.cq_shell.application t2 WHERE t1.dbid <> 0 AND t1.application = t2.dbid AND {fn CONCAT(t1.name, {fn CONCAT(' ', {fn CONCAT(t2.name, {fn CONCAT(' ', t1.env_type)})})})} = (SELECT {fn CONCAT(t1.name, {fn CONCAT(' ', {fn CONCAT(t2.name, {fn CONCAT(' ', t1.env_type)})})})} COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.environment t1, cq_shell_lon.cq_shell.application t2 WHERE t1.dbid <> 0 AND t1.application = t2.dbid AND t1.dbid = to_env)) END), developer = (CASE WHEN developer = 0 THEN 0 ELSE (SELECT t1.dbid FROM cq_shell_glb2.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.login_name = (SELECT t1.login_name COLLATE SQL_Latin1_General_CP1_CI_AS FROM cq_shell_lon.cq_shell.users t1 WHERE t1.dbid <> 0 AND t1.dbid = developer)) END) WHERE ratl_mastership = 16780608GOUPDATE    cq_shell_glb2.cq_shell.parent_child_linksSET    parent_dbid = (parent_dbid + 200000),    ratl_mastership = NULLFROM    cq_shell_glb2.cq_shell.application_change dstINNER JOIN    cq_shell_glb2.cq_shell.entitydef e ON        e.name = 'application_change'INNER JOIN    cq_shell_glb2.cq_shell.fielddef f ON        f.name = 'test_record' AND        f.entitydef_id = e.idWHERE    parent_dbid <> 0 AND    e.id = parent_entitydef_id AND    dst.dbid = (parent_dbid + 200000) AND    cq_shell_glb2.cq_shell.parent_child_links.ratl_mastership = 16780608GOGOUPDATE    cq_shell_glb2.cq_shell.parent_child_linksSET    parent_dbid = (parent_dbid + 200000),    ratl_mastership = NULLFROM    cq_shell_glb2.cq_shell.application_change dstINNER JOIN    cq_shell_glb2.cq_shell.entitydef e ON        e.name = 'application_change'INNER JOIN    cq_shell_glb2.cq_shell.fielddef f ON        f.name = 'cc_activity' AND        f.entitydef_id = e.idWHERE    parent_dbid <> 0 AND    e.id = parent_entitydef_id AND    dst.dbid = (parent_dbid + 200000) AND    cq_shell_glb2.cq_shell.parent_child_links.ratl_mastership = 16780608GOGO