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: MSC.MSC_PARTNER_CONTACTS

Object Details

Object Name:	MSC_PARTNER_CONTACTS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_PARTNER_CONTACTS
Subobject Name:
Status:	VALID

This table stores the partner contacts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_PARTNER_CONTACTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SR_INSTANCE_ID PARTNER_TYPE PARTNER_ID PARTNER_SITE_ID
MSC_PARTNER_CONTACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_ID PARTNER_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(100)		Partner's user name
DISPLAY_NAME	VARCHAR2	(240)		Partner's display name
PARTNER_ID	NUMBER		Yes	Partner Identifier
PARTNER_SITE_ID	NUMBER			Partner site identifier
PARTNER_TYPE	NUMBER		Yes	Indicate type of partner, supplier, customer, or buyer
EMAIL	VARCHAR2	(240)		Partner's email address
FAX	VARCHAR2	(240)		Partner's FAX number
ENABLED_FLAG	VARCHAR2	(1)		Flag indicating contact is enabled
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
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			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      PARTNER_ID
,      PARTNER_SITE_ID
,      PARTNER_TYPE
,      EMAIL
,      FAX
,      ENABLED_FLAG
,      REFRESH_NUMBER
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSC.MSC_PARTNER_CONTACTS;

Dependencies

[top of page]

MSC.MSC_PARTNER_CONTACTS does not reference any database object

MSC.MSC_PARTNER_CONTACTS is referenced by following:

MSC: MSC_PARTNER_CONTACTS#