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: XNP.XNP_SP_CONTACTS

Object Details

Object Name:	XNP_SP_CONTACTS
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_SP_CONTACTS
Subobject Name:
Status:	VALID

XNP_SP_CONTACTS holds contact information for the service provider

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_SP_CONTACTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	SP_CONTACT_ID
XNP_SP_CONTACTS_U2	NORMAL	UNIQUE	APPS_TS_SEED	BUSINESS_ROLE SP_ID NAME
XNP_SP_CONTACTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	SP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SP_CONTACT_ID	NUMBER		Yes	Service provider contact identifier
SP_ID	NUMBER		Yes	Service provider having the contact information
BUSINESS_ROLE	VARCHAR2	(40)	Yes	Business role of the person
NAME	VARCHAR2	(40)	Yes	Name of the contact person
ADDRESS_LINE1	VARCHAR2	(40)	Yes	Street address of the service provider's contact person
CITY	VARCHAR2	(40)	Yes	City of the contact person
STATE	VARCHAR2	(40)		State of the contact person
ZIP_CODE	VARCHAR2	(20)	Yes	Zip code of the contact person
COUNTRY	VARCHAR2	(40)	Yes	Country of the contact person
PHONE	VARCHAR2	(20)	Yes	Phone number of the contact person
ADDRESS_LINE2	VARCHAR2	(40)		Street address of the contact person
MOBILE	VARCHAR2	(20)		Cellular contact number
FAX	VARCHAR2	(20)		FAX number of the contact person
PAGER	VARCHAR2	(20)		Pager number of the contact person
PAGER_PIN	VARCHAR2	(80)		Pager pin number of the contact person
EMAIL	VARCHAR2	(80)		Email of the contact person
INTERNET_ADDRESS	VARCHAR2	(40)		Web address of the contact person
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT SP_CONTACT_ID
,      SP_ID
,      BUSINESS_ROLE
,      NAME
,      ADDRESS_LINE1
,      CITY
,      STATE
,      ZIP_CODE
,      COUNTRY
,      PHONE
,      ADDRESS_LINE2
,      MOBILE
,      FAX
,      PAGER
,      PAGER_PIN
,      EMAIL
,      INTERNET_ADDRESS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SP_CONTACTS;

Dependencies

[top of page]

XNP.XNP_SP_CONTACTS does not reference any database object

XNP.XNP_SP_CONTACTS is referenced by following:

APPS: XNP_SP_CONTACTS