SELECT PROJ.DEVL_PROJECT_ID AS P_MODEL_ID , LSPTYPES.LIST_NAME AS LIST_NAME , LSPTYPES.DATA_VALUE AS DATA_VALUE , LSPTYPES.VALUE_SEQ AS VALUE_SEQ , LSPTYPES.DATA_TYPE_ID AS DATA_TYPE_ID , LSPTYPES.NULL_VALUE_FLAG AS NUM_VALUE_FLAG , LSPTYPES.VALUE_LABEL AS VALUE_LABEL , LSPTYPES.VALUE_DESCRIPTION AS VALUE_DESCRIPTION , LSPTYPES.NUMERIC_ID_VALUE AS NUMERIC_ID_VALUE FROM CZ_LOOKUP_VALUES_VL LSPTYPES , CZ_LOOKUP_VALUES ENGTYPES , CZ_TYPE_RELATIONSHIPS TYPRELS , CZ_DEVL_PROJECTS PROJ WHERE LSPTYPES.LIST_NAME = 'SYSPROPVALS_LOGIC_STATE' AND ENGTYPES.LIST_NAME = 'CZ_ENGINE_TYPES' AND ENGTYPES.DELETED_FLAG = '0' AND TYPRELS.DELETED_FLAG = '0' AND TYPRELS.REL_TYPE_CODE = 'LSP' AND TYPRELS.OBJECT_TYPE = LSPTYPES.NUMERIC_ID_VALUE AND ENGTYPES.NUMERIC_ID_VALUE = TYPRELS.SUBJECT_TYPE 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')) UNION ALL SELECT -1 AS P_MODEL_ID , LSPTYPES.LIST_NAME AS LIST_NAME , LSPTYPES.DATA_VALUE AS DATA_VALUE , LSPTYPES.VALUE_SEQ AS VALUE_SEQ , LSPTYPES.DATA_TYPE_ID AS DATA_TYPE_ID , LSPTYPES.NULL_VALUE_FLAG AS NUM_VALUE_FLAG , LSPTYPES.VALUE_LABEL AS VALUE_LABEL , LSPTYPES.VALUE_DESCRIPTION AS VALUE_DESCRIPTION , LSPTYPES.NUMERIC_ID_VALUE AS NUMERIC_ID_VALUE FROM CZ_LOOKUP_VALUES_VL LSPTYPES , CZ_TYPE_RELATIONSHIPS TYPRELS WHERE LSPTYPES.LIST_NAME = 'SYSPROPVALS_LOGIC_STATE' AND TYPRELS.REL_TYPE_CODE = 'LSP' AND TYPRELS.OBJECT_TYPE = LSPTYPES.NUMERIC_ID_VALUE AND TYPRELS.SUBJECT_TYPE = 1 AND TYPRELS.DELETED_FLAG = '0'