[Home] [Help]
[Dependency Information]
VIEW: APPS.HRI_CL_JOB_CAT_JOB_V
Object Details
Object Name: | HRI_CL_JOB_CAT_JOB_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
List of values for Job Category, plus null row.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ID |
NUMBER |
|
|
|
VALUE |
VARCHAR2 |
(80) |
|
|
START_DATE |
DATE |
|
|
|
END_DATE |
DATE |
|
|
|
JOB_ID |
NUMBER |
|
|
|
JOB_CAT_CODE |
VARCHAR2 |
(150) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, START_DATE
, END_DATE
, JOB_ID
, JOB_CAT_CODE
FROM APPS.HRI_CL_JOB_CAT_JOB_V;
Dependencies
[top of page]
APPS.HRI_CL_JOB_CAT_JOB_V references the following:
-
APPS
-
FND_GLOBAL
- show dependent code
-
HR_API
- show dependent code
-
HR_GENERAL
- show dependent code
-
HR_LOOKUPS
-
PER_JOBS
-
PER_JOB_EXTRA_INFO
-
PUBLIC
-
DUAL
APPS.HRI_CL_JOB_CAT_JOB_V is referenced by following:
-
PUBLIC
-
HRI_CL_JOB_CAT_JOB_V