VIEW: APPS.CZ_NODE_ALL_PROPERTIES_V

Source

View Text - Preformatted

SELECT xp_sy.model_id, xp_sy.parent_psnode_expl_id, xp_sy.effective_parent_id, xp_sy.model_ref_expl_id, xp_sy.ps_node_id, xp_sy.ps_node_type, xp_sy.detailed_type_id, xp_sy.alt_text AS detailed_type_label, xp_sy.full_image_path AS ps_node_type_image_path, xp_sy.NAME AS ps_node_name, xp_sy.text_str AS ps_node_description, sypr.rule_type AS property_rule_type, sypr.rule_type_code AS property_type_code, sypr.sys_prop_rule_id AS property_id, sypr.sys_prop_name || '()' AS property_name, sypr.sys_prop_rettype_id AS property_data_type, sypr.sys_prop_rettype_name AS property_data_type_name, sypr.sys_prop_retmutable_flag AS property_mutable_flag, sypr.sys_prop_retcoll_flag AS property_collection_flag, reqtyp.signature_id AS data_type_id, reqtyp.NAME AS data_type_name FROM cz_signatures reqtyp, cz_type_relationships xprcnv, cz_explnodes_withimages_v xp_sy, cz_signature_sysprops_v sypr WHERE reqtyp.deleted_flag = '0' AND reqtyp.signature_id = xprcnv.subject_type AND xprcnv.rel_type_code = 'CNV' AND xprcnv.deleted_flag = '0' AND xprcnv.object_type = sypr.sys_prop_rettype_id AND xp_sy.detailed_type_id = sypr.detailed_signature_id AND sypr.p_model_id = xp_sy.model_id UNION ALL SELECT xp_pr.model_id, xp_pr.parent_psnode_expl_id, xp_pr.effective_parent_id, xp_pr.model_ref_expl_id, xp_pr.ps_node_id, xp_pr.ps_node_type, xp_pr.detailed_type_id, xp_pr.alt_text AS detailed_type_label, xp_pr.full_image_path AS ps_node_type_image_path, xp_pr.NAME AS ps_node_name, xp_pr.text_str AS ps_node_description, -1 AS property_rule_type, 'PRP' AS property_type_code, uprp.property_id, uprp.NAME AS property_name, uprp.data_type AS property_data_type, prsig.NAME AS property_data_type_name, '0' AS property_mutable_flag, '0' AS property_collection_flag, upreq.signature_id AS data_type_id, upreq.NAME AS data_type_name FROM cz_explnodes_withimages_v xp_pr, ( SELECT ps_node_id, property_id FROM cz_ps_prop_vals psp WHERE deleted_flag = '0' UNION SELECT psnd.ps_node_id, itypr.property_id FROM cz_item_type_properties itypr, cz_item_masters itm, cz_ps_nodes psnd WHERE itypr.deleted_flag = '0' AND itypr.item_type_id = itm.item_type_id AND itm.deleted_flag = '0' AND psnd.item_id = itm.item_id AND psnd.deleted_flag = '0' UNION SELECT ps.ps_node_id, property_id FROM cz_ps_prop_vals psp, cz_ps_nodes ps where psp.deleted_flag = '0' and psp.ps_node_id = ps.reference_id and ps.ps_node_type = 263 and ps.deleted_flag = '0' UNION SELECT refn.ps_node_id, ritp.property_id FROM cz_item_type_properties ritp, cz_item_masters rni, cz_ps_nodes rtnd, cz_ps_nodes refn WHERE refn.deleted_flag = '0' and refn.reference_id = rtnd.ps_node_id and refn.ps_node_type = 263 and ritp.deleted_flag = '0' AND ritp.item_type_id = rni.item_type_id AND rni.deleted_flag = '0' AND rtnd.item_id = rni.item_id AND rtnd.deleted_flag = '0' ) ndprop, cz_properties uprp, cz_signatures prsig, cz_type_relationships prcnv, cz_signatures upreq WHERE xp_pr.ps_node_id = ndprop.ps_node_id AND ndprop.property_id = uprp.property_id AND uprp.deleted_flag = '0' AND uprp.data_type = prsig.signature_id AND prsig.deleted_flag = '0' AND uprp.data_type = prcnv.object_type AND prcnv.rel_type_code = 'CNV' AND prcnv.deleted_flag = '0' AND upreq.signature_id = prcnv.subject_type AND upreq.deleted_flag = '0' UNION ALL SELECT emptxp.model_id, emptxp.parent_psnode_expl_id, emptxp.effective_parent_id, emptxp.model_ref_expl_id, emptxp.ps_node_id, emptxp.ps_node_type, emptxp.detailed_type_id, emptxp.alt_text AS detailed_type_label, emptxp.full_image_path AS ps_node_type_image_path, emptxp.NAME AS ps_node_name, emptxp.text_str AS ps_node_description, -1 AS property_rule_type, 'NUL' AS property_type_code, -1 AS property_id, TO_CHAR (NULL) AS property_name, emptxp.detailed_type_id AS property_data_type, emptxp.psnodetype_name AS property_data_type_name, '1' AS property_mutable_flag, '0' AS property_collection_flag, vsig.signature_id AS data_type_id, vsig.NAME AS data_type_name FROM cz_explnodes_withimages_v emptxp, cz_type_relationships empcnv, cz_signatures vsig WHERE emptxp.detailed_type_id = empcnv.object_type AND empcnv.rel_type_code = 'CNV' AND empcnv.deleted_flag = '0' AND empcnv.subject_type = vsig.signature_id

View Text - HTML Formatted

SELECT XP_SY.MODEL_ID
, XP_SY.PARENT_PSNODE_EXPL_ID
, XP_SY.EFFECTIVE_PARENT_ID
, XP_SY.MODEL_REF_EXPL_ID
, XP_SY.PS_NODE_ID
, XP_SY.PS_NODE_TYPE
, XP_SY.DETAILED_TYPE_ID
, XP_SY.ALT_TEXT AS DETAILED_TYPE_LABEL
, XP_SY.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, XP_SY.NAME AS PS_NODE_NAME
, XP_SY.TEXT_STR AS PS_NODE_DESCRIPTION
, SYPR.RULE_TYPE AS PROPERTY_RULE_TYPE
, SYPR.RULE_TYPE_CODE AS PROPERTY_TYPE_CODE
, SYPR.SYS_PROP_RULE_ID AS PROPERTY_ID
, SYPR.SYS_PROP_NAME || '()' AS PROPERTY_NAME
, SYPR.SYS_PROP_RETTYPE_ID AS PROPERTY_DATA_TYPE
, SYPR.SYS_PROP_RETTYPE_NAME AS PROPERTY_DATA_TYPE_NAME
, SYPR.SYS_PROP_RETMUTABLE_FLAG AS PROPERTY_MUTABLE_FLAG
, SYPR.SYS_PROP_RETCOLL_FLAG AS PROPERTY_COLLECTION_FLAG
, REQTYP.SIGNATURE_ID AS DATA_TYPE_ID
, REQTYP.NAME AS DATA_TYPE_NAME
FROM CZ_SIGNATURES REQTYP
, CZ_TYPE_RELATIONSHIPS XPRCNV
, CZ_EXPLNODES_WITHIMAGES_V XP_SY
, CZ_SIGNATURE_SYSPROPS_V SYPR
WHERE REQTYP.DELETED_FLAG = '0'
AND REQTYP.SIGNATURE_ID = XPRCNV.SUBJECT_TYPE
AND XPRCNV.REL_TYPE_CODE = 'CNV'
AND XPRCNV.DELETED_FLAG = '0'
AND XPRCNV.OBJECT_TYPE = SYPR.SYS_PROP_RETTYPE_ID
AND XP_SY.DETAILED_TYPE_ID = SYPR.DETAILED_SIGNATURE_ID
AND SYPR.P_MODEL_ID = XP_SY.MODEL_ID UNION ALL SELECT XP_PR.MODEL_ID
, XP_PR.PARENT_PSNODE_EXPL_ID
, XP_PR.EFFECTIVE_PARENT_ID
, XP_PR.MODEL_REF_EXPL_ID
, XP_PR.PS_NODE_ID
, XP_PR.PS_NODE_TYPE
, XP_PR.DETAILED_TYPE_ID
, XP_PR.ALT_TEXT AS DETAILED_TYPE_LABEL
, XP_PR.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, XP_PR.NAME AS PS_NODE_NAME
, XP_PR.TEXT_STR AS PS_NODE_DESCRIPTION
, -1 AS PROPERTY_RULE_TYPE
, 'PRP' AS PROPERTY_TYPE_CODE
, UPRP.PROPERTY_ID
, UPRP.NAME AS PROPERTY_NAME
, UPRP.DATA_TYPE AS PROPERTY_DATA_TYPE
, PRSIG.NAME AS PROPERTY_DATA_TYPE_NAME
, '0' AS PROPERTY_MUTABLE_FLAG
, '0' AS PROPERTY_COLLECTION_FLAG
, UPREQ.SIGNATURE_ID AS DATA_TYPE_ID
, UPREQ.NAME AS DATA_TYPE_NAME
FROM CZ_EXPLNODES_WITHIMAGES_V XP_PR
, ( SELECT PS_NODE_ID
, PROPERTY_ID
FROM CZ_PS_PROP_VALS PSP
WHERE DELETED_FLAG = '0' UNION SELECT PSND.PS_NODE_ID
, ITYPR.PROPERTY_ID
FROM CZ_ITEM_TYPE_PROPERTIES ITYPR
, CZ_ITEM_MASTERS ITM
, CZ_PS_NODES PSND
WHERE ITYPR.DELETED_FLAG = '0'
AND ITYPR.ITEM_TYPE_ID = ITM.ITEM_TYPE_ID
AND ITM.DELETED_FLAG = '0'
AND PSND.ITEM_ID = ITM.ITEM_ID
AND PSND.DELETED_FLAG = '0' UNION SELECT PS.PS_NODE_ID
, PROPERTY_ID
FROM CZ_PS_PROP_VALS PSP
, CZ_PS_NODES PS
WHERE PSP.DELETED_FLAG = '0'
AND PSP.PS_NODE_ID = PS.REFERENCE_ID
AND PS.PS_NODE_TYPE = 263
AND PS.DELETED_FLAG = '0' UNION SELECT REFN.PS_NODE_ID
, RITP.PROPERTY_ID
FROM CZ_ITEM_TYPE_PROPERTIES RITP
, CZ_ITEM_MASTERS RNI
, CZ_PS_NODES RTND
, CZ_PS_NODES REFN
WHERE REFN.DELETED_FLAG = '0'
AND REFN.REFERENCE_ID = RTND.PS_NODE_ID
AND REFN.PS_NODE_TYPE = 263
AND RITP.DELETED_FLAG = '0'
AND RITP.ITEM_TYPE_ID = RNI.ITEM_TYPE_ID
AND RNI.DELETED_FLAG = '0'
AND RTND.ITEM_ID = RNI.ITEM_ID
AND RTND.DELETED_FLAG = '0' ) NDPROP
, CZ_PROPERTIES UPRP
, CZ_SIGNATURES PRSIG
, CZ_TYPE_RELATIONSHIPS PRCNV
, CZ_SIGNATURES UPREQ
WHERE XP_PR.PS_NODE_ID = NDPROP.PS_NODE_ID
AND NDPROP.PROPERTY_ID = UPRP.PROPERTY_ID
AND UPRP.DELETED_FLAG = '0'
AND UPRP.DATA_TYPE = PRSIG.SIGNATURE_ID
AND PRSIG.DELETED_FLAG = '0'
AND UPRP.DATA_TYPE = PRCNV.OBJECT_TYPE
AND PRCNV.REL_TYPE_CODE = 'CNV'
AND PRCNV.DELETED_FLAG = '0'
AND UPREQ.SIGNATURE_ID = PRCNV.SUBJECT_TYPE
AND UPREQ.DELETED_FLAG = '0' UNION ALL SELECT EMPTXP.MODEL_ID
, EMPTXP.PARENT_PSNODE_EXPL_ID
, EMPTXP.EFFECTIVE_PARENT_ID
, EMPTXP.MODEL_REF_EXPL_ID
, EMPTXP.PS_NODE_ID
, EMPTXP.PS_NODE_TYPE
, EMPTXP.DETAILED_TYPE_ID
, EMPTXP.ALT_TEXT AS DETAILED_TYPE_LABEL
, EMPTXP.FULL_IMAGE_PATH AS PS_NODE_TYPE_IMAGE_PATH
, EMPTXP.NAME AS PS_NODE_NAME
, EMPTXP.TEXT_STR AS PS_NODE_DESCRIPTION
, -1 AS PROPERTY_RULE_TYPE
, 'NUL' AS PROPERTY_TYPE_CODE
, -1 AS PROPERTY_ID
, TO_CHAR (NULL) AS PROPERTY_NAME
, EMPTXP.DETAILED_TYPE_ID AS PROPERTY_DATA_TYPE
, EMPTXP.PSNODETYPE_NAME AS PROPERTY_DATA_TYPE_NAME
, '1' AS PROPERTY_MUTABLE_FLAG
, '0' AS PROPERTY_COLLECTION_FLAG
, VSIG.SIGNATURE_ID AS DATA_TYPE_ID
, VSIG.NAME AS DATA_TYPE_NAME
FROM CZ_EXPLNODES_WITHIMAGES_V EMPTXP
, CZ_TYPE_RELATIONSHIPS EMPCNV
, CZ_SIGNATURES VSIG
WHERE EMPTXP.DETAILED_TYPE_ID = EMPCNV.OBJECT_TYPE
AND EMPCNV.REL_TYPE_CODE = 'CNV'
AND EMPCNV.DELETED_FLAG = '0'
AND EMPCNV.SUBJECT_TYPE = VSIG.SIGNATURE_ID