View: CZ_NODE_USAGE_IN_RULES_V

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

View Text

SELECT FNC.COMPONENT_ID AS PARTICIPANT_NODE_ID
, FNC.MODEL_REF_EXPL_ID AS PARTICIPANT_EXPL_ID
, FNC.FUNC_COMP_ID AS RULE_ID
, 'FNC_COMP' AS PARTICIPANT_ROLE
FROM CZ_FUNC_COMP_SPECS FNC
WHERE FNC.DELETED_FLAG = '0' UNION ALL SELECT CXR.COMPONENT_ID AS PARTICIPANT_NODE_ID
, CXR.MODEL_REF_EXPL_ID AS PARTICIPANT_EXPL_ID
, CXR.RULE_ID
, 'CXT_COMP' AS PARTICIPANT_ROLE
FROM CZ_RULES CXR
WHERE CXR.DELETED_FLAG = '0'
AND CXR.RULE_TYPE = 300 UNION ALL SELECT EXN.PS_NODE_ID AS PARTICIPANT_NODE_ID
, EXN.MODEL_REF_EXPL_ID AS PARTICIPANT_EXPL_ID
, EXN.RULE_ID
, 'EXN_ARG' AS PARTICIPANT_ROLE
FROM CZ_EXPRESSION_NODES EXN
WHERE EXN.DELETED_FLAG = '0'
AND EXN.PS_NODE_ID IS NOT NULL UNION ALL SELECT DCH2O.SECONDARY_OPT_ID AS PARTICIPANT_NODE_ID
, DCH2O.SECONDARY_FEAT_EXPL_ID AS PARTICIPANT_EXPL_ID
, DCH2O.RULE_ID
, 'DCH_2NDOPT' AS PARTICIPANT_ROLE
FROM CZ_DES_CHART_CELLS DCH2O
WHERE DCH2O.DELETED_FLAG = '0' UNION ALL SELECT DCH_P.PRIMARY_OPT_ID
, DCH_PF.MODEL_REF_EXPL_ID
, DCH_P.RULE_ID
, 'DCH_PRIMOPT' AS PARTICIPANT_ROLE
FROM CZ_DES_CHART_CELLS DCH_P
, CZ_DES_CHART_FEATURES DCH_PF
WHERE DCH_PF.RULE_ID = DCH_P.RULE_ID
AND DCH_P.DELETED_FLAG = '0'
AND DCH_PF.DELETED_FLAG = '0'
AND DCH_PF.FEATURE_TYPE = 5 UNION ALL SELECT DCF.FEATURE_ID
, DCF.MODEL_REF_EXPL_ID
, DCF.RULE_ID
, 'DCH_FEAT_' || TO_CHAR (DCF.FEATURE_TYPE) AS PARTICIPANT_ROLE
FROM CZ_DES_CHART_FEATURES DCF
WHERE DCF.DELETED_FLAG = '0'

Columns