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_ZB_SPR_RB_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ZB_SPRAWOZDANIA_RB |
TRG_ZB_SPR_RB_HIST_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RB_HISTORIA |
TRG_ZB_SPR_RBN_HIST_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBN_POZ_HIST |
TRG_ZB_SPR_RBN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBN_POZ |
TRG_ZB_SPR_RBN_POZ_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ZB_SPRAWOZDANIA_RBN_POZ |
TRG_ZB_SPR_RBS27_HIST_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBS27_POZ_HIST |
TRG_ZB_SPR_RBS27_KONCOWE_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ZB_SPRAWOZDANIA_RBS27_KONCOWE |
TRG_ZB_SPR_RBS27_POZ_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ZB_SPRAWOZDANIA_RBS27_POZ |
TRG_ZB_SPR_RBS27_ZMBO_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBS27_ZMIANYBO |
TRG_ZB_SPR_RBS27_ZMBO_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ZB_SPRAWOZDANIA_RBS27_ZMIANYBO |
TRG_ZB_SPR_RBS27_ZMBO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBS27_ZMIANYBO |
TRG_ZB_SPR_RBS_ZMIANY_ID_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RBS_ZMIANY |
TRG_ZB_SPR_RB_ZAL_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_RB_ZALACZNIKI |
TRG_ZB_SPR_RB_ZAL_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ZB_SPRAWOZDANIA_RB_ZALACZNIKI |
TRG_ZB_SPR_RB_ZAL_USUN | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ZB_SPRAWOZDANIA_RB_ZALACZNIKI |
TRG_ZB_SPR_WYKONANIE_POZ_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_WYKONANIE_POZ |
TRG_ZB_SPR_WYKONANIE_POZ_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ZB_SPRAWOZDANIA_WYKONANIE_POZ |
TRG_ZB_SPR_WYKONANIE_POZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_SPRAWOZDANIA_WYKONANIE_POZ |
TRG_ZB_ZALACZNIK_WYK_DOCH_KONC | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZB_ZALACZNIK_WYK_DOCH_KONCOWE |
TRG_ZEWN_KLUCZE_DOSTEPU_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ZEWNETRZNE_KLUCZE_DOSTEPU |
TRIG_FAKTURY_POZ_BI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_POZ |
TR_KAL_GODZINY_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_KAL_GODZINY |
TR_KAL_WOLNE_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_KAL_WOLNE |
TR_KDR_UMOWY_PPK_DATA_OD_MM | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_UMOWY_PPK |
TR_KDR_UMOWY_PPK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK |
TR_PARAMETRY_RO_AK_DATA_DO_MAX | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAMETRY_RO |
TR_PARAMETRY_RO_AK_DATA_OD_MIN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAMETRY_RO |
TR_PK_PRACPOZYCZKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_POZYCZKI |
TR_PRACDODATKI_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_DODATKI |
TR_PRACLIMNIEOB_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_LIMITY_NIEOBECNOSCI |
TR_PRACLISTYPLAC_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PRAC_LISTYPLAC |
TR_PRAC_LISTYPLAC_UMOWY_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_LISTYPLAC_UMOWY |
TR_PRAC_LISTYPL_UMOWY_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_LISTYPLAC_UMOWY |
TR_PRACNIEOB_DTNAL | DISABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PRAC_NIEOBECNOSCI |
TR_PRACNIEOBECNOSCI_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_NIEOBECNOSCI |
TR_PRACPASKI_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_PASKI |
TR_PRACPASKIumowy_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_PASKI_UMOWY |
TR_PRAC_PASKI_UMOWY_PRZELICZ | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | PRAC_PASKI_UMOWY |
TR_PRAC_PASKI_UMOWY_WYPLACONE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | PRAC_PASKI_UMOWY |
TR_USL_SPR_P_BIO_NIEPRZEK_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_BIO_NIEPRZEK |
TR_USL_SPR_P_BIO_PRZEK_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_BIO_PRZEK |
TR_USL_SPR_P_CIEKLE_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_CIEKLE |
TR_USL_SPR_P_PUNKT_SEL_ZB_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_PUNKT_SEL_ZB |
TR_USL_SPR_P_RECYKL_BUD_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_RECYKLING_BUD |
TR_USL_SPR_P_RECYKL_FRA_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_RECYKLING_FRA |
TR_USL_SPR_P_RODZ_ZAGO_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_RODZ_ODP_ZAGO |
TR_USL_SPR_P_ROZKK_W_OBSZ_MASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_ROZKL_W_OBSZA |
USL_PISMA_ESIGNUM_AUDYT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USL_PISMA_ESIGNUM |
USL_UMOWY_EDIT_P_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_UMOWY_EDIT_P |
USL_UMOWY_EDIT_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_UMOWY_EDIT |
USR_PARAMETRY_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | USR_PARAMETRY |