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_TECZKI_TYTULOW_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TECZKI_TYTULOW |
TRG_T_KURSOW_BANKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | T_KURSOW_BANKI |
TRG_TMP_PLIKI_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | TMP_PLIKI |
TRG_ULICE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ULICE |
TRG_URL_ROZSZERZENIA_EBOK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | URL_ROZSZERZENIA_EBOK |
TRG_USL_DRUKI_GL | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_DRUKI_GL |
TRG_USL_DRUKI_GRAFIKA_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USL_DRUKI_GRAFIKA |
TRG_USL_DRUKI_GRAFIKA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_DRUKI_GRAFIKA |
TRG_USL_DRUKI_KONF_RAP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_DRUKI_KONFIG_RAPORTOW |
TRG_USL_DRUKI_RODZAJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_DRUKI_RODZAJE |
TRG_USL_DRUKI_RODZAJE_UP_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USL_DRUKI_RODZAJE |
TRG_USL_DZIAL_REG_ADR_I_NR_W | ENABLED | Valid | AFTER STATEMENT | INSERT | Table | USLUGI_DZIAL_REG_WEW_ADRESY |
TRG_USL_DZIAL_REG_ADR_U_NR_W | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_DZIAL_REG_WEW_ADRESY |
TRG_USL_DZIAL_REG_KODY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DZIALALNOSC_REG_KODY |
TRG_USL_DZIAL_REG_KODY_RDR_BUI | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_DZIALALNOSC_REG_KODY |
TRG_USL_DZIAL_REG_SP_ROZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DZIAL_REG_SP_ROZ |
TRG_USL_DZIAL_REG_SP_R_RDR_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_DZIAL_REG_SP_ROZ |
TRG_USL_DZIAL_REG_WEW_ADR_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DZIAL_REG_WEW_ADRESY |
TRG_USL_DZIAL_REG_WEW_ADR_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_DZIAL_REG_WEW_ADRESY |
TRG_USL_DZIAL_REG_WEW_ZAL_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DZIAL_REG_WEW_ZALACZ |
TRG_USL_DZIAL_REG_WEW_ZAL_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_DZIAL_REG_WEW_ZALACZ |
TRG_USL_INSTALACJE_OPER_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_OPERATORZY |
TRG_USL_INSTALACJE_POJAZDY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_POJAZDY |
TRG_USLINST_ODZ_PRZ_SEQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INST_SPR_ODZYSK_PRZEKAZ |
TRG_USLINST_ODZ_WL_SEQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INST_SPR_ODZYSK_WLASNY |
TRG_USL_INST_SPR_ID_A_RDR_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_INST_SPRAWOZDANIA |
TRG_USLINST_SP_ROZ_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INST_SPR_P_RODZ_ODP_ZAG |
TRG_USL_INST_SPR_P_CIEKLE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INST_SPR_P_CIEKLE |
TRG_USLOPBAZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_OPERATORZY_BAZY |
TRG_USLOPBAZ_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_OPERATORZY_BAZY |
TRG_USL_PISMA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA |
TRG_USL_PISMA_CZAS_PRZETW | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USL_PISMA |
TRG_USL_PISMA_DATA_STATUSU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USL_PISMA |
TRG_USL_PISMA_DOHISTORII | ENABLED | Valid | AFTER EACH ROW | UPDATE OR DELETE | Table | USL_PISMA |
TRG_USLPISMAESIG_KORESP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA_ESIGNUM_KORESP |
TRG_USL_PISMA_ESIGNUM_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA_ESIGNUM |
TRG_USL_PISMA_ESIGNUM_LOG_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA_ESIGNUM_LOG |
TRG_USL_PISMA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA |
TRG_USL_PISMA_MOD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USL_PISMA |
TRG_USL_PISMA_PRZYPISY_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA_PRZYPISY |
TRG_USL_PISMA_TYPY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_PISMA_TYPY |
TRG_USL_REJESTR_ZEZWOLEN | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_REJESTR_ZEZWOLEN |
TRG_USLREKHIST_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_HISTORIA |
TRG_USLREK_HISTORIA | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | USLUGI_REKLAMACJE |
TRG_USL_REKL_STATUSY_DATA_USER | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_STATUSY |
TRG_USL_REKL_ST_PL_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_STATUSY_PLIK |
TRG_USL_REKL_ST_PL_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_REKLAMACJE_STATUSY_PLIK |
TRG_USLREKOBS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_OBSERWATORZY |
TRG_USLREKSTAT_AFTER_INSERT | ENABLED | Valid | AFTER EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_STATUSY |
TRG_USLREKSTAT_POPRZEDNI_STAT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_STATUSY |
TRG_USLREKUZYUPR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_REKLAMACJE_UZYTK_UPRAWN |
TRG_USL_SEKT_GMINY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SEKTORY_GMINY |
TRG_USL_SL_DRUKI_DEL | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | USL_SL_DRUKI |
TRG_USL_SL_DRUKI_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_SL_DRUKI |
TRG_USL_SL_TYPOLOGIE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SL_TYPOLOGIE |
TRG_USL_SPRAWO_PBIO_NIEPRZEK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_BIO_NIEPRZEK |
TRG_USL_SPRAWO_PRODZ_ODPZAG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_RODZ_ODP_ZAGO |
TRG_USL_SPRAWO_PROZKL_WOBSZA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_ROZKL_W_OBSZA |
TRG_USL_SPRAWOZDANIA_POSESJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZDANIA_POSESJE |
TRG_USL_SPRAWOZ_DATA_UTWORZ_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZDANIA |
TRG_USL_SPRAWOZ_DATA_ZLOZE_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZDANIA |
TRG_USL_SPRAWOZ_ID_A_RDR_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZDANIA |
TRG_USL_SPRAWOZ_ID_SPR_GL_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZDANIA |
TRG_USL_SPRAWOZ_P_BIO_PRZEK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_BIO_PRZEK |
TRG_USL_SPRAWOZ_P_CIEKLE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_CIEKLE |
TRG_USL_SPRAWOZ_P_RECYKL_BUD | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_RECYKLING_BUD |
TRG_USL_SPRAWOZ_P_RECYKL_FRA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_RECYKLING_FRA |
TRG_USL_SPRAWOZ_P_WEZWANIA_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_WEZWANIA |
TRG_USL_SPRAWOZ_STATUS_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | USLUGI_SPRAWOZDANIA |
TRG_USLSPRPBN_ID_ADRES_INST_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_BIO_NIEPRZEK |
TRG_USLSPRPBP_ID_ADRES_INST_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_BIO_PRZEK |
TRG_USLSPRPC_ID_ADRES_INST_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_CIEKLE |
TRG_USL_SPR_P_NOTATKI_OPERDATA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZ_P_NOTATKI |
TRG_USL_SPR_P_NOTATKI_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_NOTATKI |
TRG_USLSPRPRO_ID_ADRES_INST_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPRAWOZ_P_RODZ_ODP_ZAGO |
TRG_USL_SPR_PSZOK_DATA_ZL_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPRAWOZDANIA_PSZOK |
TRG_USL_SPR_PSZOK_ODZAG_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPR_PSZOK_ODP_ZAGO |
TRG_USL_SPR_PSZOK_ODZAG_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_SPR_PSZOK_ODP_ZAGO |
TRG_USL_SPR_PSZOK_ODZAG_GM_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_SPR_PSZOK_ODP_ZAGO |
TRG_USL_SPR_PSZOK_ODZAG_PZ_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_SPR_PSZOK_ODP_ZAGO |
TRG_USL_SPR_PSZOK_O_PRZEK_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_SPR_PSZOK_ODP_PRZEK |
TRG_USL_SPR_PSZOK_O_PRZEK_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_SPR_PSZOK_ODP_PRZEK |
TRG_USL_TMP_DRUKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_TMP_DRUKI |
TRG_USL_TMP_DRUKI_SL_TABELE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_TMP_DRUKI_SL_TABELE |
TRG_USL_TMP_DRUKI_TAB_UNI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_TMP_DRUKI_TAB_UNI |
TRG_USL_TMPD_SL_TABELE_KOD_TAB | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USL_TMP_DRUKI_SL_TABELE |
TRG_USLUGI_DEKLARACJE_OBOW_OD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_DEKLARACJE |
TRG_USLUGI_DEKLARACJE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DEKLARACJE |
TRG_USLUGI_DZIALAL_REGUL | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_DZIAL_REG_WEW |
TRG_USLUGI_DZIAL_REG_WEW_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_DZIAL_REG_WEW |
TRG_USLUGI_FAK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_FAKTURY |
TRG_USLUGI_FAK_POZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_FAKTURY_POZ |
TRG_USLUGI_INST_ADRESY_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | USLUGI_INSTALACJE_ADRESY |
TRG_USLUGI_INST_ADRESY_SEQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_ADRESY |
TRG_USLUGI_INST_ADRESY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | USLUGI_INSTALACJE_ADRESY |
TRG_USLUGI_INSTALACJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE |
TRG_USLUGI_INST_SPRAWOZ_ID_SPR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INST_SPRAWOZDANIA |
TRG_USLUGI_INST_UMOWY_LIMITY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_UMOWY_LIMITY |
TRG_USLUGI_INST_UMOWY_OBOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_UMOWY_OBOW |
TRG_USLUGI_INST_UMOWY_PLI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_UMOWY_PLIKI |