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


VIEW: APPS.WSH_SS_PARTNER_V

Object Details
Object Name: WSH_SS_PARTNER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_SS_PARTNER_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360)
PARTNER_LOCATION VARCHAR2 (60)
PARTNER_TYPE VARCHAR2 (8)
CURRENCY VARCHAR2 (15)
DUNS_NUMBER NUMBER

INTMED_SHIP_TO_LOCATION VARCHAR2 (40)
POOLED_SHIP_TO_LOCATION VARCHAR2 (40)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
COUNTY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
REGION VARCHAR2 (120)
STATE VARCHAR2 (120)
FAX_NUMBER VARCHAR2 (60)
TELEPHONE VARCHAR2 (60)
URL VARCHAR2 (2000)
DELIVERY_ID NUMBER

Query Text

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


SELECT PARTY_NAME
,      PARTNER_LOCATION
,      PARTNER_TYPE
,      CURRENCY
,      DUNS_NUMBER
,      INTMED_SHIP_TO_LOCATION
,      POOLED_SHIP_TO_LOCATION
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTRY
,      COUNTY
,      POSTAL_CODE
,      REGION
,      STATE
,      FAX_NUMBER
,      TELEPHONE
,      URL
,      DELIVERY_ID
FROM APPS.WSH_SS_PARTNER_V;

Dependencies

[top of page]

APPS.WSH_SS_PARTNER_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
ViewORG_ORGANIZATION_DEFINITIONS
SynonymWSH_NEW_DELIVERIES

APPS.WSH_SS_PARTNER_V is not referenced by any database object