VIEW: APPS.CZ_VALID_RESULT_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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