[Home] [Help] [Dependency Information]
Object Name: | AMS_P_LIST_RULES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_LIST_RULES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
AMS_LIST_RULES_ALL stores information on user-defined rules for identifying account or contact duplicates in lists, and what priority reules should be used when removing these duplicates.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_RULE_ID | NUMBER | Yes | Unique Identifier | |
LIST_RULE_NAME | VARCHAR2 | (120) | Yes | Deduplication rule name. |
LIST_RULE_TYPE | VARCHAR2 | (30) | For OSM upgrade. Indicates if the rule is for an IMPORT or TARGET List. | |
LIST_HEADER_ID | NUMBER | Yes | Foreign key to ams_list_headers_all |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_RULE_ID
, LIST_RULE_NAME
, LIST_RULE_TYPE
, LIST_HEADER_ID
FROM APPS.AMS_P_LIST_RULES_V;
|
|
|