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


VIEW: WSH.WSH_ITM_VENDORS#

Object Details
Object Name: WSH_ITM_VENDORS#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VENDOR_ID NUMBER
Yes
SERVICE_PROVIDER VARCHAR2 (100) Yes
SUPPORTS_COMBINATION_FLAG VARCHAR2 (1) Yes
EMAIL VARCHAR2 (100)
URL VARCHAR2 (100)
CONTACT_NAME VARCHAR2 (100)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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#;

Dependencies

[top of page]

WSH.WSH_ITM_VENDORS# references the following:

SchemaWSH
TableWSH_ITM_VENDORS
WSH.WSH_ITM_VENDORS# is referenced by following:

SchemaAPPS
SynonymWSH_ITM_VENDORS