Get All Rules

            SELECT * FROM MOW_RULES
        

Get Rule Conditions

            SELECT * FROM MOW_RULE_CONDITIONS WHERE RULE_GUID = ANY ( SELECT RULE_GUID FROM MOW_RULES WHERE RULE_NAME = 'Rule Name' )
        

Get Canditates

            SELECT *
            FROM MOW_RULE_CANDIDATES
            WHERE RULE_GUID = ANY
                (
            SELECT RULE_GUID FROM MOW_RULES WHERE RULE_NAME = 'Rule Name'
                )