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