SELECT SUBND.OBJECT_TYPE AS DETAILED_NODE_TYPE_ID , SBNTY.NAME AS DETAILED_NODE_TYPE_NAME , PRRUL.RULE_ID AS JAVA_SYS_PROP_RULE_ID , PRRUL.NAME AS JAVA_SYS_PROP_NAME , PRRUL.TEMPLATE_TOKEN , JSYSP.SUBJECT_TYPE AS PROPATTACH_SIGNATURE_ID , RULRET.SIGNATURE_ID AS JAVA_SYS_PROP_TYPE_ID , RULRET.JAVA_DATA_TYPE AS JAVA_SYS_PROP_DATA_TYPE , '2004-08-03' AS VIEWREV FROM CZ_SIGNATURES NODSIG , CZ_TYPE_RELATIONSHIPS JSYSP , CZ_RULES PRRUL , CZ_TYPE_RELATIONSHIPS SUBND , CZ_SIGNATURES SBNTY , CZ_SIGNATURES RULSIG , CZ_SIGNATURES RULRET WHERE NOT EXISTS ( SELECT 1 FROM CZ_RULES CHKPRRUL , CZ_TYPE_RELATIONSHIPS CHKSYSPR , CZ_TYPE_RELATIONSHIPS CHKSUBND , CZ_TYPE_RELATIONSHIPS CHK2SUBND WHERE CHK2SUBND.DELETED_FLAG = '0' AND CHK2SUBND.REL_TYPE_CODE = 'CNV' AND CHK2SUBND.OBJECT_TYPE = SUBND.OBJECT_TYPE AND CHK2SUBND.SUBJECT_TYPE = CHKSUBND.OBJECT_TYPE AND CHKSUBND.DELETED_FLAG = '0' AND CHKSUBND.REL_TYPE_CODE = 'CNV' AND CHKSUBND.SUBJECT_TYPE != CHKSUBND.OBJECT_TYPE AND CHKSUBND.SUBJECT_TYPE = JSYSP.SUBJECT_TYPE AND CHKSUBND.OBJECT_TYPE = CHKSYSPR.SUBJECT_TYPE AND CHKSYSPR.DELETED_FLAG = '0' AND CHKSYSPR.REL_TYPE_CODE = 'JSY' AND CHKSYSPR.OBJECT_TYPE = CHKPRRUL.RULE_ID AND CHKPRRUL.DELETED_FLAG = '0' AND CHKPRRUL.RULE_ID != PRRUL.RULE_ID AND ( CHKPRRUL.NAME = PRRUL.NAME OR CHKPRRUL.TEMPLATE_TOKEN = PRRUL.TEMPLATE_TOKEN ) ) AND RULSIG.DELETED_FLAG = '0' AND RULSIG.SIGNATURE_ID = PRRUL.SIGNATURE_ID AND PRRUL.DELETED_FLAG = '0' AND PRRUL.RULE_TYPE = 501 AND SBNTY.SIGNATURE_ID = SUBND.OBJECT_TYPE AND SBNTY.DELETED_FLAG = '0' AND SUBND.REL_TYPE_CODE = 'CNV' AND SUBND.DELETED_FLAG = '0' AND SUBND.SUBJECT_TYPE = JSYSP.SUBJECT_TYPE AND JSYSP.REL_TYPE_CODE = 'JSY' AND JSYSP.DELETED_FLAG = '0' AND NODSIG.SIGNATURE_ID = JSYSP.SUBJECT_TYPE AND NODSIG.DELETED_FLAG = '0' AND PRRUL.RULE_ID = JSYSP.OBJECT_TYPE AND RULSIG.DATA_TYPE = RULRET.DATA_TYPE AND RULRET.SIGNATURE_TYPE = 'JTY' AND RULRET.DELETED_FLAG = '0'