[Home] [Help]
[Dependency Information]
VIEW: APPS.HRI_DBI_CL_GEO_RGN_HRCHY_V
Object Details
Object Name: | HRI_DBI_CL_GEO_RGN_HRCHY_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
List of values for Geographical Region, No Security, Includes Geography Hierarchy Parent Codes.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
VARCHAR2 |
(30) |
|
|
VALUE |
VARCHAR2 |
(4000) |
|
|
START_DATE |
DATE |
|
|
|
END_DATE |
DATE |
|
|
|
ORDER_BY |
VARCHAR2 |
(80) |
|
|
COUNTRY_CODE |
VARCHAR2 |
(30) |
|
|
VALID_FLAG_CODE |
VARCHAR2 |
(1) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, START_DATE
, END_DATE
, ORDER_BY
, COUNTRY_CODE
, VALID_FLAG_CODE
FROM APPS.HRI_DBI_CL_GEO_RGN_HRCHY_V;
Dependencies
[top of page]
APPS.HRI_DBI_CL_GEO_RGN_HRCHY_V references the following:
-
APPS
-
BIS_TERRITORY_HIERARCHIES
-
FND_GLOBAL
- show dependent code
-
FND_LOOKUPS
-
HRI_OLTP_VIEW_MESSAGE
- show dependent code
-
HR_GENERAL
- show dependent code
-
PUBLIC
-
DUAL
APPS.HRI_DBI_CL_GEO_RGN_HRCHY_V is referenced by following:
-
PUBLIC
-
HRI_DBI_CL_GEO_RGN_HRCHY_V