View: CZ_MODEL_LOGICSTATE_PROPS_LKV

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

View Text

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'

Columns