VIEW: APPS.CZ_NODE_USER_PROPERTIES_V

Source

View Text - Preformatted

SELECT prp.property_id as prop_id, prp.name, psn.ps_node_id, cnv.subject_type as data_type, '0' as mutable_flag, '0' as collection_flag, '2' as property_type, '2006-01-12' as viewrev from cz_ps_nodes psn, cz_properties prp, cz_ps_prop_vals psval, cz_type_relationships cnv WHERE psn.deleted_flag = '0' and psn.ps_node_id = psval.ps_node_id and psval.deleted_flag = '0' and psval.property_id = prp.property_id and prp.deleted_flag = '0' and prp.data_type = cnv.object_type and cnv.rel_type_code = 'CNV' and cnv.deleted_flag = '0' union select prp.property_id as prop_id, prp.name, psn.ps_node_id, cnv.subject_type as data_type, '0' as mutable_flag, '0' as collection_flag, '2' as property_type, '2006-01-12' as viewrev from cz_ps_nodes psn, cz_properties prp, cz_ps_prop_vals psval, cz_type_relationships cnv where psn.deleted_flag = '0' and psn.ps_node_type = 263 and psn.reference_id = psval.ps_node_id and psval.deleted_flag = '0' and psval.property_id = prp.property_id and prp.deleted_flag = '0' and prp.data_type = cnv.object_type and cnv.rel_type_code = 'CNV' and cnv.deleted_flag = '0' union select prp.property_id as prop_id, prp.name, psn.ps_node_id, cnv.subject_type as data_type, '0' as mutable_flag, '0' as collection_flag, '2' as property_type, '2006-01-12' as viewrev from cz_ps_nodes psn, cz_properties prp, cz_type_relationships cnv, cz_item_masters itm, cz_item_type_properties itp where psn.deleted_flag = '0' and psn.item_id = itm.item_id and itm.deleted_flag = '0' and itm.item_type_id = itp.item_type_id and itp.deleted_flag = '0' and itp.property_id = prp.property_id and prp.deleted_flag = '0' and prp.data_type = cnv.object_type and cnv.rel_type_code = 'CNV' and cnv.deleted_flag = '0' union select prp.property_id as prop_id, prp.name, refnd.ps_node_id, cnv.subject_type as data_type, '0' as mutable_flag, '0' as collection_flag, '2' as property_type, '2006-01-12' as viewrev from cz_ps_nodes refnd, cz_ps_nodes psn, cz_properties prp, cz_type_relationships cnv, cz_item_masters itm, cz_item_type_properties itp where refnd.deleted_flag = '0' and refnd.reference_id = psn.ps_node_id and psn.deleted_flag = '0' and psn.ps_node_type = 263 and psn.item_id = itm.item_id and itm.deleted_flag = '0' and itm.item_type_id = itp.item_type_id and itp.deleted_flag = '0' and itp.property_id = prp.property_id and prp.deleted_flag = '0' and prp.data_type = cnv.object_type and cnv.rel_type_code = 'CNV' and cnv.deleted_flag = '0'

View Text - HTML Formatted

SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_PS_PROP_VALS PSVAL
, CZ_TYPE_RELATIONSHIPS CNV
WHERE PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_ID = PSVAL.PS_NODE_ID
AND PSVAL.DELETED_FLAG = '0'
AND PSVAL.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_PS_PROP_VALS PSVAL
, CZ_TYPE_RELATIONSHIPS CNV
WHERE PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_TYPE = 263
AND PSN.REFERENCE_ID = PSVAL.PS_NODE_ID
AND PSVAL.DELETED_FLAG = '0'
AND PSVAL.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, PSN.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_TYPE_RELATIONSHIPS CNV
, CZ_ITEM_MASTERS ITM
, CZ_ITEM_TYPE_PROPERTIES ITP
WHERE PSN.DELETED_FLAG = '0'
AND PSN.ITEM_ID = ITM.ITEM_ID
AND ITM.DELETED_FLAG = '0'
AND ITM.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
AND ITP.DELETED_FLAG = '0'
AND ITP.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0' UNION SELECT PRP.PROPERTY_ID AS PROP_ID
, PRP.NAME
, REFND.PS_NODE_ID
, CNV.SUBJECT_TYPE AS DATA_TYPE
, '0' AS MUTABLE_FLAG
, '0' AS COLLECTION_FLAG
, '2' AS PROPERTY_TYPE
, '2006-01-12' AS VIEWREV
FROM CZ_PS_NODES REFND
, CZ_PS_NODES PSN
, CZ_PROPERTIES PRP
, CZ_TYPE_RELATIONSHIPS CNV
, CZ_ITEM_MASTERS ITM
, CZ_ITEM_TYPE_PROPERTIES ITP
WHERE REFND.DELETED_FLAG = '0'
AND REFND.REFERENCE_ID = PSN.PS_NODE_ID
AND PSN.DELETED_FLAG = '0'
AND PSN.PS_NODE_TYPE = 263
AND PSN.ITEM_ID = ITM.ITEM_ID
AND ITM.DELETED_FLAG = '0'
AND ITM.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
AND ITP.DELETED_FLAG = '0'
AND ITP.PROPERTY_ID = PRP.PROPERTY_ID
AND PRP.DELETED_FLAG = '0'
AND PRP.DATA_TYPE = CNV.OBJECT_TYPE
AND CNV.REL_TYPE_CODE = 'CNV'
AND CNV.DELETED_FLAG = '0'