VIEW: APPS.CZ_MODEL_PROP_ENGTYP_COMPAT_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))