View: CZ_CREATERULEOBJECT_LKV

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

View Text

SELECT RTYV.LIST_NAME
, RCH.SUBJECT_TYPE AS ENCLOSING_TYPE
, RTYV.DATA_VALUE
, RCH.OBJECT_TYPE AS DETAILED_RULE_TYPE
, RTYV.VALUE_SEQ
, RTYV.NULL_VALUE_FLAG
, RTYV.VALUE_LABEL
, RTYV.VALUE_DESCRIPTION
, RTYV.VALUE_NOTES
, RTYV.NUMERIC_ID_VALUE
, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_DETAILEDRULETYPES_LKV RTYV
, CZ_TYPE_RELATIONSHIPS RCH
, CZ_DEVL_PROJECTS PRJ
, CZ_LOOKUP_VALUES MODTYP
WHERE RCH.REL_TYPE_CODE = 'RCH'
AND RCH.DELETED_FLAG = '0'
AND RCH.OBJECT_TYPE = RTYV.NUMERIC_ID_VALUE
AND MODTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') = MODTYP.DATA_VALUE
AND RCH.OBJECT_TYPE NOT IN (SELECT OBJECT_TYPE
FROM CZ_TYPE_RELATIONSHIPS
WHERE REL_TYPE_CODE = 'MRX'
AND SUBJECT_TYPE = MODTYP.NUMERIC_ID_VALUE
AND DELETED_FLAG = '0') ORDER BY RCH.SUBJECT_TYPE
, RCH.OBJECT_TYPE

Columns