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: WSH.WSH_ITM_VENDOR_SERVICES

Object Details

Object Name:	WSH_ITM_VENDOR_SERVICES
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_ITM_VENDOR_SERVICES
Subobject Name:
Status:	VALID

Stores all the services provided by a Vendor(Partner ITM Applications)

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_ITM_VENDOR_SERVICES_U1	NORMAL	UNIQUE	APPS_TS_SEED	VENDOR_SERVICE_ID
WSH_ITM_VENDOR_SERVICES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	VENDOR_ID
WSH_ITM_VENDOR_SERVICES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	SERVICE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_SERVICE_ID	NUMBER		Yes	Primary Key
VENDOR_ID	NUMBER		Yes	Foreign Key to WSH_ITM_VENDORS.VENDOR_ID
SERVICE_TYPE	VARCHAR2	(35)	Yes	Lookup : WSH_ITM_SERVICE_TYPE_CODES
URL	VARCHAR2	(100)	Yes	Url to post the request
PORT	NUMBER			Port of URL to which request is posted
PROTOCOL	VARCHAR2	(10)	Yes	Method of Communication (HTTP/HTTPS)
CERTIFICATE	VARCHAR2	(100)		Certificate Name - Required Only if Protocol is HTTPS
CERTIFICATE_STORE	VARCHAR2	(100)		Storage location of the certificate - Required only if Protocol is HTTPS
CERTIFICATE_PASSWORD	VARCHAR2	(240)		Certificate Password - Required only if Protocol is HTTPS
ADDL_COUNTRY_CHECK_REQ	VARCHAR2	(1)	Yes	A Flag which indicates whether this service requires Additional(Parent) Country check.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
COMMUNICATION_MODE	VARCHAR2	(30)		Mode of communication
ACK_MODE_OF_COMM	VARCHAR2	(30)		Mode of Communication for the Acknowledgment
RES_MODE_OF_COMM	VARCHAR2	(30)		Mode of Communication for the response
OAG_CTRLAREA_VERB	VARCHAR2	(30)		OAG Verb Tag for Control Area
OAG_CTRLAREA_NOUN	VARCHAR2	(30)		OAG Nown Tag for Control Area
OAG_CTRLAREA_TASK	VARCHAR2	(30)		OAG Task Tag for Control Area
RESP_COMMUNICATION_MODE	VARCHAR2	(30)		Mode of Communication for the response
ACK_COMMUNICATION_MODE	VARCHAR2	(30)		Mode of Communication for the Acknowledgment

Query Text

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


SELECT VENDOR_SERVICE_ID
,      VENDOR_ID
,      SERVICE_TYPE
,      URL
,      PORT
,      PROTOCOL
,      CERTIFICATE
,      CERTIFICATE_STORE
,      CERTIFICATE_PASSWORD
,      ADDL_COUNTRY_CHECK_REQ
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMUNICATION_MODE
,      ACK_MODE_OF_COMM
,      RES_MODE_OF_COMM
,      OAG_CTRLAREA_VERB
,      OAG_CTRLAREA_NOUN
,      OAG_CTRLAREA_TASK
,      RESP_COMMUNICATION_MODE
,      ACK_COMMUNICATION_MODE
FROM WSH.WSH_ITM_VENDOR_SERVICES;

Dependencies

[top of page]

WSH.WSH_ITM_VENDOR_SERVICES does not reference any database object

WSH.WSH_ITM_VENDOR_SERVICES is referenced by following:

WSH: WSH_ITM_VENDOR_SERVICES#