[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_GEOGRAPHY |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_GEOGRAPHY |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_DIMV_GEOGRAPHY is a view showing locations at the postal code level.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_HIERARCHY_CODE | VARCHAR2 | (240) | location hierarchy code | |
LAST_UPDATE_DATE | DATE | last update date | ||
COUNTRY | VARCHAR2 | (80) | event country | |
COUNTRY_CODE | VARCHAR2 | (60) | country code | |
STATE | VARCHAR2 | (80) | state | |
STATE_CODE | VARCHAR2 | (60) | state code | |
CITY | VARCHAR2 | (80) | city | |
CITY_CODE | VARCHAR2 | (60) | city code | |
POSTAL_CODE | VARCHAR2 | (80) | postal code | |
POSTAL_CODE_VALUE | VARCHAR2 | (60) | postal code value |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_HIERARCHY_CODE
, LAST_UPDATE_DATE
, COUNTRY
, COUNTRY_CODE
, STATE
, STATE_CODE
, CITY
, CITY_CODE
, POSTAL_CODE
, POSTAL_CODE_VALUE
FROM APPS.BIM_DIMV_GEOGRAPHY;
APPS.BIM_DIMV_GEOGRAPHY is not referenced by any database object
|
|
|