VIEW: APPS.CZ_PROPERTIES_FOR_CONTEXT_V

Source

View Text - Preformatted

SELECT CTXSIG.SIGNATURE_ID AS CONTEXT_TYPE_ID, CTXSIG.NAME AS CONTEXT_TYPE_NAME, max (convs.definite_binding_flag) as definite_binding_flag, RTCODE.DATA_VALUE AS PROPERTY_RULE_TYPE_CODE, RTCODE.VALUE_LABEL AS PROPERTY_RULE_TYPE_LABEL, min (prprul.SEQ_NBR) as property_seq_nbr, decode (max (prprul.rule_id), min (prprul.rule_id), max (prprul.rule_id), to_number (null)) as property_id, PRPRUL.RULE_TYPE AS PROPERTY_RULE_TYPE, PRPRUL.NAME AS PROPERTY_NAME, decode (max (prpsig.data_type), min (prpsig.data_type), max (prpsig.data_type), to_number (null)) as property_data_type, max (prpsig.mutable_flag) as property_mutable_flag, min (prpsig.collection_flag) as property_collection_flag, decode (count (numchk.subject_type), count (*), '1', '0') as all_numeric_sigs_flag, PRPRUL.TEMPLATE_TOKEN AS PROPERTY_TOKEN, proj.devl_project_id as p_model_id from cz_type_relationships numchk, cz_type_relationships subctx, cz_signatures prpsig, cz_rules prprul, cz_signatures ctxsig, ( select subject_type as eval_type_id, object_type as binding_type_id, '0' as definite_binding_flag from cz_type_relationships where rel_type_code = 'CNV' and deleted_flag = '0' union all select object_type as eval_type_id, subject_type as binding_type_id, '1' as definite_binding_flag from cz_type_relationships where rel_type_code = 'CNV' and deleted_flag = '0' ) convs, cz_ruletypecodes_lkv rtcode, cz_type_relationships prpbind, cz_devl_projects proj WHERE 'CNV' = numchk.rel_type_code (+) and '0' = numchk.deleted_flag (+) and 2 = numchk.subject_type (+) and prpsig.data_type = numchk.object_type (+) and prpsig.signature_id = prprul.signature_id and prpsig.deleted_flag = '0' and prpsig.config_engine_type in (select sysprop_engine_type from cz_model_prop_engtyp_compat_v where model_id = proj.devl_project_id) and prprul.rule_id = prpbind.object_type and prpbind.deleted_flag = '0' and prpbind.subject_type = convs.binding_type_id and prpbind.rel_type_code = rtcode.data_value and rtcode.data_value in ('SYS', 'JSY') and convs.eval_type_id = subctx.object_type and not exists ( select 1 from cz_type_relationships ctx2mid, cz_type_relationships mid2sub where ctx2mid.rel_type_code = 'CNV' and ctx2mid.deleted_flag = '0' and ctx2mid.subject_type != ctx2mid.object_type and mid2sub.rel_type_code = 'CNV' and mid2sub.deleted_flag = '0' and mid2sub.subject_type != mid2sub.object_type and ctx2mid.subject_type = ctxsig.signature_id and ctx2mid.object_type = mid2sub.subject_type and mid2sub.object_type = subctx.object_type ) and subctx.rel_type_code = 'CNV' and subctx.SUBJECT_TYPE = ctxsig.signature_id and ctxsig.deleted_flag = '0' group by CTXSIG.SIGNATURE_ID, CTXSIG.NAME, RTCODE.DATA_VALUE, RTCODE.VALUE_LABEL, PRPRUL.RULE_TYPE, PRPRUL.NAME, PRPRUL.TEMPLATE_TOKEN, PROJ.DEVL_PROJECT_ID

View Text - HTML Formatted

SELECT CTXSIG.SIGNATURE_ID AS CONTEXT_TYPE_ID
, CTXSIG.NAME AS CONTEXT_TYPE_NAME
, MAX (CONVS.DEFINITE_BINDING_FLAG) AS DEFINITE_BINDING_FLAG
, RTCODE.DATA_VALUE AS PROPERTY_RULE_TYPE_CODE
, RTCODE.VALUE_LABEL AS PROPERTY_RULE_TYPE_LABEL
, MIN (PRPRUL.SEQ_NBR) AS PROPERTY_SEQ_NBR
, DECODE (MAX (PRPRUL.RULE_ID)
, MIN (PRPRUL.RULE_ID)
, MAX (PRPRUL.RULE_ID)
, TO_NUMBER (NULL)) AS PROPERTY_ID
, PRPRUL.RULE_TYPE AS PROPERTY_RULE_TYPE
, PRPRUL.NAME AS PROPERTY_NAME
, DECODE (MAX (PRPSIG.DATA_TYPE)
, MIN (PRPSIG.DATA_TYPE)
, MAX (PRPSIG.DATA_TYPE)
, TO_NUMBER (NULL)) AS PROPERTY_DATA_TYPE
, MAX (PRPSIG.MUTABLE_FLAG) AS PROPERTY_MUTABLE_FLAG
, MIN (PRPSIG.COLLECTION_FLAG) AS PROPERTY_COLLECTION_FLAG
, DECODE (COUNT (NUMCHK.SUBJECT_TYPE)
, COUNT (*)
, '1'
, '0') AS ALL_NUMERIC_SIGS_FLAG
, PRPRUL.TEMPLATE_TOKEN AS PROPERTY_TOKEN
, PROJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_TYPE_RELATIONSHIPS NUMCHK
, CZ_TYPE_RELATIONSHIPS SUBCTX
, CZ_SIGNATURES PRPSIG
, CZ_RULES PRPRUL
, CZ_SIGNATURES CTXSIG
, ( SELECT SUBJECT_TYPE AS EVAL_TYPE_ID
, OBJECT_TYPE AS BINDING_TYPE_ID
, '0' AS DEFINITE_BINDING_FLAG
FROM CZ_TYPE_RELATIONSHIPS
WHERE REL_TYPE_CODE = 'CNV'
AND DELETED_FLAG = '0' UNION ALL SELECT OBJECT_TYPE AS EVAL_TYPE_ID
, SUBJECT_TYPE AS BINDING_TYPE_ID
, '1' AS DEFINITE_BINDING_FLAG
FROM CZ_TYPE_RELATIONSHIPS
WHERE REL_TYPE_CODE = 'CNV'
AND DELETED_FLAG = '0' ) CONVS
, CZ_RULETYPECODES_LKV RTCODE
, CZ_TYPE_RELATIONSHIPS PRPBIND
, CZ_DEVL_PROJECTS PROJ
WHERE 'CNV' = NUMCHK.REL_TYPE_CODE (+)
AND '0' = NUMCHK.DELETED_FLAG (+)
AND 2 = NUMCHK.SUBJECT_TYPE (+)
AND PRPSIG.DATA_TYPE = NUMCHK.OBJECT_TYPE (+)
AND PRPSIG.SIGNATURE_ID = PRPRUL.SIGNATURE_ID
AND PRPSIG.DELETED_FLAG = '0'
AND PRPSIG.CONFIG_ENGINE_TYPE IN (SELECT SYSPROP_ENGINE_TYPE
FROM CZ_MODEL_PROP_ENGTYP_COMPAT_V
WHERE MODEL_ID = PROJ.DEVL_PROJECT_ID)
AND PRPRUL.RULE_ID = PRPBIND.OBJECT_TYPE
AND PRPBIND.DELETED_FLAG = '0'
AND PRPBIND.SUBJECT_TYPE = CONVS.BINDING_TYPE_ID
AND PRPBIND.REL_TYPE_CODE = RTCODE.DATA_VALUE
AND RTCODE.DATA_VALUE IN ('SYS'
, 'JSY')
AND CONVS.EVAL_TYPE_ID = SUBCTX.OBJECT_TYPE
AND NOT EXISTS ( SELECT 1
FROM CZ_TYPE_RELATIONSHIPS CTX2MID
, CZ_TYPE_RELATIONSHIPS MID2SUB
WHERE CTX2MID.REL_TYPE_CODE = 'CNV'
AND CTX2MID.DELETED_FLAG = '0'
AND CTX2MID.SUBJECT_TYPE != CTX2MID.OBJECT_TYPE
AND MID2SUB.REL_TYPE_CODE = 'CNV'
AND MID2SUB.DELETED_FLAG = '0'
AND MID2SUB.SUBJECT_TYPE != MID2SUB.OBJECT_TYPE
AND CTX2MID.SUBJECT_TYPE = CTXSIG.SIGNATURE_ID
AND CTX2MID.OBJECT_TYPE = MID2SUB.SUBJECT_TYPE
AND MID2SUB.OBJECT_TYPE = SUBCTX.OBJECT_TYPE )
AND SUBCTX.REL_TYPE_CODE = 'CNV'
AND SUBCTX.SUBJECT_TYPE = CTXSIG.SIGNATURE_ID
AND CTXSIG.DELETED_FLAG = '0' GROUP BY CTXSIG.SIGNATURE_ID
, CTXSIG.NAME
, RTCODE.DATA_VALUE
, RTCODE.VALUE_LABEL
, PRPRUL.RULE_TYPE
, PRPRUL.NAME
, PRPRUL.TEMPLATE_TOKEN
, PROJ.DEVL_PROJECT_ID