VIEW: APPS.PER_POSITIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')