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

VIEW: APPS.WSHBV_LOCATIONS

Object Details
Object Name: WSHBV_LOCATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSHBV_LOCATIONS
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
WSH_LOCATION_ID NUMBER
Yes WSH LOCATION ID
LOCATION_SOURCE_CODE VARCHAR2 (3) Yes LOCATION SOURCE CODE
LOCATION_CODE VARCHAR2 (60)
LOCATION CODE
UI_LOCATION_CODE VARCHAR2 (500)
UI LOCATION CODE
SOURCE_LOCATION_ID NUMBER
Yes SOURCE LOCATION ID
ADDRESS1 VARCHAR2 (240)
ADDRESS1
ADDRESS2 VARCHAR2 (240)
ADDRESS2
ADDRESS3 VARCHAR2 (240)
ADDRESS3
ADDRESS4 VARCHAR2 (240)
ADDRESS4
CITY VARCHAR2 (120)
CITY
STATE VARCHAR2 (120)
STATE
COUNTY VARCHAR2 (120)
COUNTY
COUNTRY VARCHAR2 (120)
COUNTRY
PROVINCE VARCHAR2 (120)
PROVINCE
POSTAL_CODE VARCHAR2 (60)
POSTAL CODE
INACTIVE_DATE DATE

INACTIVE DATE
LAST_UPDATE_DATE DATE
Yes LAST UPDATE DATE
LAST_UPDATED_BY NUMBER (15) Yes LAST UPDATED BY
CREATION_DATE DATE
Yes CREATION DATE
CREATED_BY NUMBER (15) Yes CREATED BY
LAST_UPDATE_LOGIN NUMBER (15)
LAST UPDATE LOGIN
Query Text

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


SELECT WSH_LOCATION_ID
,      LOCATION_SOURCE_CODE
,      LOCATION_CODE
,      UI_LOCATION_CODE
,      SOURCE_LOCATION_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      COUNTY
,      COUNTRY
,      PROVINCE
,      POSTAL_CODE
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.WSHBV_LOCATIONS;

Dependencies

[top of page]

APPS.WSHBV_LOCATIONS references the following:

SchemaAPPS
SynonymWSH_LOCATIONS

APPS.WSHBV_LOCATIONS is not referenced by any database object