View: CZ_NODE_ALL_PROPERTIES_V

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

View Text

SELECT XP_SY.MODEL_ID
, XP_SY.PARENT_PSNODE_EXPL_ID
, XP_SY.EFFECTIVE_PARENT_ID
, XP_SY.MODEL_REF_EXPL_ID
, XP_SY.PS_NODE_ID
, XP_SY.PS_NODE_TYPE
, XP_SY.DETAILED_TYPE_ID
, XP_SY.ALT_TEXT AS DETAILED_TYPE_LABEL
, XP_SY.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, XP_SY.NAME AS PS_NODE_NAME
, XP_SY.TEXT_STR AS PS_NODE_DESCRIPTION
, SYPR.RULE_TYPE AS PROPERTY_RULE_TYPE
, SYPR.RULE_TYPE_CODE AS PROPERTY_TYPE_CODE
, SYPR.SYS_PROP_RULE_ID AS PROPERTY_ID
, SYPR.SYS_PROP_NAME || '()' AS PROPERTY_NAME
, SYPR.SYS_PROP_RETTYPE_ID AS PROPERTY_DATA_TYPE
, SYPR.SYS_PROP_RETTYPE_NAME AS PROPERTY_DATA_TYPE_NAME
, SYPR.SYS_PROP_RETMUTABLE_FLAG AS PROPERTY_MUTABLE_FLAG
, SYPR.SYS_PROP_RETCOLL_FLAG AS PROPERTY_COLLECTION_FLAG
, REQTYP.SIGNATURE_ID AS DATA_TYPE_ID
, REQTYP.NAME AS DATA_TYPE_NAME
FROM CZ_SIGNATURES REQTYP
, CZ_TYPE_RELATIONSHIPS XPRCNV
, CZ_EXPLNODES_WITHIMAGES_V XP_SY
, CZ_SIGNATURE_SYSPROPS_V SYPR
WHERE REQTYP.DELETED_FLAG = '0'
AND REQTYP.SIGNATURE_ID = XPRCNV.SUBJECT_TYPE
AND XPRCNV.REL_TYPE_CODE = 'CNV'
AND XPRCNV.DELETED_FLAG = '0'
AND XPRCNV.OBJECT_TYPE = SYPR.SYS_PROP_RETTYPE_ID
AND XP_SY.DETAILED_TYPE_ID = SYPR.DETAILED_SIGNATURE_ID
AND SYPR.P_MODEL_ID = XP_SY.MODEL_ID UNION ALL SELECT XP_PR.MODEL_ID
, XP_PR.PARENT_PSNODE_EXPL_ID
, XP_PR.EFFECTIVE_PARENT_ID
, XP_PR.MODEL_REF_EXPL_ID
, XP_PR.PS_NODE_ID
, XP_PR.PS_NODE_TYPE
, XP_PR.DETAILED_TYPE_ID
, XP_PR.ALT_TEXT AS DETAILED_TYPE_LABEL
, XP_PR.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, XP_PR.NAME AS PS_NODE_NAME
, XP_PR.TEXT_STR AS PS_NODE_DESCRIPTION
, -1 AS PROPERTY_RULE_TYPE
, 'PRP' AS PROPERTY_TYPE_CODE
, UPRP.PROPERTY_ID
, UPRP.NAME AS PROPERTY_NAME
, UPRP.DATA_TYPE AS PROPERTY_DATA_TYPE
, PRSIG.NAME AS PROPERTY_DATA_TYPE_NAME
, '0' AS PROPERTY_MUTABLE_FLAG
, '0' AS PROPERTY_COLLECTION_FLAG
, UPREQ.SIGNATURE_ID AS DATA_TYPE_ID
, UPREQ.NAME AS DATA_TYPE_NAME
FROM CZ_EXPLNODES_WITHIMAGES_V XP_PR
, ( SELECT PS_NODE_ID
, PROPERTY_ID
FROM CZ_PS_PROP_VALS PSP
WHERE DELETED_FLAG = '0' UNION SELECT PSND.PS_NODE_ID
, ITYPR.PROPERTY_ID
FROM CZ_ITEM_TYPE_PROPERTIES ITYPR
, CZ_ITEM_MASTERS ITM
, CZ_PS_NODES PSND
WHERE ITYPR.DELETED_FLAG = '0'
AND ITYPR.ITEM_TYPE_ID = ITM.ITEM_TYPE_ID
AND ITM.DELETED_FLAG = '0'
AND PSND.ITEM_ID = ITM.ITEM_ID
AND PSND.DELETED_FLAG = '0' UNION SELECT PS.PS_NODE_ID
, PROPERTY_ID
FROM CZ_PS_PROP_VALS PSP
, CZ_PS_NODES PS
WHERE PSP.DELETED_FLAG = '0'
AND PSP.PS_NODE_ID = PS.REFERENCE_ID
AND PS.PS_NODE_TYPE = 263
AND PS.DELETED_FLAG = '0' UNION SELECT REFN.PS_NODE_ID
, RITP.PROPERTY_ID
FROM CZ_ITEM_TYPE_PROPERTIES RITP
, CZ_ITEM_MASTERS RNI
, CZ_PS_NODES RTND
, CZ_PS_NODES REFN
WHERE REFN.DELETED_FLAG = '0'
AND REFN.REFERENCE_ID = RTND.PS_NODE_ID
AND REFN.PS_NODE_TYPE = 263
AND RITP.DELETED_FLAG = '0'
AND RITP.ITEM_TYPE_ID = RNI.ITEM_TYPE_ID
AND RNI.DELETED_FLAG = '0'
AND RTND.ITEM_ID = RNI.ITEM_ID
AND RTND.DELETED_FLAG = '0' ) NDPROP
, CZ_PROPERTIES UPRP
, CZ_SIGNATURES PRSIG
, CZ_TYPE_RELATIONSHIPS PRCNV
, CZ_SIGNATURES UPREQ
WHERE XP_PR.PS_NODE_ID = NDPROP.PS_NODE_ID
AND NDPROP.PROPERTY_ID = UPRP.PROPERTY_ID
AND UPRP.DELETED_FLAG = '0'
AND UPRP.DATA_TYPE = PRSIG.SIGNATURE_ID
AND PRSIG.DELETED_FLAG = '0'
AND UPRP.DATA_TYPE = PRCNV.OBJECT_TYPE
AND PRCNV.REL_TYPE_CODE = 'CNV'
AND PRCNV.DELETED_FLAG = '0'
AND UPREQ.SIGNATURE_ID = PRCNV.SUBJECT_TYPE
AND UPREQ.DELETED_FLAG = '0' UNION ALL SELECT EMPTXP.MODEL_ID
, EMPTXP.PARENT_PSNODE_EXPL_ID
, EMPTXP.EFFECTIVE_PARENT_ID
, EMPTXP.MODEL_REF_EXPL_ID
, EMPTXP.PS_NODE_ID
, EMPTXP.PS_NODE_TYPE
, EMPTXP.DETAILED_TYPE_ID
, EMPTXP.ALT_TEXT AS DETAILED_TYPE_LABEL
, EMPTXP.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, EMPTXP.NAME AS PS_NODE_NAME
, EMPTXP.TEXT_STR AS PS_NODE_DESCRIPTION
, -1 AS PROPERTY_RULE_TYPE
, 'NUL' AS PROPERTY_TYPE_CODE
, -1 AS PROPERTY_ID
, TO_CHAR (NULL) AS PROPERTY_NAME
, EMPTXP.DETAILED_TYPE_ID AS PROPERTY_DATA_TYPE
, EMPTXP.PSNODETYPE_NAME AS PROPERTY_DATA_TYPE_NAME
, '1' AS PROPERTY_MUTABLE_FLAG
, '0' AS PROPERTY_COLLECTION_FLAG
, VSIG.SIGNATURE_ID AS DATA_TYPE_ID
, VSIG.NAME AS DATA_TYPE_NAME
FROM CZ_EXPLNODES_WITHIMAGES_V EMPTXP
, CZ_TYPE_RELATIONSHIPS EMPCNV
, CZ_SIGNATURES VSIG
WHERE EMPTXP.DETAILED_TYPE_ID = EMPCNV.OBJECT_TYPE
AND EMPCNV.REL_TYPE_CODE = 'CNV'
AND EMPCNV.DELETED_FLAG = '0'
AND EMPCNV.SUBJECT_TYPE = VSIG.SIGNATURE_ID

Columns