VIEW: APPS.CZ_MODEL_LOGICSTATE_PROPS_LKV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'