We can use following query to find out all the CX rules in the Configurator model. The query will display the information for the rules like rule_name, java class associated with it, event name, event scope, and oncommand event name.
SELECT DISTINCT RU.RULE_ID,
(SELECT NAME FROM CZ_SIGNATURES WHERE SIGNATURE_ID=EN.ARGUMENT_SIGNATURE_ID) AS EVENTNAME,
DECODE(EN.EVENT_EXECUTION_SCOPE, 1, 'Global', 2, 'Base Node SubTree', 4, 'Base Node', 'Unknown') AS SCOPE,
FROM CZ_RULES RU,
WHERE DEVL_PROJECT_ID IN (131343) --for given devl_project_id
AND RU.RULE_TYPE=300 --for CX rules
AND EN.ARGUMENT_SIGNATURE_ID IS NOT NULL --with valid event
AND RU.DELETED_FLAG=0 --ignore deleted nodes
AND EN.EXPR_PARENT_ID IS NULL --definition is only on parent node of expression tree
This query is useful at times to find out all CX rules with base node subtree event scope which may usually cause performance issue if its unwanted. You can always add other parameters/clauses to filter information as per your need.