View: CZ_VALID_RESULT_TYPES_V

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

View Text

SELECT REL.SUBJECT_TYPE AS PARENT_DATA_TYPE
, REL.OBJECT_TYPE AS CHILD_DATA_TYPE
, LKV.LIST_NAME
, LKV.DATA_VALUE
, LKV.NUMERIC_ID_VALUE
, LKV.VALUE_SEQ
, LKV.DATA_TYPE_ID
, LKV.NULL_VALUE_FLAG
, LKV.VALUE_LABEL
, LKV.VALUE_DESCRIPTION
, LKV.VALUE_NOTES
, LKV.LANGUAGE
, LKV.SOURCE_LANG
, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_LOOKUP_VALUES_VL LKV
, CZ_PARENT_CHILD_RELS_V REL
, CZ_DEVL_PROJECTS PRJ
, CZ_SIGNATURES TYPSIG
, CZ_LOOKUP_VALUES MODELENTYP
WHERE LKV.LIST_NAME LIKE 'VALID_RESULT_FOR%'
AND LKV.NUMERIC_ID_VALUE = REL.OBJECT_TYPE
AND NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') = MODELENTYP.DATA_VALUE
AND MODELENTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND MODELENTYP.DELETED_FLAG = '0'
AND REL.OBJECT_TYPE = TYPSIG.SIGNATURE_ID
AND TYPSIG.DELETED_FLAG = '0'
AND TYPSIG.CONFIG_ENGINE_TYPE IN (SELECT SIGENTYP.DATA_VALUE
FROM CZ_TYPE_RELATIONSHIPS ETY
, CZ_LOOKUP_VALUES SIGENTYP
WHERE ETY.SUBJECT_TYPE = MODELENTYP.NUMERIC_ID_VALUE
AND ETY.REL_TYPE_CODE = 'ETY'
AND ETY.DELETED_FLAG = '0'
AND ETY.OBJECT_TYPE = SIGENTYP.NUMERIC_ID_VALUE
AND SIGENTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND SIGENTYP.DELETED_FLAG = '0') ORDER BY LKV.VALUE_SEQ

Columns