VIEW: APPS.CZ_SIGNATURE_SYSPROPS_V

Source

View Text - Preformatted

SELECT subnd.object_type as detailed_signature_id, sbnty.signature_type as detailed_signature_type, sbnty.name as detailed_signature_name, prrul.name as sys_prop_name, rulret.signature_id as sys_prop_rettype_id, rulsig.COLLECTION_FLAG as sys_prop_retcoll_flag, rulsig.MUTABLE_FLAG as sys_prop_retmutable_flag, rulret.name as sys_prop_rettype_name, nodsig.name as propattach_sig_name, sypr.subject_type as propattach_signature_id, prrul.rule_id as sys_prop_rule_id, prrul.signature_id as sys_prop_signature_id, rulsig.name as sys_prop_signature_name, rtlv.DATA_VALUE as rule_type_code, prrul.rule_type, rtlv.value_label as rule_type_label, prrul.SEQ_NBR as sys_prop_seq_nbr, prrul.template_token as sys_prop_token, decode (subt2.subject_type, null, '0', '1') as all_numeric_sigs_flag, prrul.instance_set_flag, proj.devl_project_id as p_model_id FROM cz_type_relationships subt2, cz_ruletypecodes_lkv rtlv, cz_signatures nodsig, cz_type_relationships sypr, cz_rules prrul, cz_type_relationships subnd, cz_signatures sbnty, cz_signatures rulsig, cz_signatures rulret, cz_devl_projects proj WHERE rulsig.config_engine_type in (select sysprop_engine_type from cz_model_prop_engtyp_compat_v where model_id = proj.devl_project_id) and subt2.subject_type (+) = 2 and subt2.rel_type_code (+) = 'CNV' and subt2.deleted_flag (+) = '0' and subt2.object_type (+) = rulsig.data_type and rtlv.DATA_VALUE in ('SYS', 'JSY') AND 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 = SYPR.SUBJECT_TYPE AND CHKSUBND.OBJECT_TYPE = CHKSYSPR.SUBJECT_TYPE AND CHKSYSPR.DELETED_FLAG = '0' AND CHKSYSPR.REL_TYPE_CODE = sypr.rel_type_code 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 rulret.signature_id (+) = rulsig.DATA_TYPE and rulret.deleted_flag (+) = '0' and rulsig.deleted_flag = '0' and rulsig.signature_id = prrul.signature_id and prrul.deleted_flag = '0' and prrul.rule_type = rtlv.numeric_id_value 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 = sypr.SUBJECT_TYPE and sypr.rel_type_code = rtlv.data_value and sypr.deleted_flag = '0' and nodsig.signature_id = sypr.subject_type and nodsig.deleted_flag = '0' and prrul.rule_id = sypr.object_type

View Text - HTML Formatted

SELECT SUBND.OBJECT_TYPE AS DETAILED_SIGNATURE_ID
, SBNTY.SIGNATURE_TYPE AS DETAILED_SIGNATURE_TYPE
, SBNTY.NAME AS DETAILED_SIGNATURE_NAME
, PRRUL.NAME AS SYS_PROP_NAME
, RULRET.SIGNATURE_ID AS SYS_PROP_RETTYPE_ID
, RULSIG.COLLECTION_FLAG AS SYS_PROP_RETCOLL_FLAG
, RULSIG.MUTABLE_FLAG AS SYS_PROP_RETMUTABLE_FLAG
, RULRET.NAME AS SYS_PROP_RETTYPE_NAME
, NODSIG.NAME AS PROPATTACH_SIG_NAME
, SYPR.SUBJECT_TYPE AS PROPATTACH_SIGNATURE_ID
, PRRUL.RULE_ID AS SYS_PROP_RULE_ID
, PRRUL.SIGNATURE_ID AS SYS_PROP_SIGNATURE_ID
, RULSIG.NAME AS SYS_PROP_SIGNATURE_NAME
, RTLV.DATA_VALUE AS RULE_TYPE_CODE
, PRRUL.RULE_TYPE
, RTLV.VALUE_LABEL AS RULE_TYPE_LABEL
, PRRUL.SEQ_NBR AS SYS_PROP_SEQ_NBR
, PRRUL.TEMPLATE_TOKEN AS SYS_PROP_TOKEN
, DECODE (SUBT2.SUBJECT_TYPE
, NULL
, '0'
, '1') AS ALL_NUMERIC_SIGS_FLAG
, PRRUL.INSTANCE_SET_FLAG
, PROJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_TYPE_RELATIONSHIPS SUBT2
, CZ_RULETYPECODES_LKV RTLV
, CZ_SIGNATURES NODSIG
, CZ_TYPE_RELATIONSHIPS SYPR
, CZ_RULES PRRUL
, CZ_TYPE_RELATIONSHIPS SUBND
, CZ_SIGNATURES SBNTY
, CZ_SIGNATURES RULSIG
, CZ_SIGNATURES RULRET
, CZ_DEVL_PROJECTS PROJ
WHERE RULSIG.CONFIG_ENGINE_TYPE IN (SELECT SYSPROP_ENGINE_TYPE
FROM CZ_MODEL_PROP_ENGTYP_COMPAT_V
WHERE MODEL_ID = PROJ.DEVL_PROJECT_ID)
AND SUBT2.SUBJECT_TYPE (+) = 2
AND SUBT2.REL_TYPE_CODE (+) = 'CNV'
AND SUBT2.DELETED_FLAG (+) = '0'
AND SUBT2.OBJECT_TYPE (+) = RULSIG.DATA_TYPE
AND RTLV.DATA_VALUE IN ('SYS'
, 'JSY')
AND 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 = SYPR.SUBJECT_TYPE
AND CHKSUBND.OBJECT_TYPE = CHKSYSPR.SUBJECT_TYPE
AND CHKSYSPR.DELETED_FLAG = '0'
AND CHKSYSPR.REL_TYPE_CODE = SYPR.REL_TYPE_CODE
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 RULRET.SIGNATURE_ID (+) = RULSIG.DATA_TYPE
AND RULRET.DELETED_FLAG (+) = '0'
AND RULSIG.DELETED_FLAG = '0'
AND RULSIG.SIGNATURE_ID = PRRUL.SIGNATURE_ID
AND PRRUL.DELETED_FLAG = '0'
AND PRRUL.RULE_TYPE = RTLV.NUMERIC_ID_VALUE
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 = SYPR.SUBJECT_TYPE
AND SYPR.REL_TYPE_CODE = RTLV.DATA_VALUE
AND SYPR.DELETED_FLAG = '0'
AND NODSIG.SIGNATURE_ID = SYPR.SUBJECT_TYPE
AND NODSIG.DELETED_FLAG = '0'
AND PRRUL.RULE_ID = SYPR.OBJECT_TYPE