View: CZ_MODEL_PROP_ENGTYP_COMPAT_V

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

View Text

SELECT PROJ.DEVL_PROJECT_ID AS MODEL_ID
, PROPTYPES.DATA_VALUE AS SYSPROP_ENGINE_TYPE
FROM CZ_LOOKUP_VALUES PROPTYPES
, CZ_LOOKUP_VALUES ENGTYPES
, CZ_TYPE_RELATIONSHIPS TYPRELS
, CZ_DEVL_PROJECTS PROJ
WHERE PROPTYPES.LIST_NAME = 'CZ_ENGINE_TYPES'
AND ENGTYPES.LIST_NAME = 'CZ_ENGINE_TYPES'
AND ENGTYPES.NUMERIC_ID_VALUE = TYPRELS.SUBJECT_TYPE
AND TYPRELS.REL_TYPE_CODE = 'ETY'
AND TYPRELS.OBJECT_TYPE = PROPTYPES.NUMERIC_ID_VALUE
AND ENGTYPES.DATA_VALUE = DECODE(PROJ.DEVL_PROJECT_ID
, 0
, FND_PROFILE.VALUE_WNPS('CZ_DEV_ENABLE_CONFIG_ENGINE')
, NVL(PROJ.CONFIG_ENGINE_TYPE
, 'L'))

Columns