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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AMS.AML_RULE_APPLIED_ATTRS

Object Details

Object Name:	AML_RULE_APPLIED_ATTRS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AML_RULE_APPLIED_ATTRS
Subobject Name:
Status:	VALID

AML_RULE_APPLIED_ATTRS is used to store winning rule log for lead evaluation

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_APPLIED_ATTR_ID	NUMBER		Yes	Primary key for table AML_RULE_APPLIED_ATTRS
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard WHO column
REQUEST_ID	NUMBER			Program WHO column
PROGRAM_APPLICATION_ID	NUMBER			Program WHO column
PROGRAM_ID	NUMBER			Program WHO column
PROGRAM_UPDATE_DATE	DATE			Program WHO column
ENTITY_RULE_APPLIED_ID	NUMBER		Yes	Foreign key to pv_entity_rules_applied.entity_rule_applied_id
ATTRIBUTE_ID	NUMBER		Yes	Foreign key to pv_attributes_b.attribute_id
OPERATOR	VARCHAR2	(30)	Yes	Operator of the rule which got applied. If the attribute is of VARCHAR2 type, comes from'PV_TEXT_OPERATOR'. If the attribute is of NUMBER or DATE type, comes from 'PV_NUM_DATE_OPERATOR'
ATTRIBUTE_VALUE	VARCHAR2	(4000)		Attribute Value
ATTRIBUTE_TO_VALUE	VARCHAR2	(4000)		Used for attributes that return NUMBER or DATE and use the operator BETWEEN
LEAD_VALUE	VARCHAR2	(4000)	Yes	Lead value when it matches the rule
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_APPLIED_ATTR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ENTITY_RULE_APPLIED_ID
,      ATTRIBUTE_ID
,      OPERATOR
,      ATTRIBUTE_VALUE
,      ATTRIBUTE_TO_VALUE
,      LEAD_VALUE
,      SECURITY_GROUP_ID
FROM AMS.AML_RULE_APPLIED_ATTRS;

Dependencies

[top of page]

AMS.AML_RULE_APPLIED_ATTRS does not reference any database object

AMS.AML_RULE_APPLIED_ATTRS is referenced by following:

AMS: AML_RULE_APPLIED_ATTRS#