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_INTERACTION_LEADS

Object Details

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

AML_INTERACTION_LEADS defines the relation of interactions(JTF_IH_INTERACTIONS), responses(AS_IMPORT_INTERFACE), and leads(AS_SALES_LEADS).

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AML_INTERACTION_LEADS_U1	NORMAL	UNIQUE	APPS_TS_SEED	INTERACTION_LEAD_ID
AML_INTERACTION_LEADS_U2	NORMAL	UNIQUE	APPS_TS_SEED	INTERACTION_ID IMPORT_INTERFACE_ID SALES_LEAD_ID
AML_INTERACTION_LEADS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	IMPORT_INTERFACE_ID SALES_LEAD_ID

Columns

Name	Datatype	Mandatory	Comments
INTERACTION_LEAD_ID	NUMBER	Yes	Interaction Lead Identifier
INTERACTION_ID	NUMBER	Yes	Interaction Identifier
IMPORT_INTERFACE_ID	NUMBER		Import Interface Identifier
SALES_LEAD_ID	NUMBER		Sales Lead Identifier
CREATION_DATE	DATE	Yes	Standard WHO column
CREATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE	Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	Yes	Standard WHO column
REQUEST_ID	NUMBER		Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	NUMBER		Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER		Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE		Last date concurrent program updated record
OBJECT_VERSION_NUMBER	NUMBER	Yes	Object Version Number. Used by API's for checking whether record has been modified
SECURITY_GROUP_ID	NUMBER		Subscriber id, for CRM Online Services use
SCORE	NUMBER		Score of the interaction

Query Text

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


SELECT INTERACTION_LEAD_ID
,      INTERACTION_ID
,      IMPORT_INTERFACE_ID
,      SALES_LEAD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      SCORE
FROM AMS.AML_INTERACTION_LEADS;

Dependencies

[top of page]

AMS.AML_INTERACTION_LEADS does not reference any database object

AMS.AML_INTERACTION_LEADS is referenced by following:

AMS: AML_INTERACTION_LEADS#