View: EDWBV_HR_PSTN_POSITION_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ POS.POSITION_ID || '-' || INST.INSTANCE_CODE POSITION_PK
, INST.INSTANCE_CODE INSTANCE
, POS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' NAME
, POS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' POSITION_DP
, BGR.NAME BUSINESS_GROUP
, 'ALL' ALL_FK
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.JOB_ID JOB_ID
, POS.POSITION_ID POSITION_ID
, POD.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.DATE_EFFECTIVE POSITION_FROM_DATE
, POS.DATE_END POSITION_TO_DATE
, POS.PROBATION_PERIOD PROBATION_PERIOD
, POS.REPLACEMENT_REQUIRED_FLAG REPLACEMENT_REQUIRED
, POS.TIME_NORMAL_START TIME_NORMAL_START
, POS.TIME_NORMAL_FINISH TIME_NORMAL_FINISH
, POS.WORKING_HOURS WORKING_HOURS
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, POS.FREQUENCY) WORKING_HOUR_FREQ
, '_DF:PER:PER_POSITIONS:POS'
, '_KF:PER:POS:POD'
, GREATEST( NVL(POS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(BGR.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(POD.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, POS.CREATION_DATE CREATION_DATE
FROM PER_ALL_POSITIONS POS
, PER_POSITION_DEFINITIONS POD
, HR_ALL_ORGANIZATION_UNITS BGR
, EDW_LOCAL_INSTANCE INST
WHERE POS.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND POS.POSITION_DEFINITION_ID = POD.POSITION_DEFINITION_ID

Columns