View: CZ_NODE_NO_PROPERTIES_V

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

View Text

SELECT -1 AS PROP_ID
, ' ' AS NAME
, PSN.PS_NODE_ID AS PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '1' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '-1' AS PROPERTY_TYPE
FROM CZ_RUL_TYPEDPSN_V PSN
, CZ_CONVERSION_RELS_V CNV
WHERE CNV.OBJECT_TYPE = PSN.DETAILED_TYPE_ID

Columns