View: HR_POSITION_API_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_POSITION_API_V

View Text

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

Columns