VIEW: APPS.GHR_ASSIGNMENTS_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) ASSIGNMENT_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE , GHR_GENERAL.RETURN_NUMBER(INFORMATION4) RECRUITER_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION5) ASSIGNMENT_STATUS_TYPE_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION6) PAYROLL_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION7) PERSON_REFERRED_BY_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION8) SUPERVISOR_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION9) SPECIAL_CEILING_STEP_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION10) PERSON_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION11) RECRUITMENT_ACTIVITY_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION12) SOURCE_ORGANIZATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION13) PEOPLE_GROUP_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION14) SOFT_CODING_KEYFLEX_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION15) VACANCY_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION16) PAY_BASIS_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION17) ASSIGNMENT_SEQUENCE , SUBSTR(INFORMATION18,1,1) ASSIGNMENT_TYPE , SUBSTR(INFORMATION19,1,30) PRIMARY_FLAG , GHR_GENERAL.RETURN_NUMBER(INFORMATION20) APPLICATION_ID , SUBSTR(INFORMATION21,1,30) ASSIGNMENT_NUMBER , SUBSTR(INFORMATION22,1,30) CHANGE_REASON , GHR_GENERAL.RETURN_NUMBER(INFORMATION23) COMMENT_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION24) DATE_PROBATION_END , GHR_GENERAL.RETURN_NUMBER(INFORMATION25) DEFAULT_CODE_COMB_ID , SUBSTR(INFORMATION26,1,30) EMPLOYMENT_CATEGORY , SUBSTR(INFORMATION27,1,30) FREQUENCY , SUBSTR(INFORMATION28,1,80) INTERNAL_ADDRESS_LINE , SUBSTR(INFORMATION29,1,30) MANAGER_FLAG , GHR_GENERAL.RETURN_NUMBER(INFORMATION30) NORMAL_HOURS , GHR_GENERAL.RETURN_NUMBER(INFORMATION31) PERF_REVIEW_PERIOD , INFORMATION32 PERF_REVIEW_PERIOD_FREQUENCY , GHR_GENERAL.RETURN_NUMBER(INFORMATION33) PERIOD_OF_SERVICE_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION34) PROBATION_PERIOD , SUBSTR(INFORMATION35,1,30) PROBATION_UNIT , GHR_GENERAL.RETURN_NUMBER(INFORMATION36) SAL_REVIEW_PERIOD , SUBSTR(INFORMATION37,1,30) SAL_REVIEW_PERIOD_FREQUENCY ,GHR_GENERAL.RETURN_NUMBER(INFORMATION38) SET_OF_BOOKS_ID , SUBSTR(INFORMATION39,1,30) SOURCE_TYPE , SUBSTR(INFORMATION40,1,5) TIME_NORMAL_FINISH , SUBSTR(INFORMATION41,1,5) TIME_NORMAL_START , SUBSTR(INFORMATION42,1,30) TITLE , GHR_GENERAL.RETURN_NUMBER(information43) organization_id , GHR_GENERAL.RETURN_NUMBER(information44) job_id , GHR_GENERAL.RETURN_NUMBER(INFORMATION101) POSITION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION45) GRADE_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION103) LOCATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION121) BUSINESS_GROUP_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION122) REQUEST_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_APPLICATION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION124) PROGRAM_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION125) PROGRAM_UPDATE_DATE , SUBSTR(INFORMATION126, 1, 30) ASS_ATTRIBUTE_CATEGORY , SUBSTR(INFORMATION127,1,150) ASS_ATTRIBUTE1 , SUBSTR(INFORMATION128,1,150) ASS_ATTRIBUTE2 , SUBSTR(INFORMATION129,1,150) ASS_ATTRIBUTE3 , SUBSTR(INFORMATION130,1,150) ASS_ATTRIBUTE4 , SUBSTR(INFORMATION131,1,150) ASS_ATTRIBUTE5 , SUBSTR(INFORMATION132,1,150) ASS_ATTRIBUTE6 , SUBSTR(INFORMATION133,1,150) ASS_ATTRIBUTE7 , SUBSTR(INFORMATION134,1,150) ASS_ATTRIBUTE8 , SUBSTR(INFORMATION135,1,150) ASS_ATTRIBUTE9 , SUBSTR(INFORMATION136,1,150) ASS_ATTRIBUTE10 , SUBSTR(INFORMATION137,1,150) ASS_ATTRIBUTE11 , SUBSTR(INFORMATION138,1,150) ASS_ATTRIBUTE12 , SUBSTR(INFORMATION139,1,150) ASS_ATTRIBUTE13 , SUBSTR(INFORMATION140,1,150) ASS_ATTRIBUTE14 , SUBSTR(INFORMATION141,1,150) ASS_ATTRIBUTE15 , SUBSTR(INFORMATION142,1,150) ASS_ATTRIBUTE16 , SUBSTR(INFORMATION143,1,150) ASS_ATTRIBUTE17 , SUBSTR(INFORMATION144,1,150) ASS_ATTRIBUTE18 , SUBSTR(INFORMATION145,1,150) ASS_ATTRIBUTE19 , SUBSTR(INFORMATION146,1,150) ASS_ATTRIBUTE20 , SUBSTR(INFORMATION147,1,150) ASS_ATTRIBUTE21 , SUBSTR(INFORMATION148,1,150) ASS_ATTRIBUTE22 , SUBSTR(INFORMATION149,1,150) ASS_ATTRIBUTE23 , SUBSTR(INFORMATION150,1,150) ASS_ATTRIBUTE24 , SUBSTR(INFORMATION151,1,150) ASS_ATTRIBUTE25 , SUBSTR(INFORMATION152,1,150) ASS_ATTRIBUTE26 , SUBSTR(INFORMATION153,1,150) ASS_ATTRIBUTE27 , SUBSTR(INFORMATION154,1,150) ASS_ATTRIBUTE28 , SUBSTR(INFORMATION155,1,150) ASS_ATTRIBUTE29 , SUBSTR(INFORMATION156,1,150) ASS_ATTRIBUTE30 FROM GHR_PA_HISTORY WHERE TABLE_NAME = 'PER_ASSIGNMENTS_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) ASSIGNMENT_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION4) RECRUITER_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION5) ASSIGNMENT_STATUS_TYPE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION6) PAYROLL_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION7) PERSON_REFERRED_BY_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION8) SUPERVISOR_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION9) SPECIAL_CEILING_STEP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION10) PERSON_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION11) RECRUITMENT_ACTIVITY_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION12) SOURCE_ORGANIZATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION13) PEOPLE_GROUP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION14) SOFT_CODING_KEYFLEX_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION15) VACANCY_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION16) PAY_BASIS_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION17) ASSIGNMENT_SEQUENCE
, SUBSTR(INFORMATION18
, 1
, 1) ASSIGNMENT_TYPE
, SUBSTR(INFORMATION19
, 1
, 30) PRIMARY_FLAG
, GHR_GENERAL.RETURN_NUMBER(INFORMATION20) APPLICATION_ID
, SUBSTR(INFORMATION21
, 1
, 30) ASSIGNMENT_NUMBER
, SUBSTR(INFORMATION22
, 1
, 30) CHANGE_REASON
, GHR_GENERAL.RETURN_NUMBER(INFORMATION23) COMMENT_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION24) DATE_PROBATION_END
, GHR_GENERAL.RETURN_NUMBER(INFORMATION25) DEFAULT_CODE_COMB_ID
, SUBSTR(INFORMATION26
, 1
, 30) EMPLOYMENT_CATEGORY
, SUBSTR(INFORMATION27
, 1
, 30) FREQUENCY
, SUBSTR(INFORMATION28
, 1
, 80) INTERNAL_ADDRESS_LINE
, SUBSTR(INFORMATION29
, 1
, 30) MANAGER_FLAG
, GHR_GENERAL.RETURN_NUMBER(INFORMATION30) NORMAL_HOURS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION31) PERF_REVIEW_PERIOD
, INFORMATION32 PERF_REVIEW_PERIOD_FREQUENCY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION33) PERIOD_OF_SERVICE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION34) PROBATION_PERIOD
, SUBSTR(INFORMATION35
, 1
, 30) PROBATION_UNIT
, GHR_GENERAL.RETURN_NUMBER(INFORMATION36) SAL_REVIEW_PERIOD
, SUBSTR(INFORMATION37
, 1
, 30) SAL_REVIEW_PERIOD_FREQUENCY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION38) SET_OF_BOOKS_ID
, SUBSTR(INFORMATION39
, 1
, 30) SOURCE_TYPE
, SUBSTR(INFORMATION40
, 1
, 5) TIME_NORMAL_FINISH
, SUBSTR(INFORMATION41
, 1
, 5) TIME_NORMAL_START
, SUBSTR(INFORMATION42
, 1
, 30) TITLE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION43) ORGANIZATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION44) JOB_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION101) POSITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION45) GRADE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION103) LOCATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION121) BUSINESS_GROUP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_APPLICATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION124) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION125) PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION126
, 1
, 30) ASS_ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION127
, 1
, 150) ASS_ATTRIBUTE1
, SUBSTR(INFORMATION128
, 1
, 150) ASS_ATTRIBUTE2
, SUBSTR(INFORMATION129
, 1
, 150) ASS_ATTRIBUTE3
, SUBSTR(INFORMATION130
, 1
, 150) ASS_ATTRIBUTE4
, SUBSTR(INFORMATION131
, 1
, 150) ASS_ATTRIBUTE5
, SUBSTR(INFORMATION132
, 1
, 150) ASS_ATTRIBUTE6
, SUBSTR(INFORMATION133
, 1
, 150) ASS_ATTRIBUTE7
, SUBSTR(INFORMATION134
, 1
, 150) ASS_ATTRIBUTE8
, SUBSTR(INFORMATION135
, 1
, 150) ASS_ATTRIBUTE9
, SUBSTR(INFORMATION136
, 1
, 150) ASS_ATTRIBUTE10
, SUBSTR(INFORMATION137
, 1
, 150) ASS_ATTRIBUTE11
, SUBSTR(INFORMATION138
, 1
, 150) ASS_ATTRIBUTE12
, SUBSTR(INFORMATION139
, 1
, 150) ASS_ATTRIBUTE13
, SUBSTR(INFORMATION140
, 1
, 150) ASS_ATTRIBUTE14
, SUBSTR(INFORMATION141
, 1
, 150) ASS_ATTRIBUTE15
, SUBSTR(INFORMATION142
, 1
, 150) ASS_ATTRIBUTE16
, SUBSTR(INFORMATION143
, 1
, 150) ASS_ATTRIBUTE17
, SUBSTR(INFORMATION144
, 1
, 150) ASS_ATTRIBUTE18
, SUBSTR(INFORMATION145
, 1
, 150) ASS_ATTRIBUTE19
, SUBSTR(INFORMATION146
, 1
, 150) ASS_ATTRIBUTE20
, SUBSTR(INFORMATION147
, 1
, 150) ASS_ATTRIBUTE21
, SUBSTR(INFORMATION148
, 1
, 150) ASS_ATTRIBUTE22
, SUBSTR(INFORMATION149
, 1
, 150) ASS_ATTRIBUTE23
, SUBSTR(INFORMATION150
, 1
, 150) ASS_ATTRIBUTE24
, SUBSTR(INFORMATION151
, 1
, 150) ASS_ATTRIBUTE25
, SUBSTR(INFORMATION152
, 1
, 150) ASS_ATTRIBUTE26
, SUBSTR(INFORMATION153
, 1
, 150) ASS_ATTRIBUTE27
, SUBSTR(INFORMATION154
, 1
, 150) ASS_ATTRIBUTE28
, SUBSTR(INFORMATION155
, 1
, 150) ASS_ATTRIBUTE29
, SUBSTR(INFORMATION156
, 1
, 150) ASS_ATTRIBUTE30
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'