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

VIEW: APPS.WSH_REGION_LOCATIONS_VL

Object Details
Object Name: WSH_REGION_LOCATIONS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_REGION_LOCATIONS_VL
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
REGION_ID NUMBER
Yes
REGION_TYPE NUMBER
Yes
LOCATION_ID NUMBER
Yes
PARENT_REGION_ID NUMBER

COUNTRY VARCHAR2 (80)
COUNTRY_REGION VARCHAR2 (60)
STATE VARCHAR2 (60)
CITY VARCHAR2 (60)
POSTAL_CODE_FROM VARCHAR2 (60)
POSTAL_CODE_TO VARCHAR2 (60)
COUNTRY_CODE VARCHAR2 (10)
COUNTRY_REGION_CODE VARCHAR2 (10)
STATE_CODE VARCHAR2 (10)
CITY_CODE VARCHAR2 (10)
PARENT_REGION_FLAG VARCHAR2 (1)
EXCEPTION_TYPE VARCHAR2 (1)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

DECONSOL_LOCATION_ID NUMBER

Query Text

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


SELECT REGION_ID
,      REGION_TYPE
,      LOCATION_ID
,      PARENT_REGION_ID
,      COUNTRY
,      COUNTRY_REGION
,      STATE
,      CITY
,      POSTAL_CODE_FROM
,      POSTAL_CODE_TO
,      COUNTRY_CODE
,      COUNTRY_REGION_CODE
,      STATE_CODE
,      CITY_CODE
,      PARENT_REGION_FLAG
,      EXCEPTION_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DECONSOL_LOCATION_ID
FROM APPS.WSH_REGION_LOCATIONS_VL;

Dependencies

[top of page]

APPS.WSH_REGION_LOCATIONS_VL references the following:

SchemaAPPS
SynonymWSH_REGIONS
SynonymWSH_REGIONS_TL
SynonymWSH_REGION_LOCATIONS
APPS.WSH_REGION_LOCATIONS_VL is referenced by following:

SchemaAPPS
Package BodyCSP_SCH_INT_PVT - show dependent code