[Home] [Help] [Dependency Information]
Object Name: | MSC_REGION_LOCATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|