eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HR_POSITION_API_V

Source

View Text - Preformatted


SELECT HAP.POSITION_ID,HAP.EFFECTIVE_START_DATE,HAP.EFFECTIVE_END_DATE,HAP.AVAILABILITY_STATUS_ID,HAP.BUSINESS_GROUP_ID,HAP.ENTRY_GRADE_ID,HAP.ENTRY_GRADE_RULE_ID,HAP.ENTRY_STEP_ID,HAP.JOB_ID,HAP.LOCATION_ID,HAP.ORGANIZATION_ID,HAP.PAY_BASIS_ID,HAP.PAY_FREQ_PAYROLL_ID,HAP.POSITION_DEFINITION_ID,HAP.POSITION_TRANSACTION_ID,HAP.PRIOR_POSITION_ID,HAP.RELIEF_POSITION_ID,HAP.SUCCESSOR_POSITION_ID,HAP.SUPERVISOR_ID,HAP.SUPERVISOR_POSITION_ID,HAP.AMENDMENT_DATE,HAP.AMENDMENT_RECOMMENDATION,HAP.AMENDMENT_REF_NUMBER,HAP.AVAIL_STATUS_PROP_END_DATE,HAP.BARGAINING_UNIT_CD,HAP.COMMENTS,HAP.COPIED_TO_OLD_TABLE_FLAG,HAP.CURRENT_JOB_PROP_END_DATE,HAP.CURRENT_ORG_PROP_END_DATE,HAP.DATE_EFFECTIVE,HAP.DATE_END,HAP.EARLIEST_HIRE_DATE,HAP.FILL_BY_DATE,HAP.FREQUENCY,HAP.FTE,HAP.MAX_PERSONS,HAP.NAME,HAP.OVERLAP_PERIOD,HAP.OVERLAP_UNIT_CD,HAP.PAY_TERM_END_DAY_CD,HAP.PAY_TERM_END_MONTH_CD,HAP.PERMANENT_TEMPORARY_FLAG,HAP.PERMIT_RECRUITMENT_FLAG,HAP.POSITION_TYPE,HAP.POSTING_DESCRIPTION,HAP.PROBATION_PERIOD,HAP.PROBATION_PERIOD_UNIT_CD,HAP.PROPOSED_FTE_FOR_LAYOFF,HAP.PROPOSED_DATE_FOR_LAYOFF,HAP.REPLACEMENT_REQUIRED_FLAG,HAP.REVIEW_FLAG,HAP.SEASONAL_FLAG,HAP.SECURITY_REQUIREMENTS,HAP.STATUS,HAP.TERM_START_DAY_CD,HAP.TERM_START_MONTH_CD,HAP.TIME_NORMAL_FINISH,HAP.TIME_NORMAL_START,HAP.UPDATE_SOURCE_CD,HAP.WORKING_HOURS,HAP.WORKS_COUNCIL_APPROVAL_FLAG,HAP.WORK_PERIOD_TYPE_CD,HAP.WORK_TERM_END_DAY_CD,HAP.WORK_TERM_END_MONTH_CD,HAP.INFORMATION1,HAP.INFORMATION2,HAP.INFORMATION3,HAP.INFORMATION4,HAP.INFORMATION5,HAP.INFORMATION6,HAP.INFORMATION7,HAP.INFORMATION8,HAP.INFORMATION9,HAP.INFORMATION10,HAP.INFORMATION11,HAP.INFORMATION12,HAP.INFORMATION13,HAP.INFORMATION14,HAP.INFORMATION15,HAP.INFORMATION16,HAP.INFORMATION17,HAP.INFORMATION18,HAP.INFORMATION19,HAP.INFORMATION20,HAP.INFORMATION21,HAP.INFORMATION22,HAP.INFORMATION23,HAP.INFORMATION24,HAP.INFORMATION25,HAP.INFORMATION26,HAP.INFORMATION27,HAP.INFORMATION28,HAP.INFORMATION29,HAP.INFORMATION30,HAP.INFORMATION_CATEGORY,HAP.ATTRIBUTE1,HAP.ATTRIBUTE2,HAP.ATTRIBUTE3,HAP.ATTRIBUTE4,HAP.ATTRIBUTE5,HAP.ATTRIBUTE6,HAP.ATTRIBUTE7,HAP.ATTRIBUTE8,HAP.ATTRIBUTE9,HAP.ATTRIBUTE10,HAP.ATTRIBUTE11,HAP.ATTRIBUTE12,HAP.ATTRIBUTE13,HAP.ATTRIBUTE14,HAP.ATTRIBUTE15,HAP.ATTRIBUTE16,HAP.ATTRIBUTE17,HAP.ATTRIBUTE18,HAP.ATTRIBUTE19,HAP.ATTRIBUTE20,HAP.ATTRIBUTE21,HAP.ATTRIBUTE22,HAP.ATTRIBUTE23,HAP.ATTRIBUTE24,HAP.ATTRIBUTE25,HAP.ATTRIBUTE26,HAP.ATTRIBUTE27,HAP.ATTRIBUTE28,HAP.ATTRIBUTE29,HAP.ATTRIBUTE30,HAP.ATTRIBUTE_CATEGORY,HAP.REQUEST_ID,HAP.PROGRAM_APPLICATION_ID,HAP.PROGRAM_ID,HAP.PROGRAM_UPDATE_DATE,HAP.CREATED_BY,HAP.CREATION_DATE,HAP.LAST_UPDATED_BY,HAP.LAST_UPDATE_DATE,HAP.LAST_UPDATE_LOGIN,HAP.OBJECT_VERSION_NUMBER,PPD.SEGMENT1,PPD.SEGMENT2,PPD.SEGMENT3,PPD.SEGMENT4,PPD.SEGMENT5,PPD.SEGMENT6,PPD.SEGMENT7,PPD.SEGMENT8,PPD.SEGMENT9,PPD.SEGMENT10,PPD.SEGMENT11,PPD.SEGMENT12,PPD.SEGMENT13,PPD.SEGMENT14,PPD.SEGMENT15,PPD.SEGMENT16,PPD.SEGMENT17,PPD.SEGMENT18,PPD.SEGMENT19,PPD.SEGMENT20,PPD.SEGMENT21,PPD.SEGMENT22,PPD.SEGMENT23,PPD.SEGMENT24,PPD.SEGMENT25,PPD.SEGMENT26,PPD.SEGMENT27,PPD.SEGMENT28,PPD.SEGMENT29,PPD.SEGMENT30 FROM HR_ALL_POSITIONS_F HAP,PER_POSITION_DEFINITIONS PPD WHERE HAP.POSITION_DEFINITION_ID = PPD.POSITION_DEFINITION_ID

View Text - HTML Formatted

SELECT HAP.POSITION_ID
, HAP.EFFECTIVE_START_DATE
, HAP.EFFECTIVE_END_DATE
, HAP.AVAILABILITY_STATUS_ID
, HAP.BUSINESS_GROUP_ID
, HAP.ENTRY_GRADE_ID
, HAP.ENTRY_GRADE_RULE_ID
, HAP.ENTRY_STEP_ID
, HAP.JOB_ID
, HAP.LOCATION_ID
, HAP.ORGANIZATION_ID
, HAP.PAY_BASIS_ID
, HAP.PAY_FREQ_PAYROLL_ID
, HAP.POSITION_DEFINITION_ID
, HAP.POSITION_TRANSACTION_ID
, HAP.PRIOR_POSITION_ID
, HAP.RELIEF_POSITION_ID
, HAP.SUCCESSOR_POSITION_ID
, HAP.SUPERVISOR_ID
, HAP.SUPERVISOR_POSITION_ID
, HAP.AMENDMENT_DATE
, HAP.AMENDMENT_RECOMMENDATION
, HAP.AMENDMENT_REF_NUMBER
, HAP.AVAIL_STATUS_PROP_END_DATE
, HAP.BARGAINING_UNIT_CD
, HAP.COMMENTS
, HAP.COPIED_TO_OLD_TABLE_FLAG
, HAP.CURRENT_JOB_PROP_END_DATE
, HAP.CURRENT_ORG_PROP_END_DATE
, HAP.DATE_EFFECTIVE
, HAP.DATE_END
, HAP.EARLIEST_HIRE_DATE
, HAP.FILL_BY_DATE
, HAP.FREQUENCY
, HAP.FTE
, HAP.MAX_PERSONS
, HAP.NAME
, HAP.OVERLAP_PERIOD
, HAP.OVERLAP_UNIT_CD
, HAP.PAY_TERM_END_DAY_CD
, HAP.PAY_TERM_END_MONTH_CD
, HAP.PERMANENT_TEMPORARY_FLAG
, HAP.PERMIT_RECRUITMENT_FLAG
, HAP.POSITION_TYPE
, HAP.POSTING_DESCRIPTION
, HAP.PROBATION_PERIOD
, HAP.PROBATION_PERIOD_UNIT_CD
, HAP.PROPOSED_FTE_FOR_LAYOFF
, HAP.PROPOSED_DATE_FOR_LAYOFF
, HAP.REPLACEMENT_REQUIRED_FLAG
, HAP.REVIEW_FLAG
, HAP.SEASONAL_FLAG
, HAP.SECURITY_REQUIREMENTS
, HAP.STATUS
, HAP.TERM_START_DAY_CD
, HAP.TERM_START_MONTH_CD
, HAP.TIME_NORMAL_FINISH
, HAP.TIME_NORMAL_START
, HAP.UPDATE_SOURCE_CD
, HAP.WORKING_HOURS
, HAP.WORKS_COUNCIL_APPROVAL_FLAG
, HAP.WORK_PERIOD_TYPE_CD
, HAP.WORK_TERM_END_DAY_CD
, HAP.WORK_TERM_END_MONTH_CD
, HAP.INFORMATION1
, HAP.INFORMATION2
, HAP.INFORMATION3
, HAP.INFORMATION4
, HAP.INFORMATION5
, HAP.INFORMATION6
, HAP.INFORMATION7
, HAP.INFORMATION8
, HAP.INFORMATION9
, HAP.INFORMATION10
, HAP.INFORMATION11
, HAP.INFORMATION12
, HAP.INFORMATION13
, HAP.INFORMATION14
, HAP.INFORMATION15
, HAP.INFORMATION16
, HAP.INFORMATION17
, HAP.INFORMATION18
, HAP.INFORMATION19
, HAP.INFORMATION20
, HAP.INFORMATION21
, HAP.INFORMATION22
, HAP.INFORMATION23
, HAP.INFORMATION24
, HAP.INFORMATION25
, HAP.INFORMATION26
, HAP.INFORMATION27
, HAP.INFORMATION28
, HAP.INFORMATION29
, HAP.INFORMATION30
, HAP.INFORMATION_CATEGORY
, HAP.ATTRIBUTE1
, HAP.ATTRIBUTE2
, HAP.ATTRIBUTE3
, HAP.ATTRIBUTE4
, HAP.ATTRIBUTE5
, HAP.ATTRIBUTE6
, HAP.ATTRIBUTE7
, HAP.ATTRIBUTE8
, HAP.ATTRIBUTE9
, HAP.ATTRIBUTE10
, HAP.ATTRIBUTE11
, HAP.ATTRIBUTE12
, HAP.ATTRIBUTE13
, HAP.ATTRIBUTE14
, HAP.ATTRIBUTE15
, HAP.ATTRIBUTE16
, HAP.ATTRIBUTE17
, HAP.ATTRIBUTE18
, HAP.ATTRIBUTE19
, HAP.ATTRIBUTE20
, HAP.ATTRIBUTE21
, HAP.ATTRIBUTE22
, HAP.ATTRIBUTE23
, HAP.ATTRIBUTE24
, HAP.ATTRIBUTE25
, HAP.ATTRIBUTE26
, HAP.ATTRIBUTE27
, HAP.ATTRIBUTE28
, HAP.ATTRIBUTE29
, HAP.ATTRIBUTE30
, HAP.ATTRIBUTE_CATEGORY
, HAP.REQUEST_ID
, HAP.PROGRAM_APPLICATION_ID
, HAP.PROGRAM_ID
, HAP.PROGRAM_UPDATE_DATE
, HAP.CREATED_BY
, HAP.CREATION_DATE
, HAP.LAST_UPDATED_BY
, HAP.LAST_UPDATE_DATE
, HAP.LAST_UPDATE_LOGIN
, HAP.OBJECT_VERSION_NUMBER
, PPD.SEGMENT1
, PPD.SEGMENT2
, PPD.SEGMENT3
, PPD.SEGMENT4
, PPD.SEGMENT5
, PPD.SEGMENT6
, PPD.SEGMENT7
, PPD.SEGMENT8
, PPD.SEGMENT9
, PPD.SEGMENT10
, PPD.SEGMENT11
, PPD.SEGMENT12
, PPD.SEGMENT13
, PPD.SEGMENT14
, PPD.SEGMENT15
, PPD.SEGMENT16
, PPD.SEGMENT17
, PPD.SEGMENT18
, PPD.SEGMENT19
, PPD.SEGMENT20
, PPD.SEGMENT21
, PPD.SEGMENT22
, PPD.SEGMENT23
, PPD.SEGMENT24
, PPD.SEGMENT25
, PPD.SEGMENT26
, PPD.SEGMENT27
, PPD.SEGMENT28
, PPD.SEGMENT29
, PPD.SEGMENT30
FROM HR_ALL_POSITIONS_F HAP
, PER_POSITION_DEFINITIONS PPD
WHERE HAP.POSITION_DEFINITION_ID = PPD.POSITION_DEFINITION_ID