VIEW: APPS.CZ_RULE_PARTICIPANTS_V

Source

View Text - Preformatted

SELECT RUL.RULE_ID, RUL.RULE_FOLDER_ID, RUL.RULE_FOLDER_TYPE, RUL.NAME, RUL.RULE_TYPE, rul.REASON_ID, rul.DEVL_PROJECT_ID, rul.INVALID_FLAG, rul.DESC_TEXT, rul.COMPONENT_ID, rul.REASON_TYPE, rul.DISABLED_FLAG, rul.EFFECTIVE_USAGE_MASK, rul.SEQ_NBR, rul.EFFECTIVE_FROM, rul.EFFECTIVE_UNTIL, rul.PERSISTENT_RULE_ID, rul.EFFECTIVITY_SET_ID, rul.UNSATISFIED_MSG_ID, rul.UNSATISFIED_MSG_SOURCE, rul.SIGNATURE_ID, rul.TEMPLATE_PRIMITIVE_FLAG, rul.PRESENTATION_FLAG, rul.TEMPLATE_TOKEN, rul.RULE_TEXT, rul.NOTES, rul.CLASS_NAME, rul.INSTANTIATION_SCOPE, rul.MODEL_REF_EXPL_ID, rul.MUTABLE_FLAG, PART.participant_node_id, PART.participant_expl_id, PART.participant_role_list, DECODE (RUL.RULE_TYPE, 200, DECODE (RUL.PRESENTATION_FLAG, '0', -200, ( SELECT -1 * EXPRT.TEMPLATE_ID FROM CZ_EXPRESSION_NODES EXPRT WHERE EXPRT.RULE_ID = RUL.RULE_ID AND EXPRT.DELETED_FLAG = '0' AND EXPRT.EXPR_PARENT_ID IS NULL AND EXPRT.EXPR_TYPE != 208 )), RUL.RULE_TYPE ) AS DETAILED_RULE_TYPE FROM CZ_RULES RUL, ( select participant_node_id, participant_expl_id, rule_id, max (participant_role) as participant_role_list from cz_node_usage_in_rules_v findpart group by participant_node_id, participant_expl_id, rule_id ) part WHERE PART.RULE_ID = RUL.RULE_ID AND RUL.DELETED_FLAG = '0'

View Text - HTML Formatted

SELECT RUL.RULE_ID
, RUL.RULE_FOLDER_ID
, RUL.RULE_FOLDER_TYPE
, RUL.NAME
, RUL.RULE_TYPE
, RUL.REASON_ID
, RUL.DEVL_PROJECT_ID
, RUL.INVALID_FLAG
, RUL.DESC_TEXT
, RUL.COMPONENT_ID
, RUL.REASON_TYPE
, RUL.DISABLED_FLAG
, RUL.EFFECTIVE_USAGE_MASK
, RUL.SEQ_NBR
, RUL.EFFECTIVE_FROM
, RUL.EFFECTIVE_UNTIL
, RUL.PERSISTENT_RULE_ID
, RUL.EFFECTIVITY_SET_ID
, RUL.UNSATISFIED_MSG_ID
, RUL.UNSATISFIED_MSG_SOURCE
, RUL.SIGNATURE_ID
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.PRESENTATION_FLAG
, RUL.TEMPLATE_TOKEN
, RUL.RULE_TEXT
, RUL.NOTES
, RUL.CLASS_NAME
, RUL.INSTANTIATION_SCOPE
, RUL.MODEL_REF_EXPL_ID
, RUL.MUTABLE_FLAG
, PART.PARTICIPANT_NODE_ID
, PART.PARTICIPANT_EXPL_ID
, PART.PARTICIPANT_ROLE_LIST
, DECODE (RUL.RULE_TYPE
, 200
, DECODE (RUL.PRESENTATION_FLAG
, '0'
, -200
, ( SELECT -1 * EXPRT.TEMPLATE_ID
FROM CZ_EXPRESSION_NODES EXPRT
WHERE EXPRT.RULE_ID = RUL.RULE_ID
AND EXPRT.DELETED_FLAG = '0'
AND EXPRT.EXPR_PARENT_ID IS NULL
AND EXPRT.EXPR_TYPE != 208 ))
, RUL.RULE_TYPE ) AS DETAILED_RULE_TYPE
FROM CZ_RULES RUL
, ( SELECT PARTICIPANT_NODE_ID
, PARTICIPANT_EXPL_ID
, RULE_ID
, MAX (PARTICIPANT_ROLE) AS PARTICIPANT_ROLE_LIST
FROM CZ_NODE_USAGE_IN_RULES_V FINDPART GROUP BY PARTICIPANT_NODE_ID
, PARTICIPANT_EXPL_ID
, RULE_ID ) PART
WHERE PART.RULE_ID = RUL.RULE_ID
AND RUL.DELETED_FLAG = '0'