View: CZ_PSNODE_RULE_REFS_V

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

View Text

SELECT EXND.MODEL_ID
, EXND.MODEL_REF_EXPL_ID
, EXND.PS_NODE_ID
, EXND.DEVL_PROJECT_ID AS PSN_MODEL_ID
, EXND.PSN_PS_NODE_TYPE
, EXND.PARENT_ID
, EXND.NAME AS PS_NODE_NAME
, RUL.DEVL_PROJECT_ID AS RULE_DEVL_PROJECT_ID
, DECODE (RUL.DEVL_PROJECT_ID
, EXND.MODEL_ID
, '0'
, '1') AS REFERENCED_RULE_FLAG
, DECODE (RUL.DEVL_PROJECT_ID
, EXND.DEVL_PROJECT_ID
, '1'
, '0') AS RULE_IN_ENCLOSING_MODEL_FLAG
, RUL.RULE_ID
, RUL.RULE_FOLDER_ID
, RUL.RULE_FOLDER_TYPE
, RUL.NAME AS RULE_NAME
, RUL.RULE_TYPE
, ( SELECT RDTLV.VALUE_LABEL
FROM CZ_DETAILEDRULETYPES_LKV RDTLV
WHERE RDTLV.NUMERIC_ID_VALUE = RPART.DETAILED_RULE_TYPE ) AS RULE_TYPE_STRING
, RUL.DESC_TEXT
, RUL.DISABLED_FLAG
, EXND.PARENT_PSNODE_EXPL_ID
, EXND.EFFECTIVE_PARENT_ID
, CHXPL.MODEL_REF_EXPL_ID AS DESCENDANT_EXPL_NODE_ID
, RPART.DETAILED_RULE_TYPE
, RPART.PARTICIPANT_ROLE_LIST
, RUL.UNSATISFIED_MSG_SOURCE
, RUL.REASON_ID
, RUL.INVALID_FLAG
, RUL.COMPONENT_ID
, RPART.MODEL_REF_EXPL_ID AS RULE_EXPL_NODE_ID
, RUL.REASON_TYPE
, RUL.ORIG_SYS_REF
, RUL.CHECKOUT_USER
, ( SELECT RRFL.TREE_SEQ
FROM CZ_RULE_FOLDERS RRFL
WHERE RRFL.OBJECT_TYPE NOT IN ('RSQ'
, 'RFL'
, 'FNC')
AND RRFL.RULE_FOLDER_ID = RUL.RULE_ID ) AS SEQ_NBR
, RUL.EFFECTIVITY_SET_ID
, RUL.EFFECTIVE_FROM
, RUL.EFFECTIVE_UNTIL
, RUL.EFFECTIVE_USAGE_MASK
, RUL.PERSISTENT_RULE_ID
, RUL.UNSATISFIED_MSG_ID
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.PRESENTATION_FLAG
, RUL.SIGNATURE_ID
, RUL.MUTABLE_FLAG
, RUL.TEMPLATE_TOKEN
, RUL.RULE_TEXT
, RUL.NOTES
, RUL.CLASS_NAME
, RUL.INSTANTIATION_SCOPE
, RUL.SEEDED_FLAG
FROM CZ_RULES RUL
, CZ_RULE_PARTICIPANTS_V RPART
, CZ_EXPLMODEL_NODES_V EXND
, CZ_MODEL_REF_EXPLS CHXPL
WHERE RUL.RULE_ID = RPART.RULE_ID
AND RUL.DELETED_FLAG = '0'
AND RPART.PARTICIPANT_EXPL_ID = CHXPL.MODEL_REF_EXPL_ID
AND RPART.PARTICIPANT_NODE_ID = EXND.PS_NODE_ID
AND CHXPL.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1
FROM CZ_MODEL_REF_EXPLS FINDXPL
WHERE FINDXPL.MODEL_REF_EXPL_ID = CHXPL.MODEL_REF_EXPL_ID START WITH FINDXPL.MODEL_REF_EXPL_ID = EXND.MODEL_REF_EXPL_ID CONNECT BY FINDXPL.MODEL_REF_EXPL_ID = PRIOR FINDXPL.CHILD_MODEL_EXPL_ID
AND FINDXPL.DELETED_FLAG = '0' ) UNION ALL SELECT EXNDF.MODEL_ID
, EXNDF.MODEL_REF_EXPL_ID
, EXNDF.PS_NODE_ID
, EXNDF.DEVL_PROJECT_ID AS PSN_MODEL_ID
, EXNDF.PSN_PS_NODE_TYPE
, EXNDF.PARENT_ID
, EXNDF.NAME AS PS_NODE_NAME
, FNC.DEVL_PROJECT_ID AS RULE_DEVL_PROJECT_ID
, DECODE (FNC.DEVL_PROJECT_ID
, EXNDF.MODEL_ID
, '0'
, '1') AS REFERENCED_RULE_FLAG
, DECODE (FNC.DEVL_PROJECT_ID
, EXNDF.DEVL_PROJECT_ID
, '1'
, '0') AS RULE_IN_ENCLOSING_MODEL_FLAG
, FNC.FUNC_COMP_ID AS RULE_ID
, FNC.RULE_FOLDER_ID
, FNC.RULE_FOLDER_TYPE
, FNC.NAME AS RULE_NAME
, 29 AS RULE_TYPE
, ( SELECT RDTLV.VALUE_LABEL
FROM CZ_DETAILEDRULETYPES_LKV RDTLV
WHERE RDTLV.NUMERIC_ID_VALUE = 29 ) AS RULE_TYPE_STRING
, FNC.DESC_TEXT
, '0' AS DISABLED_FLAG
, EXNDF.PARENT_PSNODE_EXPL_ID
, EXNDF.EFFECTIVE_PARENT_ID
, CHXPLF.MODEL_REF_EXPL_ID AS DESCENDANT_EXPL_NODE_ID
, FPART.DETAILED_RULE_TYPE
, FPART.PARTICIPANT_ROLE_LIST
, '1' AS UNSATISFIED_MSG_SOURCE
, TO_NUMBER (NULL) AS REASON_ID
, '0' AS INVALID_FLAG
, FNC.COMPONENT_ID
, FNC.MODEL_REF_EXPL_ID AS RULE_EXPL_NODE_ID
, 0 AS REASON_TYPE
, '' AS ORIG_SYS_REF
, FNC.CHECKOUT_USER
, ( SELECT RRFL.TREE_SEQ
FROM CZ_RULE_FOLDERS RRFL
WHERE RRFL.OBJECT_TYPE = 'FNC'
AND RRFL.RULE_FOLDER_ID = FNC.FUNC_COMP_ID ) AS SEQ_NBR
, TO_NUMBER (NULL) AS EFFECTIVITY_SET_ID
, CZ_UTILS.EPOCH_BEGIN AS EFFECTIVE_FROM
, CZ_UTILS.EPOCH_END AS EFFECTIVE_UNTIL
, '0000000000000000' AS EFFECTIVE_USAGE_MASK
, FNC.FUNC_COMP_ID AS PERSISTENT_RULE_ID
, TO_NUMBER (NULL) AS UNSATISFIED_MSG_ID
, '0' AS TEMPLATE_PRIMITIVE_FLAG
, '' AS PRESENTATION_FLAG
, TO_NUMBER (NULL) AS SIGNATURE_ID
, '0' AS MUTABLE_FLAG
, '' AS TEMPLATE_TOKEN
, EMPTY_CLOB () AS RULE_TEXT
, EMPTY_CLOB () AS NOTES
, FNC.PROGRAM_STRING AS CLASS_NAME
, TO_NUMBER (NULL) AS INSTANTIATION_SCOPE
, '0' AS SEEDED_FLAG
FROM CZ_FUNC_COMP_SPECS FNC
, CZ_RULE_PARTICIPANTS_V FPART
, CZ_EXPLMODEL_NODES_V EXNDF
, CZ_MODEL_REF_EXPLS CHXPLF
WHERE FNC.FUNC_COMP_ID = FPART.RULE_ID
AND FNC.DELETED_FLAG = '0'
AND FPART.PARTICIPANT_EXPL_ID = CHXPLF.MODEL_REF_EXPL_ID
AND FPART.PARTICIPANT_NODE_ID = EXNDF.PS_NODE_ID
AND CHXPLF.DELETED_FLAG = '0'
AND EXISTS ( SELECT 1
FROM CZ_MODEL_REF_EXPLS FINDXPLF
WHERE FINDXPLF.MODEL_REF_EXPL_ID = CHXPLF.MODEL_REF_EXPL_ID START WITH FINDXPLF.MODEL_REF_EXPL_ID = EXNDF.MODEL_REF_EXPL_ID CONNECT BY FINDXPLF.MODEL_REF_EXPL_ID = PRIOR FINDXPLF.CHILD_MODEL_EXPL_ID
AND FINDXPLF.DELETED_FLAG = '0' )

Columns