Skip to content

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

TABLE: OSM.AS_PARTNER_LEAD_LINES

Object Details
Object Name: AS_PARTNER_LEAD_LINES
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_PARTNER_LEAD_LINES
Subobject Name:
Status: VALID


Stores the contact information for a lead in partner's OSO database.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_PARTNER_LEAD_LINES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPARTNER_LEAD_LINE_ID
AS_PARTNER_LEAD_LINES_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLEAD_ID
Columns
Name Datatype Length Mandatory Comments
PARTNER_LEAD_LINE_ID NUMBER
Yes Unique identifier for Partner Lead Line
LEAD_ID NUMBER
Yes Unique identifier for Lead
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY_USER_NAME VARCHAR2 (100) Yes Last Updated By User Name
CREATION_DATE DATE
Yes Creation Date
CREATED_BY_USER_NAME VARCHAR2 (100) Yes Created By User Name
INTEREST_TYPE VARCHAR2 (80) Yes Interest Type
PRIMARY_INTEREST_CODE VARCHAR2 (100)
Primary Interest Code
SECONDARY_INTEREST_CODE VARCHAR2 (100)
Secondary Interest Code
TOTAL_AMOUNT NUMBER

Total Amount
WIN_PROBABILITY NUMBER

Win Probability
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 PARTNER_LEAD_LINE_ID
,      LEAD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY_USER_NAME
,      CREATION_DATE
,      CREATED_BY_USER_NAME
,      INTEREST_TYPE
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE
,      TOTAL_AMOUNT
,      WIN_PROBABILITY
,      SECURITY_GROUP_ID
FROM OSM.AS_PARTNER_LEAD_LINES;

Dependencies

[top of page]

OSM.AS_PARTNER_LEAD_LINES does not reference any database object

OSM.AS_PARTNER_LEAD_LINES is referenced by following:

SchemaOSM
ViewAS_PARTNER_LEAD_LINES#