VIEW: APPS.CZ_RULE_EXPRDETLS_V

Source

View Text - Preformatted

SELECT RUL.RULE_ID, RUL.RULE_TYPE, DECODE (RUL.RULE_TYPE, 200, decode (rul.presentation_flag, '0', -200, NVL ((-1 * EXN.TEMPLATE_ID), -200) ), RUL.RULE_TYPE ) AS DETAILED_RULE_TYPE, DECODE (RUL.RULE_TYPE, 200, NVL (EXN.RULETYPECLASS, 228), 199) AS RULETYPE_DATATYPE, RUL.PERSISTENT_RULE_ID, exn.template_id as expr_root_rule_template_id, RUL.NAME AS RULE_NAME, RUL.DESC_TEXT AS RULE_DESCRIPTION, RUL.DEVL_PROJECT_ID, RUL.RULE_FOLDER_ID, RUL.RULE_FOLDER_TYPE, RUL.SEQ_NBR, RUL.SIGNATURE_ID, RUL.MUTABLE_FLAG, RUL.TEMPLATE_TOKEN, RUL.TEMPLATE_PRIMITIVE_FLAG, RUL.PRESENTATION_FLAG, ' ' AS RULE_TEXT, RUL.COMPONENT_ID, RUL.MODEL_REF_EXPL_ID, '  ' AS NOTES, RUL.CLASS_NAME, RUL.INSTANTIATION_SCOPE, RUL.REASON_ID, RUL.REASON_TYPE, RUL.UNSATISFIED_MSG_ID, RUL.UNSATISFIED_MSG_SOURCE, RUL.SEEDED_FLAG, RUL.INVALID_FLAG, RUL.DISABLED_FLAG, RUL.EFFECTIVE_FROM, RUL.EFFECTIVE_UNTIL, RUL.EFFECTIVE_USAGE_MASK, RUL.EFFECTIVITY_SET_ID, RUL.CHECKOUT_USER, RUL.ORIG_SYS_REF, RUL.CREATION_DATE, RUL.LAST_UPDATE_DATE, RUL.CREATED_BY, RUL.LAST_UPDATED_BY, RUL.LAST_UPDATE_LOGIN, RUL.RULE_CLASS, RUL.CLASS_SEQ, exn.expr_node_id, exn.expr_type FROM CZ_RULES RUL, ( SELECT 200 AS RULE_TYPE, 1 as presentation_flag, inexp.rule_id, inexp.template_id, inexp.expr_node_id, inexp.expr_type, 200 AS RULETYPECLASS from CZ_EXPRESSION_NODES inexp where inexp.expr_parent_id IS NULL AND inexp.expr_type != 208 and inexp.deleted_flag = '0' ) EXN WHERE EXN.rule_type (+) = rul.rule_type and exn.rule_id (+) = rul.rule_id and exn.presentation_flag (+) = rul.PRESENTATION_FLAG and RUL.DELETED_FLAG = '0'

View Text - HTML Formatted

SELECT RUL.RULE_ID
, RUL.RULE_TYPE
, DECODE (RUL.RULE_TYPE
, 200
, DECODE (RUL.PRESENTATION_FLAG
, '0'
, -200
, NVL ((-1 * EXN.TEMPLATE_ID)
, -200) )
, RUL.RULE_TYPE ) AS DETAILED_RULE_TYPE
, DECODE (RUL.RULE_TYPE
, 200
, NVL (EXN.RULETYPECLASS
, 228)
, 199) AS RULETYPE_DATATYPE
, RUL.PERSISTENT_RULE_ID
, EXN.TEMPLATE_ID AS EXPR_ROOT_RULE_TEMPLATE_ID
, RUL.NAME AS RULE_NAME
, RUL.DESC_TEXT AS RULE_DESCRIPTION
, RUL.DEVL_PROJECT_ID
, RUL.RULE_FOLDER_ID
, RUL.RULE_FOLDER_TYPE
, RUL.SEQ_NBR
, RUL.SIGNATURE_ID
, RUL.MUTABLE_FLAG
, RUL.TEMPLATE_TOKEN
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.PRESENTATION_FLAG
, ' ' AS RULE_TEXT
, RUL.COMPONENT_ID
, RUL.MODEL_REF_EXPL_ID
, ' ' AS NOTES
, RUL.CLASS_NAME
, RUL.INSTANTIATION_SCOPE
, RUL.REASON_ID
, RUL.REASON_TYPE
, RUL.UNSATISFIED_MSG_ID
, RUL.UNSATISFIED_MSG_SOURCE
, RUL.SEEDED_FLAG
, RUL.INVALID_FLAG
, RUL.DISABLED_FLAG
, RUL.EFFECTIVE_FROM
, RUL.EFFECTIVE_UNTIL
, RUL.EFFECTIVE_USAGE_MASK
, RUL.EFFECTIVITY_SET_ID
, RUL.CHECKOUT_USER
, RUL.ORIG_SYS_REF
, RUL.CREATION_DATE
, RUL.LAST_UPDATE_DATE
, RUL.CREATED_BY
, RUL.LAST_UPDATED_BY
, RUL.LAST_UPDATE_LOGIN
, RUL.RULE_CLASS
, RUL.CLASS_SEQ
, EXN.EXPR_NODE_ID
, EXN.EXPR_TYPE
FROM CZ_RULES RUL
, ( SELECT 200 AS RULE_TYPE
, 1 AS PRESENTATION_FLAG
, INEXP.RULE_ID
, INEXP.TEMPLATE_ID
, INEXP.EXPR_NODE_ID
, INEXP.EXPR_TYPE
, 200 AS RULETYPECLASS
FROM CZ_EXPRESSION_NODES INEXP
WHERE INEXP.EXPR_PARENT_ID IS NULL
AND INEXP.EXPR_TYPE != 208
AND INEXP.DELETED_FLAG = '0' ) EXN
WHERE EXN.RULE_TYPE (+) = RUL.RULE_TYPE
AND EXN.RULE_ID (+) = RUL.RULE_ID
AND EXN.PRESENTATION_FLAG (+) = RUL.PRESENTATION_FLAG
AND RUL.DELETED_FLAG = '0'