Уважаемые форумчане помогите изменить условие триггера :
when ( new.FR_CNT_ID_FIRST<>366 and new.TO_CNT_ID_FIRST=366 and new.DIRECTCTG=2
and new.MAILTYPE not in ('9','10','11','12','14','16','I','E','F','G','7','C','D','H','J','K','L','M','N','O','Q','S','W','T','Z') ---ОТСЮДА НУЖНО УБРАТЬ mailtype '7'
И в IF-е добавить условие примерно такое IF mailtype = '7' and alphacode = 'EE', INSERT срабатывал

CREATE OR REPLACE TRIGGER U_MAIL_AFT_INS
AFTER INSERT ON COLVIR.U_MAIL FOR EACH ROW
when ( new.FR_CNT_ID_FIRST<>366 and new.TO_CNT_ID_FIRST=366 and new.DIRECTCTG=2
and new.MAILTYPE not in ('9','10','11','12','14','16','I','E','F','G','7','C','D','H','J','K','L','M','N','O','Q','S','W','T','Z')
)
DECLARE
v_barcode VARCHAR2(30);
v_rcpn_phone VARCHAR2(30);
BEGIN

v_barcode:= :NEW.barcode;
v_rcpn_phone:=REGEXP_REPLACE(nvl(:NEW.rcpn_phone,:NEW.rcpn_phone_spl),'[+]');

/* Типы (DTYPE): 1-rcpn email, 2-sndr email, 3-rcpn sms, 4-sndr sms */
IF ( length(v_rcpn_phone)=11
and substr(v_rcpn_phone,2,3) in ('700','701','702','703','704','705','706','707','708','709','747','750','751','760','761','762','763','764','770','771','775','776','777','778')
) THEN
INSERT INTO Z_NOTICE (ID, BARCODE, DEP_ID, DEVICE, DTYPE, STATUS, ADD_DATE, SEND_DATE, F22COUNT, BARCODE_STATUS, REGION, USER_ID)
VALUES (S_Z_NOTICE.Nextval, v_barcode, :NEW.DEP_ID, '7'||substr(v_rcpn_phone,2,10), 3, '0', sysdate, NULL, 1, 'IN_RK', 0, NULL);
ELSE
INSERT INTO Z_NOTICE_NO_PHONES (BARCODE, DEP_ID, DEVICE, DTYPE, ADD_DATE, F22COUNT, BARCODE_STATUS)
VALUES (v_barcode, :NEW.DEP_ID, v_rcpn_phone, 3, sysdate, 1, 'IN_RK');
END IF;

EXCEPTION WHEN others THEN NULL;
end U_MAIL_AFT_INS;