View: HRFV_POSITIONS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_POSITIONS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, '_KF:PER:POS:PDEF'
, POS.DATE_EFFECTIVE DATE_FROM
, POS.DATE_END DATE_TO
, POS.WORKING_HOURS WORKING_HOURS_AMOUNT
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, POS.FREQUENCY) WORKING_HOURS_FREQUENCY
, POS.PROBATION_PERIOD PROBATION_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, POS.PROBATION_PERIOD_UNITS) PROBATION_UNITS
, POS.TIME_NORMAL_START NORMAL_START_TIME
, POS.TIME_NORMAL_FINISH NORMAL_END_TIME
, POS.COMMENTS COMMENTS
, POS1.NAME REPLACEMENT_POSITION_NAME
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_POSITIONS:POS'
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.JOB_ID JOB_ID
, POS.LOCATION_ID LOCATION_ID
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.POSITION_ID POSITION_ID
, PDEF.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
, POS.RELIEF_POSITION_ID RELIEF_POSITION_ID
FROM PER_POSITION_DEFINITIONS PDEF
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, HR_LOCATIONS_ALL_TL LOCT
, PER_ALL_POSITIONS POS1
, PER_ALL_POSITIONS POS
WHERE PDEF.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID
AND PDEF.ENABLED_FLAG = 'Y'
AND POS.RELIEF_POSITION_ID = POS1.POSITION_ID(+)
AND POS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND POS.JOB_ID = JOB.JOB_ID
AND POS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND POS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns