[Home] [Help]
[Dependency Information]
VIEW: APPS.HRI_CS_JOBCAT_V
Object Details
Object Name: | HRI_CS_JOBCAT_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
Creates a structure linking Job to Job Category 'HRI_CL_JOB_CAT_JOB_V'.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
JOB_ID |
NUMBER |
|
|
|
JOB_CAT_CODE |
VARCHAR2 |
(150) |
|
|
EFFECTIVE_START_DATE |
DATE |
|
|
|
EFFECTIVE_END_DATE |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT JOB_ID
, JOB_CAT_CODE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM APPS.HRI_CS_JOBCAT_V;
Dependencies
[top of page]
APPS.HRI_CS_JOBCAT_V references the following:
-
APPS
-
HR_GENERAL
- show dependent code
-
PER_JOBS
-
PER_JOB_EXTRA_INFO
-
PUBLIC
-
DUAL
APPS.HRI_CS_JOBCAT_V is referenced by following:
-
APPS
-
HRI_MD_TRN_BKG_INT_AJC_B_V
-
HRI_TO_REC_VAC_CLSD_STJC_V
-
HRI_TO_TRN_BKG_INT_AJC_V
-
HRI_TO_WMV_CJC_X_V
-
HRI_TO_WMV_EMP_TIME_JC_V
-
HRI_TO_WMV_SEP_JC_V
-
PUBLIC
-
HRI_CS_JOBCAT_V