VIEW: APPS.PQH_POSITION_TRANSACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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