[Home] [Help]
View: AS_LIST_RULE_ENTRIES_V
Product: | AS - Sales Foundation |
Description: | Displays the columns available to be used to define de-duplicate rules. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RULE1.LIST_RULE_ID
, RULE1.LIST_RULE_ENTRY_ID
, RULE.TYPE
, RULE.RULE_NAME
, RULE1.FIELD_SOURCE_NAME
, FIELDS.FIELD_DESCRIPTION
, RULE1.SEQUENCE_NUMBER
FROM AS_LIST_RULE_FIELDS_VL FIELDS
, AS_LIST_RULE_ENTRIES RULE1
, AS_LIST_RULES RULE
WHERE FIELDS.TYPE = RULE.TYPE
AND FIELDS.FIELD_NAME = RULE1.FIELD_SOURCE_NAME
AND RULE1.LIST_RULE_ID = RULE.LIST_RULE_ID
Columns
Name |
LIST_RULE_ID |
LIST_RULE_ENTRY_ID |
TYPE |
RULE_NAME |
FIELD_SOURCE_NAME |
FIELD_DESCRIPTION |
SEQUENCE_NUMBER |