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 |
---|---|---|---|---|---|---|
AUD_ZB_SPR_RBS27_ZMBO | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | ZB_SPRAWOZDANIA_RBS27_ZMIANYBO |
AUD_ZB_SPR_WYKONANIE_POZ | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | ZB_SPRAWOZDANIA_WYKONANIE_POZ |
DDL_TRG_ROLE_MGATOOLS | DISABLED | Valid | AFTER EVENT | CREATE OR DROP | Database | |
DOWODY_BI | DISABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_DOWODY |
DOWODY_BIU_MAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY |
DOWODY_P_AIUD_FAK | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | MAG_DOWODY_P |
DOWODY_P_BIU_MAG | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE | Table | MAG_DOWODY_P |
DOWODY_P_BIU_MAG_R | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY_P |
DOWODY_P_BIU_MAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_DOWODY_P |
DOWODY_P_IUD_FAK | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE OR DELETE | Table | MAG_DOWODY_P |
FAKTURY_AIUD | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | FAKTURY |
FAKTURY_ATIUD | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE OR DELETE | Table | FAKTURY |
FAKTURY_BTIUD | ENABLED | Valid | BEFORE STATEMENT | INSERT OR UPDATE OR DELETE | Table | FAKTURY |
FAKTURY_TYTULY_DO_AKTUALIZACJI | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | FAKTURY |
KDO_AUDYT | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDO_WEW |
KDO_ZDARZENIA_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDO_ZDARZENIA |
MAG_WZ_PZ_BIU_MAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MAG_WZ_PZ |
MAG_ZAMOWIENIA_P_TR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAMOWIENIA_P |
MAG_ZAMOWIENIA_TR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAMOWIENIA |
MAG_ZAM_POZ_DOW_POZ_TR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | MAG_ZAM_POZ_DOW_POZ |
MASOWE_WYCIAG_AUDYT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MASOWE_WYCIAG |
MASOWE_WYCIAG_P_AUDYT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | MASOWE_WYCIAG_P |
PALIWO_NORMY_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_NORMY |
PALIWO_OT_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_OT |
PALIWO_POJAZDY_DNI_BPRACY_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_POJAZDY_DNI_BPRACY |
PALIWO_POJAZDY_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_POJAZDY |
PALIWO_RW_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_RW |
PALIWO_SL_OT_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_SL_OT |
PALIWO_SL_PALIWA_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_SL_PALIWA |
PALIWO_SL_TYP_LICZNIKA_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_SL_TYP_LICZNIKA |
PALIWO_TANKOWANIE_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_TANKOWANIE |
PALIWO_WYNIKI_PRACY_POLA_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_WYNIKI_PRACY_POLA |
PALIWO_WYNIKI_PRACY_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_WYNIKI_PRACY |
PALIWO_ZW_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PALIWO_ZW |
PARAMETRY_LICENCJA | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PARAMETRY |
PK_PRACETATYHISTORIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_ETATY_HISTORIA |
PK_PRACPOPRZWYPL | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_POPRZEDNIE_WYPLATY |
POSESJA_BIU | DISABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA |
POSESJA_FAKTURY_AIU | DISABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE | Table | POSESJA |
POSESJA_USLUGI_HARM_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_USLUGI_HARM |
POSESJA_USLUGI_HARM_BU_R | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_USLUGI_HARM |
POSESJA_USLUGI_ILOSC_AD | ENABLED | Valid | AFTER STATEMENT | DELETE | Table | POSESJA_USLUGI_ILOSC |
POSESJA_USLUGI_ILOSC_BD_R | DISABLED | Valid | BEFORE EACH ROW | DELETE | Table | POSESJA_USLUGI_ILOSC |
POSESJA_USLUGI_ILOSC_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_USLUGI_ILOSC |
POSESJA_USLUGI_ILOSC_BU | ENABLED | Valid | AFTER STATEMENT | UPDATE | Table | POSESJA_USLUGI_ILOSC |
POSESJA_USLUGI_ILOSC_BU_R | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_USLUGI_ILOSC |
POSESJA_USLUGI_ILOSC_UD_DEK | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | POSESJA_USLUGI_ILOSC |
PRAC_NIEOBECNOSCI_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_NIEOBECNOSCI |
PRAC_PARAMETRY_CHECK_TYPES | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PRAC_PARAMETRY |
PRAC_PREMIE_PKSQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_PREMIE |
PRAC_PZATR_PKFROMTRIG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_PZATR |
PRAC_SL_POZYCZKI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_SL_POZYCZKI |
PRAC_WYPLATY_PKSQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_WYPLATY |
ROZ_TYTULY_WYKON_EKSPORTY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_TYTULY_WYKON_EKSPORTY |
SKAZANI_SPRAWY_TRG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SKAZANI_SPRAWY |
SL_FRAKCJE_KOMBINACJE_O | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_FRAKCJE_KOMBINACJE |
SL_FRAKCJE_KOMBINACJE_POZ_O | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_FRAKCJE_KOMBINACJE_POZ |
SL_KODPADOW_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_KODPADOW |
SL_NIEOBECNOSCI_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_NIEOBECNOSCI |
T_EG_SL_RODZAJE_ODSETEK_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_SL_RODZAJE_ODSETEK |
T_EG_TYTULY_ADN_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_ADNOTACJE |
T_EG_TYTULY_SL_POUCZ_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_SL_POUCZENIA |
TGR_POST_CZYNNOSCI_ZALACZ_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POST_CZYNNOSCI_ZALACZ |
TGR_POST_PRZYPISY_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POST_PRZYPISY |
TGR_POST_SL_CZYNNOSCI_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POST_SL_CZYNNOSCI |
TG_VEGOSOBCHAR_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_EG_OSOBY_CHARAKTER |
TG_VEGOSOBCHAR_INSERT | ENABLED | Valid | INSTEAD OF | INSERT | View | V_EG_OSOBY_CHARAKTER |
TG_VEGOSOBCHAR_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_EG_OSOBY_CHARAKTER |
TG_VEGOSOB_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_EG_OSOBY |
TG_VEGOSOB_INSERT | ENABLED | Valid | INSTEAD OF | INSERT | View | V_EG_OSOBY |
TG_VEGOSOB_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_EG_OSOBY |
TR_AI_PRACETATY_PREMIA | ENABLED | Valid | AFTER EACH ROW | INSERT | Table | PRAC_ETATY |
TR_CZASPRACY_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | CZAS_PRACY |
TR_CZASPRACY_WAR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CZAS_PRACY |
TR_CZASPRACY_WARPWUCZP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | WAR_PWU_CZASPRACY |
TRG_AB_FILTRY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_FILTRY |
TRG_AB_FILTRY_SZCZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_FILTRY_SZCZEGOLY |
TRG_ABUSDO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_USTAWIENIA_DOMYSLNE |
TRG_ABUS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_USTAWIENIA |
TRG_ABUSWAAT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_USTAWIENIA_WARTOSCI_ATR |
TRG_ABUSWA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AB_USTAWIENIA_WARTOSCI |
TRG_ADM_UPGRADE_LOG_DDL | ENABLED | Valid | AFTER EVENT | CREATE OR DROP OR RENAME | Schema | F_54 |
TRG_ADM_UPGRADE_LOG_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ADM_UPGRADE_LOG |
TRG_ADRESY_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ADRESY |
TRG_ADRESY_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ADRESY |
TRG_ADRESY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ADRESY |
TRG_AKTUALNOSCI_WPIS_DATA | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | AKTUALNOSCI_WPIS |
TRG_AKTUALNOSCI_WPIS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AKTUALNOSCI_WPIS |
TRG_AKTYWNOSCI_ID_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | AKTYWNOSCI |
TRG_AZ_EWIDENCJA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_EWIDENCJA |
TRG_AZ_EWIDENCJA_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_EWIDENCJA_POZ |
TRG_AZ_SCHEMATY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_SCHEMATY |
TRG_AZ_SCHEMATY_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_SCHEMATY_POZ |
TRG_AZ_SL_CZYNNOSCI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_SL_CZYNNOSCI |
TRG_AZ_UL_CZYN_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_CZYNNOSCI_ULICE_PARAM |
TRG_AZ_ULICE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | AZ_ULICE |
TRG_BANKI_BU_DATA_ZAM | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | BANKI |
TRG_BANKI_DEL_CK_HIST_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | BANKI_P |
TRG_BANKI_P_AIUD | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | BANKI_P |
TRG_BANKI_P_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | BANKI_P |