View: CZ_NODE_JAVA_PROPERTIES_V

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

View Text

SELECT PROP_ID
, NAME
, PS_NODE_ID
, DATA_TYPE
, MUTABLE_FLAG
, COLLECTION_FLAG
, PROPERTY_TYPE
FROM ( SELECT LOV.PROP_ID
, LOV.NAME
, LOV.PS_NODE_ID
, LOV.DATA_TYPE
, LOV.MUTABLE_FLAG
, LOV.COLLECTION_FLAG
, LOV.PROPERTY_TYPE
, 0 AS SEQ
FROM CZ_NODE_NO_PROPERTIES_V LOV UNION ALL SELECT DISTINCT SYS.RULE_ID AS PROP_ID
, CONCAT(SYS.NAME
, '()') AS NAME
, PSN.PS_NODE_ID AS PS_NODE_ID
, CNV2.SUBJECT_TYPE AS DATA_TYPE
, SYS.MUTABLE_FLAG AS MUTABLE_FLAG
, SYS.COLLECTION_FLAG AS COLLECTION_FLAG
, '1' AS PROPERTY_TYPE
, 1 AS SEQ
FROM CZ_RUL_TYPEDPSN_V PSN
, CZ_CONVERSION_RELS_V CNV
, CZ_SYSTEM_PROPERTY_RELS_V REL
, CZ_SYSTEM_PROPERTIES_V SYS
, CZ_CONVERSION_RELS_V CNV2
WHERE PSN.DETAILED_TYPE_ID = CNV.OBJECT_TYPE
AND CNV.SUBJECT_TYPE = REL.SUBJECT_TYPE
AND REL.OBJECT_TYPE = SYS.RULE_ID
AND REL.REL_TYPE_CODE = 'JSY'
AND SYS.DATA_TYPE = CNV2.OBJECT_TYPE UNION ALL SELECT LOV.PROP_ID
, LOV.NAME
, LOV.PS_NODE_ID
, LOV.DATA_TYPE
, LOV.MUTABLE_FLAG
, LOV.COLLECTION_FLAG
, LOV.PROPERTY_TYPE
, 3 AS SEQ
FROM CZ_NODE_USER_PROPERTIES_V LOV ) ORDER BY SEQ
, NAME

Columns