VIEW: APPS.CZ_CREATERULEOBJECT_LKV

Source

View Text - Preformatted

SELECT RTYV.LIST_NAME, RCH.SUBJECT_TYPE AS ENCLOSING_TYPE, RTYV.DATA_VALUE, RCH.OBJECT_TYPE AS DETAILED_RULE_TYPE, RTYV.VALUE_SEQ, RTYV.NULL_VALUE_FLAG, RTYV.VALUE_LABEL, RTYV.VALUE_DESCRIPTION, RTYV.VALUE_NOTES, RTYV.NUMERIC_ID_VALUE, PRJ.devl_project_id as P_MODEL_ID FROM CZ_DETAILEDRULETYPES_LKV RTYV, CZ_TYPE_RELATIONSHIPS RCH, cz_devl_projects PRJ, cz_lookup_values modtyp WHERE RCH.REL_TYPE_CODE = 'RCH' AND RCH.DELETED_FLAG = '0' AND RCH.OBJECT_TYPE = RTYV.NUMERIC_ID_VALUE AND modtyp.list_name = 'CZ_ENGINE_TYPES' AND nvl(prj.config_engine_type, 'L') = modtyp.data_value and RCH.OBJECT_TYPE NOT IN (select object_type from cz_type_relationships where rel_type_code = 'MRX' and subject_type = modtyp.numeric_id_value and deleted_flag = '0') ORDER BY RCH.SUBJECT_TYPE, RCH.OBJECT_TYPE

View Text - HTML Formatted

SELECT RTYV.LIST_NAME
, RCH.SUBJECT_TYPE AS ENCLOSING_TYPE
, RTYV.DATA_VALUE
, RCH.OBJECT_TYPE AS DETAILED_RULE_TYPE
, RTYV.VALUE_SEQ
, RTYV.NULL_VALUE_FLAG
, RTYV.VALUE_LABEL
, RTYV.VALUE_DESCRIPTION
, RTYV.VALUE_NOTES
, RTYV.NUMERIC_ID_VALUE
, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_DETAILEDRULETYPES_LKV RTYV
, CZ_TYPE_RELATIONSHIPS RCH
, CZ_DEVL_PROJECTS PRJ
, CZ_LOOKUP_VALUES MODTYP
WHERE RCH.REL_TYPE_CODE = 'RCH'
AND RCH.DELETED_FLAG = '0'
AND RCH.OBJECT_TYPE = RTYV.NUMERIC_ID_VALUE
AND MODTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') = MODTYP.DATA_VALUE
AND RCH.OBJECT_TYPE NOT IN (SELECT OBJECT_TYPE
FROM CZ_TYPE_RELATIONSHIPS
WHERE REL_TYPE_CODE = 'MRX'
AND SUBJECT_TYPE = MODTYP.NUMERIC_ID_VALUE
AND DELETED_FLAG = '0') ORDER BY RCH.SUBJECT_TYPE
, RCH.OBJECT_TYPE