CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_sale_cons_conver_tbl` AS
    SELECT 
        `inv_to_ref_table`.`inv_to_ref_id` AS `consult_id`,
        _UTF8'inv' AS `Table_name`
    FROM
        `aerion`.`inv` `inv_to_ref_table`
    WHERE
        (`inv_to_ref_table`.`inv_to_ref_table` = _LATIN1'Consultant') 
    UNION SELECT 
        `assist_ref_table`.`assist_ref_id` AS `assist_ref_id`,
        _UTF8'prosp_assist' AS `Table_name`
    FROM
        `aerion`.`prosp_assist` `assist_ref_table`
    WHERE
        (`assist_ref_table`.`assist_ref_table` = _LATIN1'Consultant') 
    UNION SELECT 
        `aerion`.`immi_hierarchy`.`immi_hierar_ref_id` AS `immi_hierar_ref_id`,
        _UTF8'immi_hierarchy' AS `Table_name`
    FROM
        `aerion`.`immi_hierarchy`
    WHERE
        (`aerion`.`immi_hierarchy`.`immi_hierar_table` = _LATIN1'Prosp Consultant') 
    UNION SELECT 
        `aerion`.`immi_emp_receipt`.`immi_ref_id` AS `immi_ref_id`,
        _UTF8'immi_emp_receipt' AS `Table_name`
    FROM
        `aerion`.`immi_emp_receipt`
    WHERE
        (`aerion`.`immi_emp_receipt`.`immi_ref_table` = _LATIN1'Consultant') 
    UNION SELECT 
        `aerion`.`bank_acc`.`acc_owner` AS `acc_owner`,
        _UTF8'bank_acc' AS `Table_name`
    FROM
        `aerion`.`bank_acc`
    WHERE
        (`aerion`.`bank_acc`.`acc_owner_table` = _LATIN1'Consultant') 
    UNION SELECT 
        `aerion`.`storages`.`updated_for_ref_id` AS `updated_for_ref_id`,
        _UTF8'storages' AS `Table_name`
    FROM
        `aerion`.`storages`
    WHERE
        (`aerion`.`storages`.`updated_for_ref_table` = _LATIN1'Consultant')