View: PER_POSITIONS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_POSITIONS_V

View Text

SELECT POS.POSITION_ID
, POS.ROWID
, POS.BUSINESS_GROUP_ID
, POS.JOB_ID
, JBT.NAME
, POS.ORGANIZATION_ID
, ORGTL.NAME
, POS.SUCCESSOR_POSITION_ID
, PFT3.NAME
, POS.RELIEF_POSITION_ID
, PFT2.NAME
, POS.LOCATION_ID
, LOC.LOCATION_CODE
, POS.POSITION_DEFINITION_ID
, POS.DATE_EFFECTIVE
, POS.COMMENTS
, POS.DATE_END
, POS.FREQUENCY
, HRL.MEANING
, POS.NAME
, POS.PROBATION_PERIOD
, POS.PROBATION_PERIOD_UNITS
, HRL3.MEANING
, POS.REPLACEMENT_REQUIRED_FLAG
, HRL2.MEANING
, POS.STATUS
, HRL4.MEANING
, POS.TIME_NORMAL_FINISH
, POS.TIME_NORMAL_START
, POS.WORKING_HOURS
, POS.REQUEST_ID
, POS.PROGRAM_APPLICATION_ID
, POS.PROGRAM_ID
, POS.PROGRAM_UPDATE_DATE
, POS.ATTRIBUTE_CATEGORY
, POS.ATTRIBUTE1
, POS.ATTRIBUTE2
, POS.ATTRIBUTE3
, POS.ATTRIBUTE4
, POS.ATTRIBUTE5
, POS.ATTRIBUTE6
, POS.ATTRIBUTE7
, POS.ATTRIBUTE8
, POS.ATTRIBUTE9
, POS.ATTRIBUTE10
, POS.ATTRIBUTE11
, POS.ATTRIBUTE12
, POS.ATTRIBUTE13
, POS.ATTRIBUTE14
, POS.ATTRIBUTE15
, POS.ATTRIBUTE16
, POS.ATTRIBUTE17
, POS.ATTRIBUTE18
, POS.ATTRIBUTE19
, POS.ATTRIBUTE20
, POS.LAST_UPDATE_DATE
, POS.LAST_UPDATED_BY
, POS.LAST_UPDATE_LOGIN
, POS.CREATED_BY
, POS.CREATION_DATE
FROM PER_POSITIONS POS
, PER_ALL_POSITIONS POS2
, HR_ALL_POSITIONS_F_TL PFT2
, PER_ALL_POSITIONS POS3
, HR_ALL_POSITIONS_F_TL PFT3
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PER_JOBS_TL JBT
, HR_LOCATIONS LOC
, HR_LOOKUPS HRL
, HR_LOOKUPS HRL2
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
WHERE ORG.ORGANIZATION_ID = POS.ORGANIZATION_ID
AND JBT.JOB_ID = POS.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND LOC.LOCATION_ID (+) = POS.LOCATION_ID
AND HRL.LOOKUP_CODE (+) = POS.FREQUENCY
AND HRL.LOOKUP_TYPE (+) = 'FREQUENCY'
AND HRL2.LOOKUP_CODE (+) = POS.REPLACEMENT_REQUIRED_FLAG
AND HRL2.LOOKUP_TYPE (+) = 'YES_NO'
AND HRL3.LOOKUP_CODE (+) = POS.PROBATION_PERIOD_UNITS
AND HRL3.LOOKUP_TYPE (+) = 'QUALIFYING_UNITS'
AND HRL4.LOOKUP_CODE (+) = POS.STATUS
AND HRL4.LOOKUP_TYPE (+) = 'POSITION_STATUS'
AND POS2.POSITION_ID (+) = POS.RELIEF_POSITION_ID
AND PFT2.POSITION_ID (+) = POS.RELIEF_POSITION_ID
AND PFT2.LANGUAGE(+) = USERENV('LANG')
AND POS3.POSITION_ID (+) = POS.SUCCESSOR_POSITION_ID
AND PFT3.POSITION_ID (+) = POS.SUCCESSOR_POSITION_ID
AND PFT3.LANGUAGE(+) = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG')

Columns