[Home] [Help] [Dependency Information]
Object Name: | HRI_OBI_CL_GEO_LOCATION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOC_LOCATION_PK | NUMBER | (22) | Yes | Location Id |
LOC_LOCATION_NAME | VARCHAR2 | (4000) | ||
LOC_LOCATION_NAME_UNQ | VARCHAR2 | (4000) | ||
LOC_ORDER_BY | VARCHAR2 | (60) | ||
LOC_AREA_FK | VARCHAR2 | (40) | Yes | |
LOC_COUNTRY_FK | VARCHAR2 | (70) | Yes | |
LOC_REGION_FK | VARCHAR2 | (280) | Yes | |
LOC_CITY_FK | VARCHAR2 | (303) |
Cut, paste (and edit) the following text to query this object:
SELECT LOC_LOCATION_PK
, LOC_LOCATION_NAME
, LOC_LOCATION_NAME_UNQ
, LOC_ORDER_BY
, LOC_AREA_FK
, LOC_COUNTRY_FK
, LOC_REGION_FK
, LOC_CITY_FK
FROM APPS.HRI_OBI_CL_GEO_LOCATION_V;
APPS.HRI_OBI_CL_GEO_LOCATION_V is not referenced by any database object
|
|
|