View: CZ_NODETYPE_SYSPROPS_V

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

View Text

SELECT SUBND.OBJECT_TYPE AS DETAILED_TYPE_ID
, SBNTY.NAME AS DETAILED_TYPE_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
, 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.CONFIG_ENGINE_TYPE
FROM 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
WHERE RTLV.DATA_VALUE = 'SYS'
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

Columns