[Home] [Help] [Dependency Information]
Object Name: | WSH_ITM_VENDORS |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_ITM_VENDORS |
Subobject Name: | |
Status: | VALID |
This table stores the list of all the partner ITM Applications.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_ITM_VENDORS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | VENDOR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_ID | NUMBER | Yes | Primary Key | |
SERVICE_PROVIDER | VARCHAR2 | (100) | Yes | Name of the partner ITM Application |
SUPPORTS_COMBINATION_FLAG | VARCHAR2 | (1) | Yes | Y/N. This flag is set to 'Y' when the partner can support a combination of services in a single request. Ex: If the partner supports DP,EM and LD and if this flag is set to 'Y' then the partner should support a request for any combination l |
VARCHAR2 | (100) | Contact Email of the partner | ||
URL | VARCHAR2 | (100) | URL | |
CONTACT_NAME | VARCHAR2 | (100) | Contact Name | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, SERVICE_PROVIDER
, SUPPORTS_COMBINATION_FLAG
, EMAIL
, URL
, CONTACT_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM WSH.WSH_ITM_VENDORS;
WSH.WSH_ITM_VENDORS does not reference any database object
WSH.WSH_ITM_VENDORS is referenced by following:
|
|
|