INSERT INTO awe_historydoc(
            tenant_id, req_id, doc_id, scheme, user_id, role_id,
            activity, previous_state, next_state, remark, next_user_id, next_role_id,
            flg_user_role, activity_datetime, version)
    SELECT A.tenant_id, B.req_id, A.inventory_id, 'EA02', A.update_user_id, 10,
            'AUTO GENERATED', '', '', '', -99, -99,
            'R', '20171220142501', 0
    FROM in_inventory A
    INNER JOIN awe_currdoc_status B ON B.doc_id = A.inventory_id AND B.doc_no = A.doc_no AND B.doc_date = A.doc_date
    WHERE A.tenant_id = 10
    AND A.inventory_id = 1127