[Home] [Help]
View: EDW_HR_JOB_JOBS_LCV
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ JOB_PK
, INSTANCE
, NAME
, JOB_DP
, ALL_FK
, BUSINESS_GROUP
, JOB_ID
, BUSINESS_GROUP_ID
, JOB_DEFINITION_ID
, JOB_CAT_SET1
, JOB_CAT_SET2
, JOB_CAT_SET3
, JOB_CAT_SET4
, JOB_CAT_SET5
, JOB_CAT_SET6
, JOB_CAT_SET7
, JOB_CAT_SET8
, JOB_CAT_SET9
, JOB_CAT_SET10
, JOB_CAT_SET11
, JOB_CAT_SET12
, JOB_CAT_SET13
, JOB_CAT_SET14
, JOB_CAT_SET15
, BENCHMARK_JOB_NAME
, BENCHMARK_JOB_ID
, EMP_RIGHTS_FLAG
, BENCHMARK_JOB_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_JOB_JOBS_LCV
Columns
Name |
JOB_PK |
INSTANCE |
NAME |
JOB_DP |
ALL_FK |
BUSINESS_GROUP |
JOB_ID |
BUSINESS_GROUP_ID |
JOB_DEFINITION_ID |
JOB_CAT_SET1 |
JOB_CAT_SET2 |
JOB_CAT_SET3 |
JOB_CAT_SET4 |
JOB_CAT_SET5 |
JOB_CAT_SET6 |
JOB_CAT_SET7 |
JOB_CAT_SET8 |
JOB_CAT_SET9 |
JOB_CAT_SET10 |
JOB_CAT_SET11 |
JOB_CAT_SET12 |
JOB_CAT_SET13 |
JOB_CAT_SET14 |
JOB_CAT_SET15 |
BENCHMARK_JOB_NAME |
BENCHMARK_JOB_ID |
EMP_RIGHTS_FLAG |
BENCHMARK_JOB_FLAG |
CREATION_DATE |
LAST_UPDATE_DATE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |