eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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