View: CZ_EXPLNODES_VALUES_EFF_CV

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

View Text

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'

Columns