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_EGTYTUAKT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_AKTUALIZACJE |
TRG_EGTYTU_AKTUALIZACJE_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_AKTUALIZACJE |
TRG_EGTYTU_AKTU_POZY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_AKTU_POZY |
TRG_EGTYTUDOAKTU_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_DOAKTU |
TRG_EGTYTU_DODAT_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_DODAT |
TRG_EGTYTUDO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_DODAT |
TRG_EGTYTU_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY |
TRG_EG_TYTULY_ADN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_ADNOTACJE |
TRG_EG_TYTULY_DOAKTU_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_DOAKTU |
TRG_EG_TYTULY_SL_POUCZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_SL_POUCZENIA |
TRG_EG_TYTULY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY |
TRG_EGTYTU_NIERUSZ_NR_I_DWYST | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY |
TRG_EGTYTU_NIERUSZSTATUSU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY |
TRG_EGTYTUOSOB_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_OSOBY |
TRG_EGTYTU_OSOBY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_OSOBY |
TRG_EGTYTUPOZY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_POZY |
TRG_EGTYTU_POZY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_POZY |
TRG_EGTYTUSTAT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_STATUS |
TRG_EGTYTU_STATUS | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | EG_TYTULY |
TRG_EGTYTU_STATUS_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_STATUS |
TRG_EGTYZWRUP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_ZWROTKI_UPOMNIENIA |
TRG_EGTYZWRUP_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_ZWROTKI_UPOMNIENIA |
TRG_EKSPORT_JPK_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EKSPORT_JPK |
TRG_ELP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ERROR_LOG_PLIKI |
TRG_ERROR_LOG_DATA_WYST_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ERROR_LOG |
TRG_ERROR_LOG_USER_ADDR_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ERROR_LOG |
TRG_EWIDENCJA_PESEL_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EWIDENCJA_PESEL |
TRG_FAKTURA_KURS | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURA_VAT_WALUTA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_VAT |
TRG_FAKTURY_ARCHIWUM_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_ARCHIWUM |
TRG_FAKTURY_AUDYT | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | FAKTURY |
TRG_FAKTURY_E_PLATNOSCI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_E_PLATNOSCI |
TRG_FAKTURY_FAK_KLAS_AIU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY |
TRG_FAKTURY_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY |
TRG_FAKTURY_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURY_ID_REJESTR_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURY_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY |
TRG_FAKTURY_KLASYFIKACJA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_KLASYFIKACJA |
TRG_FAKTURY_KLASYFIKACJA_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | FAKTURY_KLASYFIKACJA |
TRG_FAKTURY_KLASYFIKACJA_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_KLASYFIKACJA |
TRG_FAKTURY_KOMPENSATA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_KOMPENSATA |
TRG_FAKTURY_KONTROLA_DA_VAT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY |
TRG_FAKTURY_KONTROLA_TERMINU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURY_KPIR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_KPIR |
TRG_FAKTURY_MAG_DOW_POZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_MAG_DOW_POZ |
TRG_FAKTURY_PISMA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_PISMA |
TRG_FAKTURY_POZ_ST_VAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_POZ |
TRG_FAKTURY_POZ_WALUTA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_POZ |
TRG_FAKTURY_TYPKONTR | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY |
TRG_FAKTURY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | FAKTURY |
TRG_FAKTURY_USUNIECIE_BU | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | FAKTURY |
TRG_FAKTURY_UWAGI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_UWAGI |
TRG_FAKTURY_VAT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_VAT |
TRG_FAKTURY_VAT_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_VAT |
TRG_FAKTURY_VAT_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_VAT |
TRG_FAKTURY_VAT_ST_VAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | FAKTURY_VAT |
TRG_FAKTURY_ZAP2_ID_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_RATY | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_AIU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_AIUAS | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_KLAS_AIU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_KLAS_AIUS | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE | Table | FAKTURY_ZAP2 |
TRG_FAKTURY_ZAP2_ZAP_KLAS_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURYZAP_AIUD | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURYZAP_ATIUD | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE OR DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURYZAP_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FAKTURY_ZAP2 |
TRG_FAKTURYZAP_BTIUD | ENABLED | Valid | BEFORE STATEMENT | INSERT OR UPDATE OR DELETE | Table | FAKTURY_ZAP2 |
TRG_FAKTURYZAP_ODPISY | ENABLED | Valid | AFTER EACH ROW | DELETE | Table | FAKTURY_ZAP2 |
TRG_FRAKCJE_ODPADY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | FRAKCJE_ODPADY |
TRG_GMINY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | GMINY |
TRG_GRUPY_ROLE | ENABLED | Valid | AFTER EACH ROW | INSERT OR DELETE | Table | GRUPY_ROLE |
TRG_GRUPY_ROLE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | GRUPY_ROLE |
TRG_HISTORIA_STATUSOW_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DECYZJE_HISTORIA_STATUSOW |
TRG_INST_USL_INST_UMOWY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USLUGI_INSTALACJE_UMOWY |
TRG_KALENDARZ_DNIWOLNYCH | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KALENDARZ_DNIWOLNYCH |
TRG_KASY_KLASYFIKACJA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KASY_KLASYFIKACJA |
TRG_KDO_ADRESY_BIUD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDO_ADRESY |
TRG_KDO_ADRESY_ID_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_ADRESY |
TRG_KDO_BANKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_BANKI |
TRG_KDO_BLOKADY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_BLOKADY |
TRG_KDO_BLOKADY_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDO_BLOKADY |
TRG_KDO_DZIELNICE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_DZIELNICE |
TRG_KDO_DZ_INF_DZIALANIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_DZ_INF_DZIALANIA |
TRG_KDO_DZ_INF_UPOMNIENIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_DZ_INF_UPOMNIENIA |
TRG_KDO_ID_AKTYW_D_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDO_WEW |
TRG_KDO_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDO_WEW |
TRG_KDO_INDNRRACHUNKOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_IND_NR_RACHUNKOW |
TRG_KDO_INSTEAD_INS_UP_DEL | ENABLED | Valid | INSTEAD OF | INSERT OR UPDATE | View | KDO |
TRG_KDO_KLUCZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_WEW |
TRG_KDO_KONTAKT_BIUD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDO_KONTAKT |
TRG_KDO_KONTAKT_ID_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_KONTAKT |
TRG_KDO_LOGOWANIA_EBOK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_LOGOWANIA_EBOK |
TRG_KDO_PELNOMOCNICTWA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_PELNOMOCNICTWA |
TRG_KDO_PISMA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_PISMA |
TRG_KDO_POWIAZANI_ID_POWIAZANY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_POWIAZANI |
TRG_KDO_UPADLOSCI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_UPADLOSCI |
TRG_KDO_UPADLOSCI_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDO_UPADLOSCI |
TRG_KDO_USKARB_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_USKARB |