VIEW: APPS.CZ_TEMPLATE_DEFS_V

Source

View Text - Preformatted

SELECT RUL.RULE_ID, RUL.SIGNATURE_ID, RUL.NAME, RUL.TEMPLATE_TOKEN, RUL.DESC_TEXT, RUL.RULE_TEXT, RUL.TEMPLATE_PRIMITIVE_FLAG, RUL.INVALID_FLAG, RUL.PRESENTATION_FLAG, RUL.NOTES, RUL.SEQ_NBR, RUL.REASON_ID, RUL.REASON_TYPE, RUL.UNSATISFIED_MSG_ID, RUL.UNSATISFIED_MSG_SOURCE, RUL.DISABLED_FLAG, RUL.RULE_TYPE, RUL.RULE_FOLDER_ID, RUL.DEVL_PROJECT_ID, RUL.DELETED_FLAG, RUL.SEEDED_FLAG, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID FROM CZ_RULES RUL, CZ_DEVL_PROJECTS PRJ, CZ_LOOKUP_VALUES MODENGTYP WHERE RUL.RULE_TYPE = 100 AND RUL.DELETED_FLAG = '0' AND MODENGTYP.DELETED_FLAG = '0' AND NVL(PRJ.CONFIG_ENGINE_TYPE, 'L') = MODENGTYP.DATA_VALUE AND MODENGTYP.LIST_NAME = 'CZ_ENGINE_TYPES' AND RUL.CONFIG_ENGINE_TYPE IN (select rulengtyp.data_value from cz_type_relationships rels, cz_lookup_values rulengtyp where rels.deleted_Flag = '0' and rulengtyp.deleted_flag = '0' and rulengtyp.list_name = 'CZ_ENGINE_TYPES' and rels.subject_type = modengtyp.numeric_id_value and rels.rel_type_code = 'ETY' and rels.object_type = rulengtyp.numeric_id_value)

View Text - HTML Formatted

SELECT RUL.RULE_ID
, RUL.SIGNATURE_ID
, RUL.NAME
, RUL.TEMPLATE_TOKEN
, RUL.DESC_TEXT
, RUL.RULE_TEXT
, RUL.TEMPLATE_PRIMITIVE_FLAG
, RUL.INVALID_FLAG
, RUL.PRESENTATION_FLAG
, RUL.NOTES
, RUL.SEQ_NBR
, RUL.REASON_ID
, RUL.REASON_TYPE
, RUL.UNSATISFIED_MSG_ID
, RUL.UNSATISFIED_MSG_SOURCE
, RUL.DISABLED_FLAG
, RUL.RULE_TYPE
, RUL.RULE_FOLDER_ID
, RUL.DEVL_PROJECT_ID
, RUL.DELETED_FLAG
, RUL.SEEDED_FLAG
, PRJ.DEVL_PROJECT_ID AS P_MODEL_ID
FROM CZ_RULES RUL
, CZ_DEVL_PROJECTS PRJ
, CZ_LOOKUP_VALUES MODENGTYP
WHERE RUL.RULE_TYPE = 100
AND RUL.DELETED_FLAG = '0'
AND MODENGTYP.DELETED_FLAG = '0'
AND NVL(PRJ.CONFIG_ENGINE_TYPE
, 'L') = MODENGTYP.DATA_VALUE
AND MODENGTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND RUL.CONFIG_ENGINE_TYPE IN (SELECT RULENGTYP.DATA_VALUE
FROM CZ_TYPE_RELATIONSHIPS RELS
, CZ_LOOKUP_VALUES RULENGTYP
WHERE RELS.DELETED_FLAG = '0'
AND RULENGTYP.DELETED_FLAG = '0'
AND RULENGTYP.LIST_NAME = 'CZ_ENGINE_TYPES'
AND RELS.SUBJECT_TYPE = MODENGTYP.NUMERIC_ID_VALUE
AND RELS.REL_TYPE_CODE = 'ETY'
AND RELS.OBJECT_TYPE = RULENGTYP.NUMERIC_ID_VALUE)