VIEW: APPS.CZ_EXPLNODES_AVAILVALUES_CV

Source

View Text - Preformatted

SELECT 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 = sysprop.sptypename 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_withimages_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,'SYS' AS sptypename FROM dual UNION ALL SELECT 501 AS sptype,'JSY' AS sptypename FROM dual UNION ALL SELECT -1 AS sptype,'' AS sptypename FROM dual ) sysprop WHERE pdts.signature_type = 'PDT' AND pdts.deleted_flag = '0' AND nodes.suppress_flag = '0'

View Text - HTML Formatted

SELECT 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 = SYSPROP.SPTYPENAME
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_WITHIMAGES_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
, 'SYS' AS SPTYPENAME
FROM DUAL UNION ALL SELECT 501 AS SPTYPE
, 'JSY' AS SPTYPENAME
FROM DUAL UNION ALL SELECT -1 AS SPTYPE
, '' AS SPTYPENAME
FROM DUAL ) SYSPROP
WHERE PDTS.SIGNATURE_TYPE = 'PDT'
AND PDTS.DELETED_FLAG = '0'
AND NODES.SUPPRESS_FLAG = '0'