[Home] [Help]
[Dependency Information]
VIEW: APPS.HRI_CL_LOC_HR_B_V
Object Details
Object Name: | HRI_CL_LOC_HR_B_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
List of values for HR Location, plus null row with Business Group Security.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
NUMBER |
|
|
|
VALUE |
VARCHAR2 |
(60) |
|
|
START_DATE |
DATE |
|
|
|
END_DATE |
DATE |
|
|
|
BUSINESS_GROUP_ID |
NUMBER |
|
|
|
GLOBAL_FLAG |
VARCHAR2 |
(6) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, START_DATE
, END_DATE
, BUSINESS_GROUP_ID
, GLOBAL_FLAG
FROM APPS.HRI_CL_LOC_HR_B_V;
Dependencies
[top of page]
APPS.HRI_CL_LOC_HR_B_V references the following:
-
APPS
-
HR_BIS
- show dependent code
-
HR_GENERAL
- show dependent code
-
HR_LOCATIONS_ALL
-
HR_LOCATIONS_ALL_TL
-
PUBLIC
-
DUAL
APPS.HRI_CL_LOC_HR_B_V is referenced by following:
-
PUBLIC
-
HRI_CL_LOC_HR_B_V