View: CZ_COMMON_CHILDND_PROPS_V

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

View Text

SELECT PARENT_ID
, PROPERTY_ID
, PROPERTY_NAME
, DATA_TYPE
FROM (SELECT PSND.PARENT_ID
, PSND.PS_NODE_ID
, PROP.PROPERTY_ID
, PROP.NAME AS PROPERTY_NAME
, PROP.DATA_TYPE
FROM CZ_PROPERTIES PROP
, CZ_PS_PROP_VALS VLUE
, CZ_PS_NODES PSND
WHERE PROP.DELETED_FLAG = '0'
AND VLUE.DELETED_FLAG = '0'
AND PSND.DELETED_FLAG = '0'
AND PROP.PROPERTY_ID = VLUE.PROPERTY_ID
AND VLUE.PS_NODE_ID = PSND.PS_NODE_ID UNION SELECT PREF.PARENT_ID
, PREF.PS_NODE_ID
, PROP.PROPERTY_ID
, PROP.NAME AS PROPERTY_NAME
, PROP.DATA_TYPE
FROM CZ_PROPERTIES PROP
, CZ_PS_PROP_VALS VLUE
, CZ_PS_NODES PSND
, CZ_PS_NODES PREF
WHERE PROP.DELETED_FLAG = '0'
AND VLUE.DELETED_FLAG = '0'
AND PSND.DELETED_FLAG = '0'
AND PREF.DELETED_FLAG = '0'
AND PREF.PS_NODE_TYPE = 263
AND PROP.PROPERTY_ID = VLUE.PROPERTY_ID
AND VLUE.PS_NODE_ID = PSND.PS_NODE_ID
AND PREF.REFERENCE_ID = PSND.PS_NODE_ID UNION SELECT PSND.PARENT_ID
, PSND.PS_NODE_ID
, PROP.PROPERTY_ID
, PROP.NAME AS PROPERTY_NAME
, PROP.DATA_TYPE
FROM CZ_PROPERTIES PROP
, CZ_ITEM_TYPE_PROPERTIES ITPR
, CZ_ITEM_MASTERS ITEM
, CZ_PS_NODES PSND
WHERE PROP.DELETED_FLAG = '0'
AND ITEM.DELETED_FLAG = '0'
AND ITPR.DELETED_FLAG = '0'
AND PSND.DELETED_FLAG = '0'
AND PROP.PROPERTY_ID = ITPR.PROPERTY_ID
AND ITPR.ITEM_TYPE_ID = ITEM.ITEM_TYPE_ID
AND ITEM.ITEM_ID = PSND.ITEM_ID UNION SELECT PREF.PARENT_ID
, PREF.PS_NODE_ID
, PROP.PROPERTY_ID
, PROP.NAME AS PROPERTY_NAME
, PROP.DATA_TYPE
FROM CZ_PROPERTIES PROP
, CZ_ITEM_TYPE_PROPERTIES ITPR
, CZ_ITEM_MASTERS ITEM
, CZ_PS_NODES PSND
, CZ_PS_NODES PREF
WHERE PROP.DELETED_FLAG = '0'
AND ITEM.DELETED_FLAG = '0'
AND ITPR.DELETED_FLAG = '0'
AND PSND.DELETED_FLAG = '0'
AND PREF.DELETED_FLAG = '0'
AND PREF.PS_NODE_TYPE = 263
AND PROP.PROPERTY_ID = ITPR.PROPERTY_ID
AND ITPR.ITEM_TYPE_ID = ITEM.ITEM_TYPE_ID
AND ITEM.ITEM_ID = PSND.ITEM_ID
AND PREF.REFERENCE_ID = PSND.PS_NODE_ID) PRPT
WHERE 1=1 GROUP BY PARENT_ID
, PROPERTY_ID
, PROPERTY_NAME
, DATA_TYPE HAVING COUNT(*) = (SELECT COUNT(*)
FROM CZ_PS_NODES PSN
WHERE PARENT_ID = PRPT.PARENT_ID
AND DELETED_FLAG = '0')

Columns