[Home] [Help] [Dependency Information]
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).
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | 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 |
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;
AMS.AML_INTERACTION_LEADS does not reference any database object
AMS.AML_INTERACTION_LEADS is referenced by following:
|
|
|