Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_POSITION_TRANSACTIONS_V |
SELECT PTX.POSITION_TRANSACTION_ID
, PTX.ACTION_DATE
, PTX.REVIEW_FLAG
, PTX.DATE_EFFECTIVE
, PTX.DATE_EFFECTIVE START_DATE
, PTX.DATE_END
, PTX.DATE_END END_DATE
, PTX.NAME
, HR_GENERAL.DECODE_LOOKUP('POSITION_TYPE'
, PTX.POSITION_TYPE) POSITION_TYPE_DESC
, PTX.POSITION_TYPE
, PTX.PERMANENT_TEMPORARY_FLAG
, PTX.SEASONAL_FLAG
, HR_GENERAL.DECODE_LOCATION(PTX.LOCATION_ID) LOCATION_DESC
, PTX.LOCATION_ID
, HR_GENERAL.DECODE_ORGANIZATION(PTX.ORGANIZATION_ID) ORGANIZATION_DESC
, PTX.ORGANIZATION_ID
, PTX.CURRENT_ORG_PROP_END_DATE
, HR_GENERAL.DECODE_JOB(PTX.JOB_ID) JOB_DESC
, PTX.JOB_ID
, PTX.CURRENT_JOB_PROP_END_DATE
, HR_GENERAL.DECODE_AVAILABILITY_STATUS(PTX.AVAILABILITY_STATUS_ID) AVAILABILITY_STATUS_DESC
, PTX.AVAILABILITY_STATUS_ID
, PTX.AVAIL_STATUS_PROP_END_DATE
, PTX.FTE
, HR_GENERAL.DECODE_LOOKUP('PER_FTE_CAPACITY'
, PTX.FTE_CAPACITY) FTE_CAPACITY_MEANING
, PTX.FTE_CAPACITY
, PTX.MAX_PERSONS
, PTX.EARLIEST_HIRE_DATE
, PTX.FILL_BY_DATE
, PTX.PERMIT_RECRUITMENT_FLAG
, PTX.REPLACEMENT_REQUIRED_FLAG
, PTX.PROPOSED_FTE_FOR_LAYOFF
, PTX.PROPOSED_DATE_FOR_LAYOFF
, HR_GENERAL.DECODE_LOOKUP('BARGAINING_UNIT_CODE'
, PTX.BARGAINING_UNIT_CD) BARGAINING_UNIT_DESC
, PTX.BARGAINING_UNIT_CD
, HR_GENERAL.DECODE_PAYROLL(PTX.PAY_FREQ_PAYROLL_ID) PAYROLL_DESC
, PTX.PAY_FREQ_PAYROLL_ID
, HR_GENERAL.DECODE_PAY_BASIS(PTX.PAY_BASIS_ID) PAY_BASIS_DESC
, PTX.PAY_BASIS_ID
, HR_GENERAL.DECODE_GRADE(PTX.ENTRY_GRADE_ID) GRADE_DESC
, PTX.ENTRY_GRADE_ID
, HR_GENERAL.DECODE_STEP(PTX.ENTRY_STEP_ID
, PTX.DATE_EFFECTIVE) STEP_DESC
, PTX.ENTRY_STEP_ID
, PQH_UTILITY.DECODE_GRADE_RULE(PTX.ENTRY_GRADE_RULE_ID
, 'VALUE') POINT_VALUE
, HR_GENERAL.DECODE_GRADE_RULE(PTX.ENTRY_GRADE_RULE_ID) GRADE_RATE_VALUE
, PTX.ENTRY_GRADE_RULE_ID
, PQH_UTILITY.DECODE_GRADE_RULE(PTX.ENTRY_GRADE_RULE_ID
, 'MIN') GRADE_RATE_MIN
, PQH_UTILITY.DECODE_GRADE_RULE(PTX.ENTRY_GRADE_RULE_ID
, 'MID') GRADE_RATE_MID
, PQH_UTILITY.DECODE_GRADE_RULE(PTX.ENTRY_GRADE_RULE_ID
, 'MAX') GRADE_RATE_MAX
, PTX.PROBATION_PERIOD
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PTX.PROBATION_PERIOD_UNIT_CD) PROBATION_UNIT_DESC
, PTX.PROBATION_PERIOD_UNIT_CD
, PTX.OVERLAP_PERIOD
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PTX.OVERLAP_UNIT_CD) OVERLAP_UNIT_DESC
, PTX.OVERLAP_UNIT_CD
, PTX.WORKING_HOURS
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PTX.FREQUENCY) FREQUENCY_DESC
, PTX.FREQUENCY
, PTX.TIME_NORMAL_START
, PTX.TIME_NORMAL_FINISH
, HR_GENERAL.DECODE_LOOKUP('PER_LENGTHS_OF_SERVICE'
, PTX.SERVICE_MINIMUM) MINIMUM_SERVICE_DESC
, PTX.SERVICE_MINIMUM
, HR_GENERAL.DECODE_LOOKUP('PER_WORK_SCHEDULE'
, PTX.WORK_SCHEDULE) WORK_SCHEDULE_DESC
, PTX.WORK_SCHEDULE
, HR_GENERAL.DECODE_LOOKUP('PER_TIME_SCALES'
, PTX.WORK_DURATION) WORK_DURATION_DESC
, PTX.WORK_DURATION
, HR_GENERAL.DECODE_PERSON_NAME(PTX.SUPERVISOR_ID) SUPERVISOR_DESC
, PTX.SUPERVISOR_ID
, PTX.WORKS_COUNCIL_APPROVAL_FLAG
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PTX.SUPERVISOR_POSITION_ID) SUPERVISOR_POSITION_NAME
, PTX.SUPERVISOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PTX.RELIEF_POSITION_ID) RELIEF_POSITION_NAME
, PTX.RELIEF_POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PTX.SUCCESSOR_POSITION_ID) SUCCESSOR_POSITION_NAME
, PTX.SUCCESSOR_POSITION_ID
, PTX.WORK_PERIOD_TYPE_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PTX.TERM_START_DAY_CD) TERM_START_DAY
, PTX.TERM_START_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PTX.TERM_START_MONTH_CD) TERM_START_MONTH
, PTX.TERM_START_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PTX.WORK_TERM_END_DAY_CD) WORK_TERM_END_DAY
, PTX.WORK_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PTX.WORK_TERM_END_MONTH_CD) WORK_TERM_END_MONTH
, PTX.WORK_TERM_END_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PTX.PAY_TERM_END_DAY_CD) PAY_TERM_END_DAY
, PTX.PAY_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PTX.PAY_TERM_END_MONTH_CD) PAY_TERM_END_MONTH
, PTX.PAY_TERM_END_MONTH_CD
, PTX.WORK_ANY_LOCATION
, PTX.RELOCATE_DOMESTICALLY
, PTX.TRAVEL_REQUIRED
, HR_GENERAL.DECODE_LOCATION(PTX.LOCATION1) LOCATION1_DESC
, PTX.LOCATION1
, HR_GENERAL.DECODE_LOCATION(PTX.LOCATION2) LOCATION2_DESC
, PTX.LOCATION2
, HR_GENERAL.DECODE_LOCATION(PTX.LOCATION3) LOCATION3_DESC
, PTX.LOCATION3
, PTX.WORK_ANY_COUNTRY
, PTX.RELOCATE_INTERNATIONALLY
, PTX.PASSPORT_REQUIRED
, HR_GENERAL.DECODE_TERRITORY(PTX.COUNTRY1) COUNTRY1_DESC
, PTX.COUNTRY1
, HR_GENERAL.DECODE_TERRITORY(PTX.COUNTRY2) COUNTRY2_DESC
, PTX.COUNTRY2
, HR_GENERAL.DECODE_TERRITORY(PTX.COUNTRY3) COUNTRY3_DESC
, PTX.COUNTRY3
, PTX.OTHER_REQUIREMENTS
, PTX.COMMENTS
, PTX.POSTING_DESCRIPTION
, PTX.SECURITY_REQUIREMENTS
, PTX.AMENDMENT_DATE
, PTX.AMENDMENT_REF_NUMBER
, PTX.AMENDMENT_RECOMMENDATION
, PTX.POSITION_ID
, PTX.POSITION_DEFINITION_ID
, PTX.PRIOR_POSITION_ID
, PTX.BUSINESS_GROUP_ID
, DECODE(NVL(WF_TRANSACTION_CATEGORY_ID
, -1)
, -1
, PQH_UTILITY.GET_TRANSACTION_CATEGORY_ID('POSITION_TRANSACTION')
, WF_TRANSACTION_CATEGORY_ID) WF_TRANSACTION_CATEGORY_ID
, PTX.INFORMATION1
, PTX.INFORMATION2
, PTX.INFORMATION3
, PTX.INFORMATION4
, PTX.INFORMATION5
, PTX.INFORMATION6
, PTX.INFORMATION7
, PTX.INFORMATION8
, PTX.INFORMATION9
, PTX.INFORMATION10
, PTX.INFORMATION11
, PTX.INFORMATION12
, PTX.INFORMATION13
, PTX.INFORMATION14
, PTX.INFORMATION15
, PTX.INFORMATION16
, PTX.INFORMATION17
, PTX.INFORMATION18
, PTX.INFORMATION19
, PTX.INFORMATION20
, PTX.INFORMATION21
, PTX.INFORMATION22
, PTX.INFORMATION23
, PTX.INFORMATION24
, PTX.INFORMATION25
, PTX.INFORMATION26
, PTX.INFORMATION27
, PTX.INFORMATION28
, PTX.INFORMATION29
, PTX.INFORMATION30
, PTX.INFORMATION_CATEGORY
, PTX.ATTRIBUTE1
, PTX.ATTRIBUTE2
, PTX.ATTRIBUTE3
, PTX.ATTRIBUTE4
, PTX.ATTRIBUTE5
, PTX.ATTRIBUTE6
, PTX.ATTRIBUTE7
, PTX.ATTRIBUTE8
, PTX.ATTRIBUTE9
, PTX.ATTRIBUTE10
, PTX.ATTRIBUTE11
, PTX.ATTRIBUTE12
, PTX.ATTRIBUTE13
, PTX.ATTRIBUTE14
, PTX.ATTRIBUTE15
, PTX.ATTRIBUTE16
, PTX.ATTRIBUTE17
, PTX.ATTRIBUTE18
, PTX.ATTRIBUTE19
, PTX.ATTRIBUTE20
, PTX.ATTRIBUTE21
, PTX.ATTRIBUTE22
, PTX.ATTRIBUTE23
, PTX.ATTRIBUTE24
, PTX.ATTRIBUTE25
, PTX.ATTRIBUTE26
, PTX.ATTRIBUTE27
, PTX.ATTRIBUTE28
, PTX.ATTRIBUTE29
, PTX.ATTRIBUTE30
, PTX.ATTRIBUTE_CATEGORY
, PTX.TRANSACTION_STATUS
, PTX.CREATED_BY
, PTX.CREATION_DATE
, PTX.LAST_UPDATED_BY
, PTX.LAST_UPDATE_DATE
, PTX.LAST_UPDATE_LOGIN
, PTX.OBJECT_VERSION_NUMBER
FROM PQH_POSITION_TRANSACTIONS PTX