Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_PSN_TYPED_RULE_REFS_V |
SELECT P2RUL.MODEL_ID
, P2RUL.MODEL_REF_EXPL_ID AS PSN_EXPL_ID
, P2RUL.PSN_MODEL_ID
, P2RUL.REFERENCED_RULE_FLAG
, P2RUL.RULE_IN_ENCLOSING_MODEL_FLAG
, P2RUL.PS_NODE_ID
, P2RUL.PSN_PS_NODE_TYPE
, P2RUL.PARENT_ID
, P2RUL.PS_NODE_NAME
, P2RUL.RULE_DEVL_PROJECT_ID
, P2RUL.RULE_ID
, P2RUL.RULE_FOLDER_ID
, P2RUL.RULE_FOLDER_TYPE
, P2RUL.RULE_NAME
, P2RUL.RULE_TYPE
, P2RUL.DISABLED_FLAG AS RULE_DISABLED_FLAG
, TRUL.DEVL_PROJECT_ID AS RULE_MODEL_ID
, TRUL.DETAILED_RULE_TYPE
, TRUL.RULETYPE_DATATYPE
, TRUL.EXPR_ROOT_RULE_TEMPLATE_ID
, TRUL.RULE_TYPE_CODE
, TRUL.RULE_TYPE_LABEL
, TRUL.RULE_TYPE_DESCRIPTION
, TRUL.PERSISTENT_RULE_ID
, TRUL.RULE_DESCRIPTION
, TRUL.SEQ_NBR AS RULE_SEQ_NBR_IN_FOLDER
, TRUL.SIGNATURE_ID AS RULE_SIGNATURE_ID
, TRUL.MUTABLE_FLAG
, TRUL.TEMPLATE_TOKEN
, TRUL.TEMPLATE_PRIMITIVE_FLAG
, TRUL.PRESENTATION_FLAG
, TRUL.RULE_TEXT
, TRUL.COMPONENT_ID AS RULE_COMPONENT_ID
, TRUL.MODEL_REF_EXPL_ID AS RULE_EXPL_ID
, TRUL.NOTES AS RULE_NOTES
, TRUL.CLASS_NAME
, TRUL.INSTANTIATION_SCOPE
, TRUL.REASON_ID
, TRUL.REASON_TYPE
, TRUL.UNSATISFIED_MSG_ID
, TRUL.UNSATISFIED_MSG_SOURCE
, TRUL.INVALID_FLAG AS RULE_INVALID_FLAG
, TRUL.EFFECTIVE_FROM AS RULE_EFFECTIVE_FROM
, TRUL.EFFECTIVE_UNTIL AS RULE_EFFECTIVE_UNTIL
, TRUL.EFFECTIVE_USAGE_MASK AS RULE_EFFECTIVE_USAGE_MASK
, TRUL.EFFECTIVITY_SET_ID AS RULE_EFFECTIVITY_SET_ID
, TRUL.CHECKOUT_USER AS RULE_CHECKOUT_USER
FROM CZ_PSNODE_RULE_REFS_V P2RUL
, CZ_TYPED_RULES_V TRUL
WHERE P2RUL.RULE_ID = TRUL.RULE_ID