View: CZ_PROPERTIES_FOR_CONTEXT_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_PROPERTIES_FOR_CONTEXT_V

View Text

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

Columns