View: CZ_NODE_USER_PROPERTIES_V

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

View Text

SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_PS_PROP_VALS PSVAL
, CZ_TYPE_RELATIONSHIPS CNV
WHERE PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_ID = PSVAL.PS_NODE_ID
AND PSVAL.DELETED_FLAG = '0'
AND PSVAL.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_PS_PROP_VALS PSVAL
, CZ_TYPE_RELATIONSHIPS CNV
WHERE PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_TYPE = 263
AND PSN.REFERENCE_ID = PSVAL.PS_NODE_ID
AND PSVAL.DELETED_FLAG = '0'
AND PSVAL.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_TYPE_RELATIONSHIPS CNV
, CZ_ITEM_MASTERS ITM
, CZ_ITEM_TYPE_PROPERTIES ITP
WHERE PSN.DELETED_FLAG = '0'
AND PSN.ITEM_ID = ITM.ITEM_ID
AND ITM.DELETED_FLAG = '0'
AND ITM.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
AND ITP.DELETED_FLAG = '0'
AND ITP.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, REFND.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES REFND
, CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_TYPE_RELATIONSHIPS CNV
, CZ_ITEM_MASTERS ITM
, CZ_ITEM_TYPE_PROPERTIES ITP
WHERE REFND.DELETED_FLAG = '0'
AND REFND.REFERENCE_ID = PSN.PS_NODE_ID
AND PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_TYPE = 263
AND PSN.ITEM_ID = ITM.ITEM_ID
AND ITM.DELETED_FLAG = '0'
AND ITM.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
AND ITP.DELETED_FLAG = '0'
AND ITP.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0'

Columns