CREATE OR REPLACE TRIGGER TR_ZY_BRXXB0_AUPD_XK
 AFTER 
 UPDATE OF CSRQ00, DQKS00, RYCWH0, XB0000, XM0000, ZYH000
 ON SD_ZY.ZY_BRXXB0
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW 
DECLARE
    COUNTER  NUMBER(3);
    Ecustom  EXCEPTION;
    Verrmsg  Varchar2(100);
Begin
  IF (NVL(:NEW.XM0000,0)<>NVL(:OLD.XM0000,0) or TRIM(:NEW.XM0000) is not null) THEN
    UPDATE XK_BRXX00 SET XM0000=:NEW.XM0000 WHERE BRID00=:OLD.BRID00;
  END IF;
  
  IF (NVL(:NEW.XB0000,0)<>NVL(:OLD.XB0000,0) or TRIM(:NEW.XB0000) is not null) THEN
    UPDATE XK_BRXX00 SET XB0000=:NEW.XB0000 WHERE BRID00=:OLD.BRID00;
  END IF;
  
  IF (NVL(:NEW.CSRQ00,0)<>NVL(:OLD.CSRQ00,0) or TRIM(:NEW.CSRQ00) is not null) THEN
    UPDATE XK_BRXX00 SET CSRQ00=:NEW.CSRQ00 WHERE BRID00=:OLD.BRID00;
  END IF;
  
  IF (NVL(:NEW.ZYH000,0)<>NVL(:OLD.ZYH000,0) or TRIM(:NEW.ZYH000) is not null) THEN
    UPDATE XK_BRXX00 SET ZYH000=:NEW.ZYH000 WHERE BRID00=:OLD.BRID00;
  END IF;
 /* IF (TRIM(:NEW.DQKS00)<>'' or TRIM(:NEW.DQKS00) is not null)  THEN
    IF NVL(:NEW.DQKS00,0)<>NVL(:OLD.DQKS00,0) THEN
      UPDATE XK_SXSQ00 SET KSMC00=(SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00=:NEW.DQKS00 AND ROWNUM=1) WHERE BRID00=:OLD.BRID00 AND SQZT00 IN('0','2');
    END IF;
  END IF;
  IF (TRIM(:NEW.RYCWH0)<>'' or TRIM(:NEW.RYCWH0) is not null) THEN
    IF NVL(:NEW.RYCWH0,0)<>NVL(:OLD.RYCWH0,0) THEN
      UPDATE XK_SXSQ00 SET CH0000=:NEW.RYCWH0 WHERE BRID00=:OLD.BRID00 AND SQZT00 IN('0','2');
    END IF;
  END IF;*/

End;