VIEW: APPS.CZ_NODETYPE_JAVASYSPROPS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'