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_PROD_RECEPT_SCH_PROD_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_RECEPTURA_SCH_PROD |
TRG_PROD_RECEPT_SUR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_RECEPTURA_SUROWCE |
TRG_PROD_RECEPTURA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_RECEPTURA |
TRG_PROD_RECEPTURA_ZAL_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_RECEPTURA_ZAL |
TRG_PROD_SL_PROD_STAT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_PRODUKCJA_STATUS |
TRG_PROD_SL_RECEPT_STAT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_RECEPTURA_STATUS |
TRG_PROD_SL_WZORZEC_PROD_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_WZORZEC_PROD |
TRG_PROD_SL_WZORZEC_PROD_P_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_WZORZEC_PROD_POZ |
TRG_PROD_SL_ZAMIENNIKI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_ZAMIENNIKI |
TRG_PROD_SL_ZAMIENNIKI_POZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_SL_ZAMIENNIKI_POZ |
TRG_PROFORMY2_DOW_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PROFORMY2_DOW |
TRG_PROFORMY2_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROFORMY2 |
TRG_PROFORMY2_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PROFORMY2 |
TRG_PROFORMY2_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PROFORMY2 |
TRG_PROFORMY_KONTROLA_DA_VAT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PROFORMY2 |
TRG_PRZELEW_PASKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRZELEWY_PASKI |
TRG_PRZELEWY_FAK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRZELEWY_FAK |
TRG_PRZELEWY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRZELEWY |
TRG_PRZELEWY_ZBIORCZE_MECH_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRZELEWY_ZBIORCZE_MECHANIZMY |
TRG_PUNKTY_ODBIORU | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PUNKTY_ODBIORU |
TRG_PUNKTY_ODBIORU_POJEMNIKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PUNKTY_ODBIORU_POJEMNIKI |
TRG_PUNKTY_ODBIORU_POJ_KODPAD | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PUNKTY_ODBIORU_POJ_KODPADOW |
TRG_PUNKTY_ODBIORU_POSESJA_USL | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PUNKTY_ODBIORU_POSESJA_USLUG |
TRG_RACHUNKI_KLASYFIKACJA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RACHUNKI_KLASYFIKACJA |
TRG_RAP_KATALOGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_KATALOGI |
TRG_RAPORTY_EXCEL_GRUPY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_EXCEL_GRUPY |
TRG_RAPORTY_EXCEL_GRUPY_RAP_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_EXCEL_GRUPY_RAPORTY |
TRG_RAPORTY_EXCEL_GRUPY_RAP_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | RAPORTY_EXCEL_GRUPY_RAPORTY |
TRG_RAPORTY_EXCEL_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_EXCEL |
TRG_RAPORTY_EXCEL_PARAM_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_EXCEL_SQL_PARAM |
TRG_RAPORTY_EXCEL_SQL_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_EXCEL_SQL |
TRG_RAPORTY_PDF_PARAM_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAPORTY_PDF_PARAM |
TRG_RAP_RAPORTY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_RAPORTY |
TRG_RAP_RAPORTY_KATALOGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_RAPORTY_KATALOGI |
TRG_RAP_RAPORTY_LOG_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_RAPORTY_LOG |
TRG_RAP_RAPORTY_ROLE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_RAPORTY_ROLE |
TRG_RAP_ROLE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_ROLE |
TRG_RAP_ROLE_SL_UZYTK_DJ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_ROLE_SL_UZYTK_DJ |
TRG_RAP_ROLE_UZYTKOWNICY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RAP_ROLE_UZYTKOWNICY |
TRG_REFSLZBDA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | REF_SL_ZBIORY_DANYCH |
TRG_REFSLZBDA_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | REF_SL_ZBIORY_DANYCH |
TRG_REJESTR_PISM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | REJESTR_PISM |
TRG_REJESTR_UMOW_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | REJESTR_UMOW |
TRG_REJESTR_UMOW_KLAS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | REJESTR_UMOW_KLASYFIKACJA |
TRG_REJESTRY_DEK_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | REJESTRY_DEK |
TRG_REJESTRY_ID_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | REJESTRY |
TRG_REJESTRY_ID_SL_R_ZS_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | REJESTRY |
TRG_RKASY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | RKASY |
TRG_RKASY_P_ZAP_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | RKASY_P |
TRG_RKASY_P_ZAP_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | RKASY_P |
TRG_RKASY_P_ZAP_KLAS_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | RKASY_P |
TRG_RKASY_P_ZAP_KLAS_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | RKASY_P |
TRG_RKASY_ZAP_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | RKASY |
TRG_RKASY_ZAP_KLAS_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | RKASY |
TRG_RODZAJE_WZOROW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_RODZAJ_WZORU_SPRAWOZDANIA |
TRG_ROLE_MGATOOLS | DISABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | ROLE_MGATOOLS |
TRG_ROLE_MGATOOLS_MAP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROLE_MGATOOLS_MAP |
TRG_ROZ_DECYZJE_ZALEGLOSCI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_DECYZJE_ZALEGLOSCI |
TRG_ROZ_DECYZJE_ZALEGLOSCI_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_DECYZJE_ZALEGLOSCI_POZ |
TRG_ROZ_KOSZTY_UPOMNIENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_KOSZTY_UPOMNIENIA |
TRG_ROZ_ODROCZENIE_TERM_FAK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_ODROCZENIE_TERM_FAK |
TRG_ROZ_ODROCZENIE_TERM_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_ODROCZENIE_TERM |
TRG_ROZ_RATY_FAKTURY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_RATY_FAKTURY |
TRG_ROZ_RATY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_RATY |
TRG_ROZ_RATY_POZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_RATY_POZ |
TRG_ROZ_RATY_POZ_ZERW_FAK_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_RATY_POZ_ZERW_FAK |
TRG_ROZ_RATY_TMP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_RATY_TMP |
TRG_ROZ_SL_POW_UM_ODS_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_SL_POWODY_UMORZ_ODS |
TRG_ROZ_SL_STAWKI_PRO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_SL_STAWKI_PRO |
TRG_ROZ_TYTULY_ORGANY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_TYTULY_ORGANY |
TRG_ROZ_TYTULY_WYKONAWCZE_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ROZ_TYTULY_WYKONAWCZE_WEW |
TRG_ROZ_TYTULY_WYKONAWCZE_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_TYTULY_WYKONAWCZE_POZ_WEW |
TRG_ROZ_TYTULY_WYKON_POZ_BIUD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | ROZ_TYTULY_WYKONAWCZE_POZ_WEW |
TRG_ROZ_UMORZENIA_ODSETEK_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_UMORZENIA_ODSETEK |
TRG_ROZ_UMORZENIA_ODSETEK_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ROZ_UMORZENIA_ODSETEK |
TRG_ROZ_UPOMNIENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_UPOMNIENIA |
TRG_ROZ_UPOMNIENIA_DATA_WYS | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ROZ_ZWROTKI_UPOMNIENIA |
TRG_ROZ_UPOMNIENIA_OSOBY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_UPOMNIENIA_OSOBY |
TRG_ROZ_UPOMNIENIA_OSOBY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ROZ_UPOMNIENIA_OSOBY |
TRG_ROZ_UPOMNIENIA_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_UPOMNIENIA_POZ |
TRG_ROZ_UPOMNIENIA_ZAAKCEPT | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | ROZ_UPOMNIENIA |
TRG_ROZ_WEZWANIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | WEZWANIA |
TRG_ROZ_ZWROTKI_UPOMNIENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | ROZ_ZWROTKI_UPOMNIENIA |
TRG_ROZ_ZWROTKI_UPOMNIENIA_MOD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | ROZ_ZWROTKI_UPOMNIENIA |
TRG_SAF_FAKTURY_STATUS_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SAF_FAKTURY_STATUS |
TRG_SAF_KDO_ZGODA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SAF_KDO_ZGODA |
TRG_SEL_EWIDENCJA_PRAC_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SEL_EWIDENCJA_PRAC |
TRG_SEL_HARMONOGRAMY_PRAC_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SEL_HARMONOGRAMY_PRAC |
TRG_SEL_TRASY_POSESJE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SEL_TRASY_POSESJE |
TRG_SEQ_USL_SL_DRUKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | USL_SL_DRUKI |
TRG_SKALE_POD_ID_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SKALE_PODATKOWE_POZ |
TRG_SL_BANKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_BANKI |
TRG_SL_CRM_KATEGORIE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_CRM_KATEGORIE |
TRG_SL_CRM_SZABLONY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_CRM_SZABLONY |
TRG_SL_CRM_TAGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_CRM_TAGI |
TRG_SL_DEK_DEC_SZABL_POW_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_DEK_DECYZJE_SZABLONY_POW |
TRG_SL_DEK_DEC_TYP_ROZL_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_DEK_DECYZJE_TYPY_ROZLICZEN |
TRG_SL_DEK_POLA_DEK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_DEK_POLA_DEKLARACJI |
TRG_SL_DEK_RODZAJE_WLASN_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_DEK_RODZAJE_WLASNOSCI |
TRG_SL_DEK_SEKCJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_DEK_SEKCJE |