VIEW: APPS.HR_ALL_POSITIONS_F_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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