VIEW: APPS.CZ_TYPED_RULES_V

Source

View Text - Preformatted

SELECT DETLRULE.RULE_ID, DETLRULE.RULE_TYPE, DETLRULE.DETAILED_RULE_TYPE, DETLRULE.RULETYPE_DATATYPE, DETLRULE.PERSISTENT_RULE_ID, DETLRULE.EXPR_ROOT_RULE_TEMPLATE_ID, RTYV.DATA_VALUE AS RULE_TYPE_CODE, RTYV.VALUE_LABEL AS RULE_TYPE_LABEL, RTYV.VALUE_DESCRIPTION AS RULE_TYPE_DESCRIPTION, DETLRULE.RULE_NAME, DETLRULE.RULE_DESCRIPTION, DETLRULE.DEVL_PROJECT_ID, DETLRULE.RULE_FOLDER_ID, DETLRULE.RULE_FOLDER_TYPE, DETLRULE.SEQ_NBR, DETLRULE.SIGNATURE_ID, DETLRULE.MUTABLE_FLAG, DETLRULE.TEMPLATE_PRIMITIVE_FLAG, DETLRULE.TEMPLATE_TOKEN, DETLRULE.PRESENTATION_FLAG, DETLRULE.RULE_TEXT, DETLRULE.COMPONENT_ID, DETLRULE.MODEL_REF_EXPL_ID, DETLRULE.NOTES, DETLRULE.CLASS_NAME, DETLRULE.INSTANTIATION_SCOPE, DETLRULE.REASON_TYPE, DETLRULE.REASON_ID, DETLRULE.UNSATISFIED_MSG_ID, DETLRULE.UNSATISFIED_MSG_SOURCE, DETLRULE.SEEDED_FLAG, DETLRULE.INVALID_FLAG, DETLRULE.DISABLED_FLAG, DETLRULE.EFFECTIVE_FROM, DETLRULE.EFFECTIVE_UNTIL, DETLRULE.EFFECTIVE_USAGE_MASK, DETLRULE.EFFECTIVITY_SET_ID, DETLRULE.CHECKOUT_USER, DETLRULE.ORIG_SYS_REF, DETLRULE.CREATION_DATE, DETLRULE.LAST_UPDATE_DATE, DETLRULE.CREATED_BY, DETLRULE.LAST_UPDATED_BY, DETLRULE.LAST_UPDATE_LOGIN, DETLRULE.EXPR_NODE_ID, DETLRULE.EXPR_TYPE, DETLRULE.RULE_CLASS, DETLRULE.CLASS_SEQ FROM CZ_DETAILEDRULETYPES_LKV RTYV, CZ_RULE_EXPRDETLS_V DETLRULE WHERE DETLRULE.DETAILED_RULE_TYPE = RTYV.NUMERIC_ID_VALUE(+) order by rule_id

View Text - HTML Formatted

SELECT DETLRULE.RULE_ID
, DETLRULE.RULE_TYPE
, DETLRULE.DETAILED_RULE_TYPE
, DETLRULE.RULETYPE_DATATYPE
, DETLRULE.PERSISTENT_RULE_ID
, DETLRULE.EXPR_ROOT_RULE_TEMPLATE_ID
, RTYV.DATA_VALUE AS RULE_TYPE_CODE
, RTYV.VALUE_LABEL AS RULE_TYPE_LABEL
, RTYV.VALUE_DESCRIPTION AS RULE_TYPE_DESCRIPTION
, DETLRULE.RULE_NAME
, DETLRULE.RULE_DESCRIPTION
, DETLRULE.DEVL_PROJECT_ID
, DETLRULE.RULE_FOLDER_ID
, DETLRULE.RULE_FOLDER_TYPE
, DETLRULE.SEQ_NBR
, DETLRULE.SIGNATURE_ID
, DETLRULE.MUTABLE_FLAG
, DETLRULE.TEMPLATE_PRIMITIVE_FLAG
, DETLRULE.TEMPLATE_TOKEN
, DETLRULE.PRESENTATION_FLAG
, DETLRULE.RULE_TEXT
, DETLRULE.COMPONENT_ID
, DETLRULE.MODEL_REF_EXPL_ID
, DETLRULE.NOTES
, DETLRULE.CLASS_NAME
, DETLRULE.INSTANTIATION_SCOPE
, DETLRULE.REASON_TYPE
, DETLRULE.REASON_ID
, DETLRULE.UNSATISFIED_MSG_ID
, DETLRULE.UNSATISFIED_MSG_SOURCE
, DETLRULE.SEEDED_FLAG
, DETLRULE.INVALID_FLAG
, DETLRULE.DISABLED_FLAG
, DETLRULE.EFFECTIVE_FROM
, DETLRULE.EFFECTIVE_UNTIL
, DETLRULE.EFFECTIVE_USAGE_MASK
, DETLRULE.EFFECTIVITY_SET_ID
, DETLRULE.CHECKOUT_USER
, DETLRULE.ORIG_SYS_REF
, DETLRULE.CREATION_DATE
, DETLRULE.LAST_UPDATE_DATE
, DETLRULE.CREATED_BY
, DETLRULE.LAST_UPDATED_BY
, DETLRULE.LAST_UPDATE_LOGIN
, DETLRULE.EXPR_NODE_ID
, DETLRULE.EXPR_TYPE
, DETLRULE.RULE_CLASS
, DETLRULE.CLASS_SEQ
FROM CZ_DETAILEDRULETYPES_LKV RTYV
, CZ_RULE_EXPRDETLS_V DETLRULE
WHERE DETLRULE.DETAILED_RULE_TYPE = RTYV.NUMERIC_ID_VALUE(+) ORDER BY RULE_ID