[Home] [Help] [Dependency Information]

VIEW: APPS.HR_POSITIONS

Object Details

Object Name:	HR_POSITIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_POSITIONS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT POSITION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      AVAILABILITY_STATUS_ID
,      BUSINESS_GROUP_ID
,      ENTRY_GRADE_ID
,      ENTRY_GRADE_RULE_ID
,      ENTRY_STEP_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAY_FREQ_PAYROLL_ID
,      POSITION_DEFINITION_ID
,      DATE_EFFECTIVE_POS_DEF_ID
,      POSITION_TRANSACTION_ID
,      PRIOR_POSITION_ID
,      RELIEF_POSITION_ID
,      SUCCESSOR_POSITION_ID
,      SUPERVISOR_POSITION_ID
,      AMENDMENT_DATE
,      AMENDMENT_RECOMMENDATION
,      AMENDMENT_REF_NUMBER
,      BARGAINING_UNIT_CD
,      COMMENTS
,      CURRENT_JOB_PROP_END_DATE
,      CURRENT_ORG_PROP_END_DATE
,      AVAIL_STATUS_PROP_END_DATE
,      DATE_EFFECTIVE
,      DATE_END
,      EARLIEST_HIRE_DATE
,      FILL_BY_DATE
,      FREQUENCY
,      FTE
,      MAX_PERSONS
,      NAME
,      DATE_EFFECTIVE_NAME
,      OVERLAP_PERIOD
,      OVERLAP_UNIT_CD
,      PAY_TERM_END_DAY_CD
,      PAY_TERM_END_MONTH_CD
,      PERMANENT_TEMPORARY_FLAG
,      PERMIT_RECRUITMENT_FLAG
,      POSITION_TYPE
,      POSTING_DESCRIPTION
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNIT_CD
,      PROPOSED_FTE_FOR_LAYOFF
,      PROPOSED_DATE_FOR_LAYOFF
,      REPLACEMENT_REQUIRED_FLAG
,      REVIEW_FLAG
,      SEASONAL_FLAG
,      SECURITY_REQUIREMENTS
,      STATUS
,      TERM_START_DAY_CD
,      TERM_START_MONTH_CD
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      UPDATE_SOURCE_CD
,      WORKING_HOURS
,      WORKS_COUNCIL_APPROVAL_FLAG
,      WORK_PERIOD_TYPE_CD
,      WORK_TERM_END_DAY_CD
,      WORK_TERM_END_MONTH_CD
,      PAY_BASIS_ID
,      SUPERVISOR_ID
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM APPS.HR_POSITIONS;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

FND_SESSIONS

HR_GENERAL - show dependent code

HR_POSITIONS_F

HR_SECURITY - show dependent code

APPS

HRWSECI - show dependent code

HR_POSITIONS_LOV_V

HR_PSF_BUS - show dependent code

HR_PSF_BUS - show dependent code

HR_REPORTS - show dependent code

PER_FULL_SALARY_HISTORY_V

PER_GRADES_PKG - show dependent code

PER_MM_POSITIONS_PKG - show dependent code

PER_MM_POSITIONS_V

PER_POSITIONS_LOV_V

PER_SUC_BUS - show dependent code

PQH_APPLY_BUDGET - show dependent code

PQH_BUDGET - show dependent code

PQH_GL_POSTING - show dependent code

PQH_PTX_UTL - show dependent code

PQH_WKS_BUDGET - show dependent code

PQH_WKS_ERROR_CHK - show dependent code