VIEW: APPS.CZ_NODE_NO_PROPERTIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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