VIEW: APPS.CZ_EXPLNODES_VALUES_EFF_CV

Source

View Text - Preformatted

SELECT nodes.EFFECTIVITY_FILTER, nodes.PS_NODE_ID, nodes.NAME, nodes.PARENT_ID, nodes.INITIAL_VALUE, nodes.MINIMUM, nodes.MAXIMUM, nodes.PS_NODE_TYPE, nodes.FEATURE_TYPE, nodes.REFERENCE_ID, nodes.MINIMUM_SELECTED, nodes.MAXIMUM_SELECTED, nodes.PSN_CREATION_DATE, nodes.PSN_LAST_UPDATE_DATE, nodes.EFFECTIVE_USAGE_MASK, nodes.EFFECTIVE_FROM, nodes.EFFECTIVE_UNTIL, nodes.EFFECTIVITY_SET_ID, nodes.UI_OMIT, nodes.TREE_SEQ, nodes.Devl_project_id, nodes.INTL_TEXT_ID, nodes.TEXT_STR, nodes.child_model_expl_id, nodes.model_ref_expl_id, nodes.model_id, nodes.parent_expl_node_id, nodes.psn_component_id, nodes.xpl_virtual_flag, nodes.node_depth, nodes.effective_parent_id, nodes.PARENT_PSNODE_EXPL_ID, nodes.full_image_path, nodes.alt_text, nodes.detailed_type_id, ( select 1 - count (*) as no_value from dual where exists ( select 1 from cz_psnode_propval_v uprp, cz_type_relationships up_cnv where up_cnv.deleted_flag = '0' and up_cnv.rel_type_code = 'CNV' and up_cnv.subject_type = pdts.signature_id and up_cnv.object_type = uprp.data_type and uprp.ps_node_id = nodes.ps_node_id and mut.mflag = '0' and coll.cflag >= '0' union all select 1 from cz_type_relationships nd_cnv where nd_cnv.deleted_flag = '0' and nd_cnv.rel_type_code = 'CNV' and nd_cnv.subject_type = pdts.signature_id and nd_cnv.object_type = nodes.detailed_type_id and mut.mflag <= '1' and coll.cflag >= '0' union all select 1 from cz_system_properties_v sysp, cz_type_relationships sprel, cz_type_relationships ndcnv, cz_type_relationships retcnv where retcnv.deleted_flag = '0' and retcnv.rel_type_code = 'CNV' and retcnv.subject_type = pdts.signature_id and retcnv.object_type = sysp.data_type and ndcnv.object_type = nodes.DETAILED_TYPE_ID and ndcnv.deleted_flag = '0' and ndcnv.rel_type_code = 'CNV' and ndcnv.subject_type = sprel.subject_type and sprel.rel_type_code = 'SYS' and sprel.deleted_flag = '0' and sprel.object_type = sysp.rule_id and sysp.rule_type = sysprop.sptype and mut.mflag <= sysp.mutable_flag and coll.cflag >= sysp.collection_flag ) ) as node_disabled_flag, pdts.signature_id as P_data_type, coll.cflag as P_collection_flag, mut.mflag as P_mutable_flag, sysprop.sptype as P_sysprop_ruletype from cz_explnodes_image_eff_v nodes, cz_signatures pdts, ( select '0' as cflag from dual union all select '1' as cflag from dual ) coll, ( select '0' as mflag from dual union all select '1' as mflag from dual ) mut, ( select 500 as sptype from dual union all select 501 as sptype from dual union all select -1 as sptype from dual) sysprop WHERE pdts.signature_type = 'PDT' and pdts.deleted_flag = '0' and nodes.suppress_flag = '0'

View Text - HTML Formatted

SELECT NODES.EFFECTIVITY_FILTER
, NODES.PS_NODE_ID
, NODES.NAME
, NODES.PARENT_ID
, NODES.INITIAL_VALUE
, NODES.MINIMUM
, NODES.MAXIMUM
, NODES.PS_NODE_TYPE
, NODES.FEATURE_TYPE
, NODES.REFERENCE_ID
, NODES.MINIMUM_SELECTED
, NODES.MAXIMUM_SELECTED
, NODES.PSN_CREATION_DATE
, NODES.PSN_LAST_UPDATE_DATE
, NODES.EFFECTIVE_USAGE_MASK
, NODES.EFFECTIVE_FROM
, NODES.EFFECTIVE_UNTIL
, NODES.EFFECTIVITY_SET_ID
, NODES.UI_OMIT
, NODES.TREE_SEQ
, NODES.DEVL_PROJECT_ID
, NODES.INTL_TEXT_ID
, NODES.TEXT_STR
, NODES.CHILD_MODEL_EXPL_ID
, NODES.MODEL_REF_EXPL_ID
, NODES.MODEL_ID
, NODES.PARENT_EXPL_NODE_ID
, NODES.PSN_COMPONENT_ID
, NODES.XPL_VIRTUAL_FLAG
, NODES.NODE_DEPTH
, NODES.EFFECTIVE_PARENT_ID
, NODES.PARENT_PSNODE_EXPL_ID
, NODES.FULL_IMAGE_PATH
, NODES.ALT_TEXT
, NODES.DETAILED_TYPE_ID
, ( SELECT 1 - COUNT (*) AS NO_VALUE
FROM DUAL
WHERE EXISTS ( SELECT 1
FROM CZ_PSNODE_PROPVAL_V UPRP
, CZ_TYPE_RELATIONSHIPS UP_CNV
WHERE UP_CNV.DELETED_FLAG = '0'
AND UP_CNV.REL_TYPE_CODE = 'CNV'
AND UP_CNV.SUBJECT_TYPE = PDTS.SIGNATURE_ID
AND UP_CNV.OBJECT_TYPE = UPRP.DATA_TYPE
AND UPRP.PS_NODE_ID = NODES.PS_NODE_ID
AND MUT.MFLAG = '0'
AND COLL.CFLAG >= '0' UNION ALL SELECT 1
FROM CZ_TYPE_RELATIONSHIPS ND_CNV
WHERE ND_CNV.DELETED_FLAG = '0'
AND ND_CNV.REL_TYPE_CODE = 'CNV'
AND ND_CNV.SUBJECT_TYPE = PDTS.SIGNATURE_ID
AND ND_CNV.OBJECT_TYPE = NODES.DETAILED_TYPE_ID
AND MUT.MFLAG <= '1'
AND COLL.CFLAG >= '0' UNION ALL SELECT 1
FROM CZ_SYSTEM_PROPERTIES_V SYSP
, CZ_TYPE_RELATIONSHIPS SPREL
, CZ_TYPE_RELATIONSHIPS NDCNV
, CZ_TYPE_RELATIONSHIPS RETCNV
WHERE RETCNV.DELETED_FLAG = '0'
AND RETCNV.REL_TYPE_CODE = 'CNV'
AND RETCNV.SUBJECT_TYPE = PDTS.SIGNATURE_ID
AND RETCNV.OBJECT_TYPE = SYSP.DATA_TYPE
AND NDCNV.OBJECT_TYPE = NODES.DETAILED_TYPE_ID
AND NDCNV.DELETED_FLAG = '0'
AND NDCNV.REL_TYPE_CODE = 'CNV'
AND NDCNV.SUBJECT_TYPE = SPREL.SUBJECT_TYPE
AND SPREL.REL_TYPE_CODE = 'SYS'
AND SPREL.DELETED_FLAG = '0'
AND SPREL.OBJECT_TYPE = SYSP.RULE_ID
AND SYSP.RULE_TYPE = SYSPROP.SPTYPE
AND MUT.MFLAG <= SYSP.MUTABLE_FLAG
AND COLL.CFLAG >= SYSP.COLLECTION_FLAG ) ) AS NODE_DISABLED_FLAG
, PDTS.SIGNATURE_ID AS P_DATA_TYPE
, COLL.CFLAG AS P_COLLECTION_FLAG
, MUT.MFLAG AS P_MUTABLE_FLAG
, SYSPROP.SPTYPE AS P_SYSPROP_RULETYPE
FROM CZ_EXPLNODES_IMAGE_EFF_V NODES
, CZ_SIGNATURES PDTS
, ( SELECT '0' AS CFLAG
FROM DUAL UNION ALL SELECT '1' AS CFLAG
FROM DUAL ) COLL
, ( SELECT '0' AS MFLAG
FROM DUAL UNION ALL SELECT '1' AS MFLAG
FROM DUAL ) MUT
, ( SELECT 500 AS SPTYPE
FROM DUAL UNION ALL SELECT 501 AS SPTYPE
FROM DUAL UNION ALL SELECT -1 AS SPTYPE
FROM DUAL) SYSPROP
WHERE PDTS.SIGNATURE_TYPE = 'PDT'
AND PDTS.DELETED_FLAG = '0'
AND NODES.SUPPRESS_FLAG = '0'