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