CREATE TRIGGER trg_rich700_trb3lookup_b_ins
  BEFORE INSERT ON rich700_trb3lookup
  FOR EACH ROW
  DECLARE
  BEGIN
    SELECT rich_par_vers_sequ.NEXTVAL INTO :new.id FROM DUAL;
    :new.det_part_id := -1;
    :new.date_create := SYSDATE;
    :new.invalid_since := hdate.high_date;
  END;