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

TABLE: OSM.AS_PARTNER_ACCESSES

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


Stores the sales rep 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_ACCESSES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPARTNER_ACCESS_ID
AS_PARTNER_ACCESSES_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLEAD_ID
Columns
Name Datatype Length Mandatory Comments
PARTNER_ACCESS_ID NUMBER
Yes Unique identifier for Partner Access
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
SALESFORCE_ID NUMBER (38) Yes Unique identifier for Salesforce
LAST_NAME VARCHAR2 (40)
Last Name
FIRST_NAME VARCHAR2 (20)
First Name
NAME VARCHAR2 (240)
Name
SALES_GROUP VARCHAR2 (60)
Salesgroup
TITLE VARCHAR2 (240)
Title
EMAIL VARCHAR2 (240)
Email
PHONE_NUMBER VARCHAR2 (60)
Phonenumber
STATUS VARCHAR2 (10)
Status
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_ACCESS_ID
,      LEAD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY_USER_NAME
,      CREATION_DATE
,      CREATED_BY_USER_NAME
,      SALESFORCE_ID
,      LAST_NAME
,      FIRST_NAME
,      NAME
,      SALES_GROUP
,      TITLE
,      EMAIL
,      PHONE_NUMBER
,      STATUS
,      SECURITY_GROUP_ID
FROM OSM.AS_PARTNER_ACCESSES;

Dependencies

[top of page]

OSM.AS_PARTNER_ACCESSES does not reference any database object

OSM.AS_PARTNER_ACCESSES is referenced by following:

SchemaOSM
ViewAS_PARTNER_ACCESSES#