Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_SYSTEM_PROPERTIES_V |
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