View: AMS_P_LIST_RULES_V

Product:	AMS - Marketing
Description:	This public view returns information on user-defined rules for identifying account or contact duplicates in lists, and what priority reules should be used when removing these duplicates.
Implementation/DBA Data:	APPS.AMS_P_LIST_RULES_V

View Text

SELECT R.LIST_RULE_ID
, R.LIST_RULE_NAME
, R.LIST_RULE_TYPE
, RU.LIST_HEADER_ID
FROM AMS_LIST_RULES_ALL R
, AMS_LIST_RULE_USAGES RU
WHERE R.LIST_RULE_ID = RU.LIST_RULE_ID
AND RU.LIST_RULE_ID = (SELECT MAX(LIST_RULE_ID)
FROM AMS_LIST_RULE_USAGES
WHERE LIST_HEADER_ID = RU.LIST_HEADER_ID)

Columns