VIEW: APPS.CZ_NODE_JAVA_PROPERTIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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