eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GHR_POSITIONS_H_V

Source

View Text - Preformatted


SELECT PA_HISTORY_ID , PROCESS_DATE , EFFECTIVE_DATE , DML_OPERATION , PRE_VALUES_FLAG , ALTERED_PA_REQUEST_ID , PA_REQUEST_ID , NATURE_OF_ACTION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION1) POSITION_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION4) DATE_EFFECTIVE , FND_DATE.CANONICAL_TO_DATE(INFORMATION5) DATE_END , SUBSTR(INFORMATION6,1,240) NAME , GHR_GENERAL.RETURN_NUMBER(INFORMATION7) RELIEF_POSITION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION8) LOCATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION9) POSITION_DEFINITION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION10) JOB_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION12) ORGANIZATION_ID , SUBSTR(INFORMATION13,1,30) FREQUENCY , GHR_GENERAL.RETURN_NUMBER(INFORMATION14) SUCCESSOR_POSITION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION15) PROBATION_PERIOD , SUBSTR(INFORMATION16,1,30) PROBATION_PERIOD_UNIT_CD , SUBSTR(INFORMATION17,1,30) REPLACEMENT_REQUIRED_FLAG , SUBSTR(INFORMATION18,1,5) TIME_NORMAL_FINISH , SUBSTR(INFORMATION19,1,5) TIME_NORMAL_START , GHR_GENERAL.RETURN_NUMBER(INFORMATION20) WORKING_HOURS , FND_DATE.CANONICAL_TO_DATE(INFORMATION21) AMENDMENT_DATE ,SUBSTR(INFORMATION22,1,255) AMENDMENT_RECOMMENDATION ,SUBSTR(INFORMATION23,1,30) AMENDMENT_REF_NUMBER , GHR_GENERAL.RETURN_NUMBER(INFORMATION24) AVAILABILITY_STATUS_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION25)AVAIL_STATUS_PROP_END_DATE ,SUBSTR(INFORMATION26,1,30)BARGAINING_UNIT_CD ,SUBSTR(INFORMATION27,1,30)COPIED_TO_OLD_TABLE_FLAG , FND_DATE.CANONICAL_TO_DATE(INFORMATION28) EARLIEST_HIRE_DATE , GHR_GENERAL.RETURN_NUMBER(INFORMATION29) ENTRY_GRADE_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION30) ENTRY_GRADE_RULE_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION31) ENTRY_STEP_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION32) FILL_BY_DATE , GHR_GENERAL.RETURN_NUMBER(INFORMATION33) FTE , GHR_GENERAL.RETURN_NUMBER(INFORMATION34) MAX_PERSONS , GHR_GENERAL.RETURN_NUMBER(INFORMATION35) OVERLAP_PERIOD ,SUBSTR(INFORMATION36,1,30) OVERLAP_UNIT_CD , GHR_GENERAL.RETURN_NUMBER(INFORMATION37) PAY_BASIS_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION38) PAY_FREQ_PAYROLL_ID ,SUBSTR(INFORMATION39,1,30) PAY_TERM_END_DAY_CD ,SUBSTR(INFORMATION40,1,30) PAY_TERM_END_MONTH_CD ,SUBSTR(INFORMATION41,1,30) PERMANENT_TEMPORARY_FLAG ,SUBSTR(INFORMATION42,1,30) PERMIT_RECRUITMENT_FLAG , GHR_GENERAL.RETURN_NUMBER(INFORMATION43) POSITION_TRANSACTION_ID ,SUBSTR(INFORMATION44,1,30) POSITION_TYPE ,SUBSTR(INFORMATION45,1,255) POSTING_DESCRIPTION , GHR_GENERAL.RETURN_NUMBER(INFORMATION46) PRIOR_POSITION_ID ,SUBSTR(INFORMATION47,1,30) REVIEW_FLAG ,SUBSTR(INFORMATION48,1,30) SEASONAL_FLAG ,SUBSTR(INFORMATION49,1,255) SECURITY_REQUIREMENTS , GHR_GENERAL.RETURN_NUMBER(INFORMATION50) SUPERVISOR_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION51) SUPERVISOR_POSITION_ID ,SUBSTR(INFORMATION52,1,30) TERM_START_DAY_CD ,SUBSTR(INFORMATION53,1,30) TERM_START_MONTH_CD ,SUBSTR(INFORMATION54,1,30) UPDATE_SOURCE_CD ,SUBSTR(INFORMATION55,1,30) WORKS_COUNCIL_APPROVAL_FLAG ,SUBSTR(INFORMATION56,1,30) WORK_PERIOD_TYPE_CD ,SUBSTR(INFORMATION57,1,30) WORK_TERM_END_DAY_CD ,SUBSTR(INFORMATION58,1,30) WORK_TERM_END_MONTH_CD , FND_DATE.CANONICAL_TO_DATE(INFORMATION59) CURRENT_JOB_PROP_END_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION60) CURRENT_ORG_PROP_END_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION61) PROPOSED_DATE_FOR_LAYOFF , GHR_GENERAL.RETURN_NUMBER(INFORMATION62) PROPOSED_FTE_FOR_LAYOFF ,SUBSTR(INFORMATION63,1,255) POSITION_DESCRIPTION , SUBSTR(INFORMATION121,1,30) STATUS , GHR_GENERAL.RETURN_NUMBER(INFORMATION122) BUSINESS_GROUP_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION123) REQUEST_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION124) PROGRAM_APPLICATION_ID , TO_NUMBER(INFORMATION125) PROGRAM_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION126)PROGRAM_UPDATE_DATE , SUBSTR(INFORMATION127,1,30) ATTRIBUTE_CATEGORY , SUBSTR(INFORMATION128,1,150) ATTRIBUTE1 , SUBSTR(INFORMATION129,1,150) ATTRIBUTE2 , SUBSTR(INFORMATION130,1,150) ATTRIBUTE3 , SUBSTR(INFORMATION131,1,150) ATTRIBUTE4 , SUBSTR(INFORMATION132,1,150) ATTRIBUTE5 , SUBSTR(INFORMATION133,1,150) ATTRIBUTE6 , SUBSTR(INFORMATION134,1,150) ATTRIBUTE7 , SUBSTR(INFORMATION135,1,150) ATTRIBUTE8 , SUBSTR(INFORMATION136,1,150) ATTRIBUTE9 , SUBSTR(INFORMATION137,1,150) ATTRIBUTE10 , SUBSTR(INFORMATION138,1,150) ATTRIBUTE11 , SUBSTR(INFORMATION139,1,150) ATTRIBUTE12 , SUBSTR(INFORMATION140,1,150) ATTRIBUTE13 , SUBSTR(INFORMATION141,1,150) ATTRIBUTE14 , SUBSTR(INFORMATION142,1,150) ATTRIBUTE15 , SUBSTR(INFORMATION143,1,150) ATTRIBUTE16 , SUBSTR(INFORMATION144,1,150) ATTRIBUTE17 , SUBSTR(INFORMATION145,1,150) ATTRIBUTE18 , SUBSTR(INFORMATION146,1,150) ATTRIBUTE19 , SUBSTR(INFORMATION147,1,150) ATTRIBUTE20 , SUBSTR(INFORMATION148,1,150) ATTRIBUTE21 , SUBSTR(INFORMATION149,1,150) ATTRIBUTE22 , SUBSTR(INFORMATION150,1,150) ATTRIBUTE23 , SUBSTR(INFORMATION151,1,150) ATTRIBUTE24 , SUBSTR(INFORMATION152,1,150) ATTRIBUTE25 , SUBSTR(INFORMATION153,1,150) ATTRIBUTE26 , SUBSTR(INFORMATION154,1,150) ATTRIBUTE27 , SUBSTR(INFORMATION155,1,150) ATTRIBUTE28 , SUBSTR(INFORMATION156,1,150) ATTRIBUTE29 , SUBSTR(INFORMATION157,1,150) ATTRIBUTE30 , SUBSTR(INFORMATION158,1,150) INFORMATION_CATEGORY , SUBSTR(INFORMATION159,1,150) INFORMATION1 , SUBSTR(INFORMATION160,1,150) INFORMATION2 , SUBSTR(INFORMATION161,1,150) INFORMATION3 , SUBSTR(INFORMATION162,1,150) INFORMATION4 , SUBSTR(INFORMATION163,1,150) INFORMATION5 , SUBSTR(INFORMATION164,1,150) INFORMATION6 , SUBSTR(INFORMATION165,1,150) INFORMATION7 , SUBSTR(INFORMATION166,1,150) INFORMATION8 , SUBSTR(INFORMATION167,1,150) INFORMATION9 , SUBSTR(INFORMATION168,1,150) INFORMATION10 , SUBSTR(INFORMATION169,1,150) INFORMATION11 , SUBSTR(INFORMATION170,1,150) INFORMATION12 , SUBSTR(INFORMATION171,1,150) INFORMATION13 , SUBSTR(INFORMATION172,1,150) INFORMATION14 , SUBSTR(INFORMATION173,1,150) INFORMATION15 , SUBSTR(INFORMATION174,1,150) INFORMATION16 , SUBSTR(INFORMATION175,1,150) INFORMATION17 , SUBSTR(INFORMATION176,1,150) INFORMATION18 , SUBSTR(INFORMATION177,1,150) INFORMATION19 , SUBSTR(INFORMATION178,1,150) INFORMATION20 , SUBSTR(INFORMATION179,1,150) INFORMATION21 , SUBSTR(INFORMATION180,1,150) INFORMATION22 , SUBSTR(INFORMATION181,1,150) INFORMATION23 , SUBSTR(INFORMATION182,1,150) INFORMATION24 , SUBSTR(INFORMATION183,1,150) INFORMATION25 , SUBSTR(INFORMATION184,1,150) INFORMATION26 , SUBSTR(INFORMATION185,1,150) INFORMATION27 , SUBSTR(INFORMATION186,1,150) INFORMATION28 , SUBSTR(INFORMATION187,1,150) INFORMATION29 , SUBSTR(INFORMATION188,1,150) INFORMATION30 FROM GHR_PA_HISTORY WHERE TABLE_NAME = 'HR_ALL_POSITIONS_F'

View Text - HTML Formatted

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) POSITION_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION4) DATE_EFFECTIVE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION5) DATE_END
, SUBSTR(INFORMATION6
, 1
, 240) NAME
, GHR_GENERAL.RETURN_NUMBER(INFORMATION7) RELIEF_POSITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION8) LOCATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION9) POSITION_DEFINITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION10) JOB_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION12) ORGANIZATION_ID
, SUBSTR(INFORMATION13
, 1
, 30) FREQUENCY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION14) SUCCESSOR_POSITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION15) PROBATION_PERIOD
, SUBSTR(INFORMATION16
, 1
, 30) PROBATION_PERIOD_UNIT_CD
, SUBSTR(INFORMATION17
, 1
, 30) REPLACEMENT_REQUIRED_FLAG
, SUBSTR(INFORMATION18
, 1
, 5) TIME_NORMAL_FINISH
, SUBSTR(INFORMATION19
, 1
, 5) TIME_NORMAL_START
, GHR_GENERAL.RETURN_NUMBER(INFORMATION20) WORKING_HOURS
, FND_DATE.CANONICAL_TO_DATE(INFORMATION21) AMENDMENT_DATE
, SUBSTR(INFORMATION22
, 1
, 255) AMENDMENT_RECOMMENDATION
, SUBSTR(INFORMATION23
, 1
, 30) AMENDMENT_REF_NUMBER
, GHR_GENERAL.RETURN_NUMBER(INFORMATION24) AVAILABILITY_STATUS_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION25)AVAIL_STATUS_PROP_END_DATE
, SUBSTR(INFORMATION26
, 1
, 30)BARGAINING_UNIT_CD
, SUBSTR(INFORMATION27
, 1
, 30)COPIED_TO_OLD_TABLE_FLAG
, FND_DATE.CANONICAL_TO_DATE(INFORMATION28) EARLIEST_HIRE_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION29) ENTRY_GRADE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION30) ENTRY_GRADE_RULE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION31) ENTRY_STEP_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION32) FILL_BY_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION33) FTE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION34) MAX_PERSONS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION35) OVERLAP_PERIOD
, SUBSTR(INFORMATION36
, 1
, 30) OVERLAP_UNIT_CD
, GHR_GENERAL.RETURN_NUMBER(INFORMATION37) PAY_BASIS_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION38) PAY_FREQ_PAYROLL_ID
, SUBSTR(INFORMATION39
, 1
, 30) PAY_TERM_END_DAY_CD
, SUBSTR(INFORMATION40
, 1
, 30) PAY_TERM_END_MONTH_CD
, SUBSTR(INFORMATION41
, 1
, 30) PERMANENT_TEMPORARY_FLAG
, SUBSTR(INFORMATION42
, 1
, 30) PERMIT_RECRUITMENT_FLAG
, GHR_GENERAL.RETURN_NUMBER(INFORMATION43) POSITION_TRANSACTION_ID
, SUBSTR(INFORMATION44
, 1
, 30) POSITION_TYPE
, SUBSTR(INFORMATION45
, 1
, 255) POSTING_DESCRIPTION
, GHR_GENERAL.RETURN_NUMBER(INFORMATION46) PRIOR_POSITION_ID
, SUBSTR(INFORMATION47
, 1
, 30) REVIEW_FLAG
, SUBSTR(INFORMATION48
, 1
, 30) SEASONAL_FLAG
, SUBSTR(INFORMATION49
, 1
, 255) SECURITY_REQUIREMENTS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION50) SUPERVISOR_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION51) SUPERVISOR_POSITION_ID
, SUBSTR(INFORMATION52
, 1
, 30) TERM_START_DAY_CD
, SUBSTR(INFORMATION53
, 1
, 30) TERM_START_MONTH_CD
, SUBSTR(INFORMATION54
, 1
, 30) UPDATE_SOURCE_CD
, SUBSTR(INFORMATION55
, 1
, 30) WORKS_COUNCIL_APPROVAL_FLAG
, SUBSTR(INFORMATION56
, 1
, 30) WORK_PERIOD_TYPE_CD
, SUBSTR(INFORMATION57
, 1
, 30) WORK_TERM_END_DAY_CD
, SUBSTR(INFORMATION58
, 1
, 30) WORK_TERM_END_MONTH_CD
, FND_DATE.CANONICAL_TO_DATE(INFORMATION59) CURRENT_JOB_PROP_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION60) CURRENT_ORG_PROP_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION61) PROPOSED_DATE_FOR_LAYOFF
, GHR_GENERAL.RETURN_NUMBER(INFORMATION62) PROPOSED_FTE_FOR_LAYOFF
, SUBSTR(INFORMATION63
, 1
, 255) POSITION_DESCRIPTION
, SUBSTR(INFORMATION121
, 1
, 30) STATUS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) BUSINESS_GROUP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION124) PROGRAM_APPLICATION_ID
, TO_NUMBER(INFORMATION125) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION126)PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION127
, 1
, 30) ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION128
, 1
, 150) ATTRIBUTE1
, SUBSTR(INFORMATION129
, 1
, 150) ATTRIBUTE2
, SUBSTR(INFORMATION130
, 1
, 150) ATTRIBUTE3
, SUBSTR(INFORMATION131
, 1
, 150) ATTRIBUTE4
, SUBSTR(INFORMATION132
, 1
, 150) ATTRIBUTE5
, SUBSTR(INFORMATION133
, 1
, 150) ATTRIBUTE6
, SUBSTR(INFORMATION134
, 1
, 150) ATTRIBUTE7
, SUBSTR(INFORMATION135
, 1
, 150) ATTRIBUTE8
, SUBSTR(INFORMATION136
, 1
, 150) ATTRIBUTE9
, SUBSTR(INFORMATION137
, 1
, 150) ATTRIBUTE10
, SUBSTR(INFORMATION138
, 1
, 150) ATTRIBUTE11
, SUBSTR(INFORMATION139
, 1
, 150) ATTRIBUTE12
, SUBSTR(INFORMATION140
, 1
, 150) ATTRIBUTE13
, SUBSTR(INFORMATION141
, 1
, 150) ATTRIBUTE14
, SUBSTR(INFORMATION142
, 1
, 150) ATTRIBUTE15
, SUBSTR(INFORMATION143
, 1
, 150) ATTRIBUTE16
, SUBSTR(INFORMATION144
, 1
, 150) ATTRIBUTE17
, SUBSTR(INFORMATION145
, 1
, 150) ATTRIBUTE18
, SUBSTR(INFORMATION146
, 1
, 150) ATTRIBUTE19
, SUBSTR(INFORMATION147
, 1
, 150) ATTRIBUTE20
, SUBSTR(INFORMATION148
, 1
, 150) ATTRIBUTE21
, SUBSTR(INFORMATION149
, 1
, 150) ATTRIBUTE22
, SUBSTR(INFORMATION150
, 1
, 150) ATTRIBUTE23
, SUBSTR(INFORMATION151
, 1
, 150) ATTRIBUTE24
, SUBSTR(INFORMATION152
, 1
, 150) ATTRIBUTE25
, SUBSTR(INFORMATION153
, 1
, 150) ATTRIBUTE26
, SUBSTR(INFORMATION154
, 1
, 150) ATTRIBUTE27
, SUBSTR(INFORMATION155
, 1
, 150) ATTRIBUTE28
, SUBSTR(INFORMATION156
, 1
, 150) ATTRIBUTE29
, SUBSTR(INFORMATION157
, 1
, 150) ATTRIBUTE30
, SUBSTR(INFORMATION158
, 1
, 150) INFORMATION_CATEGORY
, SUBSTR(INFORMATION159
, 1
, 150) INFORMATION1
, SUBSTR(INFORMATION160
, 1
, 150) INFORMATION2
, SUBSTR(INFORMATION161
, 1
, 150) INFORMATION3
, SUBSTR(INFORMATION162
, 1
, 150) INFORMATION4
, SUBSTR(INFORMATION163
, 1
, 150) INFORMATION5
, SUBSTR(INFORMATION164
, 1
, 150) INFORMATION6
, SUBSTR(INFORMATION165
, 1
, 150) INFORMATION7
, SUBSTR(INFORMATION166
, 1
, 150) INFORMATION8
, SUBSTR(INFORMATION167
, 1
, 150) INFORMATION9
, SUBSTR(INFORMATION168
, 1
, 150) INFORMATION10
, SUBSTR(INFORMATION169
, 1
, 150) INFORMATION11
, SUBSTR(INFORMATION170
, 1
, 150) INFORMATION12
, SUBSTR(INFORMATION171
, 1
, 150) INFORMATION13
, SUBSTR(INFORMATION172
, 1
, 150) INFORMATION14
, SUBSTR(INFORMATION173
, 1
, 150) INFORMATION15
, SUBSTR(INFORMATION174
, 1
, 150) INFORMATION16
, SUBSTR(INFORMATION175
, 1
, 150) INFORMATION17
, SUBSTR(INFORMATION176
, 1
, 150) INFORMATION18
, SUBSTR(INFORMATION177
, 1
, 150) INFORMATION19
, SUBSTR(INFORMATION178
, 1
, 150) INFORMATION20
, SUBSTR(INFORMATION179
, 1
, 150) INFORMATION21
, SUBSTR(INFORMATION180
, 1
, 150) INFORMATION22
, SUBSTR(INFORMATION181
, 1
, 150) INFORMATION23
, SUBSTR(INFORMATION182
, 1
, 150) INFORMATION24
, SUBSTR(INFORMATION183
, 1
, 150) INFORMATION25
, SUBSTR(INFORMATION184
, 1
, 150) INFORMATION26
, SUBSTR(INFORMATION185
, 1
, 150) INFORMATION27
, SUBSTR(INFORMATION186
, 1
, 150) INFORMATION28
, SUBSTR(INFORMATION187
, 1
, 150) INFORMATION29
, SUBSTR(INFORMATION188
, 1
, 150) INFORMATION30
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'HR_ALL_POSITIONS_F'