View: CZ_RULE_EXPRDETLS_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_RULE_EXPRDETLS_V

View Text

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'

Columns