VIEW: APPS.CZ_PSN_TYPED_RULE_REFS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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