Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
Trigger Name | Status | Validity | Type | Event | Base Object Type | Base Object |
---|---|---|---|---|---|---|
TRG_KG_BILANS_KONTA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_BILANS_KONTA |
TRG_KG_BUDZET_KONTA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_BUDZET_KONTA |
TRG_KG_DEKRETY_LIMIT_BUDZETU | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKRETY |
TRG_KG_DEKRETY_ODWROC | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKRETY |
TRG_KG_DEKRETY_PRZEKS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKRETY |
TRG_KG_DOWODY_KS_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | DOWODY_KS |
TRG_KG_DOWODY_KS_BLOKADA | DISABLED | Valid | BEFORE EACH ROW | UPDATE | Table | DOWODY_KS |
TRG_KG_DOWODY_KS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DOWODY_KS |
TRG_KG_DOWODY_P_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | MAG_DOWODY_P |
TRG_KG_FAKTURY_KLAS_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | FAKTURY_KLASYFIKACJA |
TRG_KG_FAKTURY_ZAP2_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | FAKTURY_ZAP2 |
TRG_KG_HISTORIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_HISTORIA |
TRG_KG_HISTORIA_POPR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_HISTORIA |
TRG_KG_KONTA_AIUD | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KONTA |
TRG_KG_KONTA_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | KONTA |
TRG_KG_OBROTY_KS_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | OBROTY_KS |
TRG_KG_REGULY_KS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | REGULY_KS |
TRG_KG_RKASY_P_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | RKASY_P |
TRG_KG_ROZL_KONT_ZESP_CO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_ROZL_KONT_ZESPOLU_CO |
TRG_KG_ROZL_KONT_ZESP_DEK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_ROZL_KONT_ZESPOLU_DEK |
TRG_KG_ROZL_KONT_ZESP_GDZIE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_ROZL_KONT_ZESPOLU_GDZIE |
TRG_KG_ROZL_KONT_ZESP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_ROZL_KONT_ZESPOLU |
TRG_KG_ROZL_KONT_ZESP_WZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_ROZL_KONT_ZESPOLU_WZORCE |
TRG_KG_SL_BILANS_HIST_ID_HIST | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_SL_BILANS_HISTORIA |
TRG_KG_SL_BILANS_POZ_HIST_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_SL_BILANS_POZ_HISTORIA |
TRG_KG_SL_BILANS_POZ_ID_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_SL_BILANS_POZ |
TRG_KG_SL_BILANS_SUM_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_SL_BILANS_SUM |
TRG_KG_SL_BILANS_SUM_LOOPCHECK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KG_SL_BILANS_SUM |
TRG_KG_SL_BIL_POZ_MAN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_SL_BILANS_POZ_MAN |
TRG_KG_WLASCICIELE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KG_WLASCICIELE |
TRG_KG_ZAPLATY_KLAS_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | ZAPLATY_KLASYFIKACJA |
TRG_KIT_PODSTAWY_PRAWNE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KIT_PODSTAWY_PRAWNE |
TRG_KODY_ODPADOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_KODPADOW_SPRAWOZDANIA |
TRG_KOLEJNE_NUMERY_DOK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KOLEJNE_NUMERY_DOKUMENTOW |
TRG_KOMUNIKATOR_MIEDZYMODULOWY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KOMUNIKATOR_MIEDZYMODULOWY |
TRG_KOMUNIKATY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KOMUNIKATY |
TRG_KOMUNIKATY_PRZECZYTALI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KOMUNIKATY_PRZECZYTALI |
TRG_KOMUNIKATY_UPRAWNIENIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KOMUNIKATY_UPRAWNIENIA |
TRG_KPIR_HISTORIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KPIR_HISTORIA |
TRG_KPIR_HISTORIA_POPR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KPIR_HISTORIA |
TRG_LISTA_W_LOG_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | LISTA_WSZYSTKIEGO_LOG |
TRG_LODZ_EPA_ULICE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | LODZ_EPA_ULICE |
TRG_LODZ_EPA_ULICE_INSERT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | LODZ_EPA_ULICE |
TRG_LODZ_EPA_ULICE_UPDATE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | LODZ_EPA_ULICE |
TRG_MAG_DOWODY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_DOWODY |
TRG_MAG_DOWODY_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_DOWODY |
TRG_MAG_DOWODY_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY |
TRG_MAG_DOWODY_P_FAK_KLAS_AIU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY_P |
TRG_MAG_DOWODY_P_FAK_KLAS_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | MAG_DOWODY_P |
TRG_MAG_DOWODY_P_GRPTOW | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY_P |
TRG_MAG_DOWODY_P_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_DOWODY_P |
TRG_MAG_ZAKUPY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAKUPY |
TRG_MAG_ZAKUPY_P_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAKUPY_P |
TRG_MAG_ZAMOWIENIA_P_ROZKLADY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAMOWIENIA_P_ROZKLADY |
TRG_MAILFOLDER | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | MAIL_MESSAGE_FOLDER |
TRG_MAIL_MSG_FOLDER_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAIL_MESSAGE_FOLDER |
TRG_MAIL_MSG_SENT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAIL_MESSAGE_SENT_HEADER |
TRG_MAIL_PARAMETRY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAIL_PARAMETRY |
TRG_MASOWE_WYCIAG_P_WPLA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MASOWE_WYCIAG_P |
TRG_MECHANIZMY_GEN_PRZELEW_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MECHANIZMY_GEN_PRZELEWOW |
TRG_METRYKI_SPRAW_ID_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | METRYKI_SPRAW |
TRG_METRYKI_SPRAW_POZ_ID_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | METRYKI_SPRAW_POZ |
TRG_METRYKI_SPRAW_UPDATE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | METRYKI_SPRAW |
TRG_METRYKI_SPRAWY_SYMBOLE_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | METRYKI_SPRAWY_SYMBOLE |
TRG_MGA_MPIT_DANE_PIT_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_DANE_PIT |
TRG_MGA_MPIT_LOGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_LOGI |
TRG_MGA_MPIT_MIGRATORZY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_MIGRATORZY |
TRG_MGA_MPIT_PARAM_MIGR_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_PARAMETRY_MIGRACJI |
TRG_MGA_MPIT_PODMIOTY_ZEWN_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_PODMIOTY_ZEWNETRZNE |
TRG_MGA_MPIT_SL_POLA_DOK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MGA_MPIT_SL_POLA_DOKUMENTU |
TRG_MIASTA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MIASTA |
TRG_NAZWA_TABELI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ERROR_LOG |
TRG_NIP_DANE_SZUKAJ | ENABLED | Valid | AFTER STATEMENT | INSERT | Table | WYWIADOWNIA_NIP |
TRG_NOTY_ODS_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | NOTY_ODS |
TRG_NOTY_ODS_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | NOTY_ODS |
TRG_NOTY_ODS_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | NOTY_ODS |
TRG_OD_FAKTURY_COFA_KOMENT_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY_COFANIE_KOMENT |
TRG_OD_FAKTURY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY |
TRG_OD_FAKTURY_MAG_DOW_POZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY_MAG_DOW_POZ |
TRG_OD_FAKTURY_PLIKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY_PLIKI |
TRG_OD_FAKTURY_POZIOMY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY_POZIOMY |
TRG_OD_FAKTURY_VAT_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_FAKTURY_VAT |
TRG_OD_UZYTK_DJ_DOST_POZI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OD_UZYTK_DJ_DOST_POZI |
TRG_OKRES_ANAL_WIEK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | OKRESY_ANALIZY_WIEK |
TRG_ORGKOM_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ORG_KOMUNIKATY |
TRG_ORGKOM_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ORG_KOMUNIKATY |
TRG_PA_CZYNN_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_CZYNNOSCI |
TRG_PA_CZYNN_OSOBY_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_CZYNNOSCI_OSOBY |
TRG_PA_CZYNN_OSOBY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_CZYNNOSCI_OSOBY |
TRG_PA_CZYNN_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_CZYNNOSCI |
TRG_PA_CZYNN_ZALACZ_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_CZYNNOSCI_ZALACZ |
TRG_PA_CZYNN_ZALACZ_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_CZYNNOSCI_ZALACZ |
TRG_PA_DECYZJE_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_DECYZJE |
TRG_PA_DECYZJE_NR_DEC | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_DECYZJE |
TRG_PA_DECYZJE_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_DECYZJE |
TRG_PA_POST_KARY_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_KARY |
TRG_PA_POST_KARY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_POSTEPOWANIA_KARY |
TRG_PA_POST_PISMA_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_PISMA |
TRG_PA_POST_POSESJE_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_POSESJE |
TRG_PA_POST_POSESJE_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_POSTEPOWANIA_POSESJE |