VIEW: APPS.EDWBV_HR_PSTN_POSITION_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvps.odf 115.5 2001/11/01 01:21:24 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

View Text - HTML Formatted

SELECT /* $HEADER: HRISVPS.ODF 115.5 2001/11/01 01:21:24 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