VIEW: APPS.CZ_NODE_USAGE_IN_RULES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'