View: EDWBV_HR_JOB_JOBS_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ JOB.JOB_ID || '-' || INST.INSTANCE_CODE JOB_PK
, INST.INSTANCE_CODE INSTANCE
, JOB.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' NAME
, JOB.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' JOB_DP
, 'ALL' ALL_FK
, BGR.NAME BUSINESS_GROUP_NAME
, JOB.JOB_ID JOB_ID
, BGR.ORGANIZATION_ID BUSINESS_GROUP_ID
, JDEF.JOB_DEFINITION_ID JOB_DEFINITION_ID
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 1) JOB_CAT_SET01
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 2) JOB_CAT_SET02
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 3) JOB_CAT_SET03
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 4) JOB_CAT_SET04
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 5) JOB_CAT_SET05
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 6) JOB_CAT_SET06
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 7) JOB_CAT_SET07
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 8) JOB_CAT_SET08
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 9) JOB_CAT_SET09
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 10) JOB_CAT_SET10
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 11) JOB_CAT_SET11
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 12) JOB_CAT_SET12
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 13) JOB_CAT_SET13
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 14) JOB_CAT_SET14
, HRI_EDW_DIM_JOB.FIND_JOB_CATEGORY(JOB.JOB_ID
, 15) JOB_CAT_SET15
, BJB.NAME BENCHMARK_JOB_NAME
, BJB.JOB_ID BENCHMARK_JOB_ID
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, JOB.EMP_RIGHTS_FLAG) EMP_RIGHTS_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, JOB.BENCHMARK_JOB_FLAG) BENCHMARK_JOB_FLAG
, '_DF:PER:PER_JOBS:JOB'
, '_DF:PER:JOB DEVELOPER DF:JOB'
, '_KF:PER:JOB:JDEF'
, JOB.CREATION_DATE CREATION_DATE
, GREATEST( NVL(JOB.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(JDEF.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(BGR.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
FROM PER_JOBS JOB
, PER_JOBS BJB
, PER_JOB_DEFINITIONS JDEF
, HR_ALL_ORGANIZATION_UNITS BGR
, EDW_LOCAL_INSTANCE INST
WHERE JOB.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND JOB.BENCHMARK_JOB_ID = BJB.JOB_ID (+)
AND JOB.JOB_DEFINITION_ID = JDEF.JOB_DEFINITION_ID

Columns