VIEW: APPS.CZ_SYSTEM_PROPERTIES_V

Source

View Text - Preformatted

SELECT prop.RULE_ID, prop.NAME, prop.TEMPLATE_TOKEN, sig.SIGNATURE_ID, prop.DESC_TEXT, prop.CLASS_NAME, prop.NOTES, prop.MUTABLE_FLAG, sig.DATA_TYPE, sig.COLLECTION_FLAG, prop.DISABLED_FLAG, prop.RULE_TYPE, prop.RULE_FOLDER_ID, prop.DEVL_PROJECT_ID, prop.DELETED_FLAG, prop.SEEDED_FLAG, prop.SEQ_NBR, sig.CONFIG_ENGINE_TYPE FROM CZ_RULES prop, CZ_SIGNATURES sig WHERE prop.RULE_TYPE IN (500, 501) AND prop.DELETED_FLAG = '0' AND prop.SIGNATURE_ID = sig.SIGNATURE_ID

View Text - HTML Formatted

SELECT PROP.RULE_ID
, PROP.NAME
, PROP.TEMPLATE_TOKEN
, SIG.SIGNATURE_ID
, PROP.DESC_TEXT
, PROP.CLASS_NAME
, PROP.NOTES
, PROP.MUTABLE_FLAG
, SIG.DATA_TYPE
, SIG.COLLECTION_FLAG
, PROP.DISABLED_FLAG
, PROP.RULE_TYPE
, PROP.RULE_FOLDER_ID
, PROP.DEVL_PROJECT_ID
, PROP.DELETED_FLAG
, PROP.SEEDED_FLAG
, PROP.SEQ_NBR
, SIG.CONFIG_ENGINE_TYPE
FROM CZ_RULES PROP
, CZ_SIGNATURES SIG
WHERE PROP.RULE_TYPE IN (500
, 501)
AND PROP.DELETED_FLAG = '0'
AND PROP.SIGNATURE_ID = SIG.SIGNATURE_ID