eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSC_REGION_LOCATIONS_V

Object Details

Object Name:	MSC_REGION_LOCATIONS_V
Object Type:	VIEW
Owner:	APPS
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	Comments
REGION_ID	NUMBER		Region Indentifier. Foreign key to WSH_REGIONS.REGION_ID
LOCATION_ID	NUMBER		Location Identifier. Foreign key to either HR_LOCATIONS.LOCATION_ID OR HZ_LOCATIONS.LOCATION_ID
LOCATION_SOURCE	VARCHAR2	(4)	Source Location
REGION_TYPE	NUMBER		Region type
PARENT_REGION_FLAG	VARCHAR2	(1)	Parent region flag
SR_INSTANCE_ID	NUMBER		Source instance id
PARTNER_TYPE	NUMBER		Partner type

Query Text

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


SELECT REGION_ID
,      LOCATION_ID
,      LOCATION_SOURCE
,      REGION_TYPE
,      PARENT_REGION_FLAG
,      SR_INSTANCE_ID
,      PARTNER_TYPE
FROM APPS.MSC_REGION_LOCATIONS_V;

Dependencies

[top of page]

APPS.MSC_REGION_LOCATIONS_V references the following:

APPS: MSC_REGIONS; MSC_REGION_LOCATIONS; MSC_ZONE_REGIONS

APPS.MSC_REGION_LOCATIONS_V is referenced by following:

APPS: MSC_ORGCUSTOMER_SHIP_METHODS_V