Untitled

SELECT 'Trigger count before deployment: ' || COUNT(DISTINCT dt.trigger_name) as trigger_count
FROM dba_cons_columns dcc
INNER JOIN dba_constraints dc
    ON dc.OWNER = dcc.owner
    AND dc.CONSTRAINT_NAME = dcc.constraint_name
    AND dc.TABLE_NAME = dcc.table_name
    AND dc.CONSTRAINT_TYPE = 'R'
INNER JOIN dba_cons_columns dc2
    ON dc2.owner = dc.R_OWNER
    AND dc2.constraint_name = dc.r_CONSTRAINT_NAME
INNER JOIN dba_triggers dt
    ON dt.owner = dcc.owner
    AND dt.table_name = dcc.table_name
WHERE dc.R_OWNER in ('REFDATA')
AND dcc.owner = '{schema}'
AND dt.trigger_name NOT LIKE 'AUD%'
AND dc2.table_name in (
    'ACCT',
    'ACCOUNTING_SYSTEM',
    'ONYX_COMPANY_TBL',
    'ONYX_CC_ROLES_TBL',
    'CONTACT_TBL',
    'CONTACT_VIEW',
    'USER_TBL',
    'INVESTMENTPROGRAM_TBL',
    'ONYX_COUNTRY_TBL',
    'LOCATION_CODE',
    'ONYX_LOCATIONS_TBL',
    'FUND',
    'FUND_LEGAL_TYPE',
    'ACCOUNT_STRATEGY_TYPE'
);