Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_RULE_PARTICIPANTS_V |
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'