VIEW: APPS.GHR_MT_POSITIONS_V

Source

View Text - Preformatted

SELECT INTERFACE_ID GHR_INTERFACE_ID , PROCESS_DATE MT_PROCESS_DATE , SOURCE_NAME MT_SOURCE , DATE_FROM MT_EFFECTIVE_DATE , INFORMATION1 MT_NAME , INFORMATION2 MT_STATUS , INFORMATION3 MT_PERSON_ID , INFORMATION4 MT_TABLE_NAME , INFORMATION5 MT_INFORMATION_TYPE , INFORMATION6 MT_INTER_BG_TRANSFER , INFORMATION7 POSITION_ID , INFORMATION8 BUSINESS_GROUP_ID , INFORMATION9 JOB_ID , INFORMATION10 ORGANIZATION_ID , INFORMATION11 SUCCESSOR_POSITION_ID , INFORMATION12 RELIEF_POSITION_ID , INFORMATION13 LOCATION_ID , INFORMATION14 POSITION_DEFINITION_ID , INFORMATION15 DATE_EFFECTIVE , INFORMATION16 COMMENTS , INFORMATION17 DATE_END , INFORMATION18 FREQUENCY , INFORMATION19 NAME , INFORMATION20 PROBATION_PERIOD , INFORMATION21 PROBATION_PERIOD_UNITS , INFORMATION22 REPLACEMENT_REQUIRED_FLAG , INFORMATION23 TIME_NORMAL_FINISH , INFORMATION24 TIME_NORMAL_START , INFORMATION25 WORKING_HOURS , INFORMATION26 REQUEST_ID , INFORMATION27 PROGRAM_APPLICATION_ID , INFORMATION28 PROGRAM_ID , INFORMATION29 PROGRAM_UPDATE_DATE, INFORMATION30 ATTRIBUTE_CATEGORY , INFORMATION31 ATTRIBUTE1 , INFORMATION32 ATTRIBUTE2 , INFORMATION33 ATTRIBUTE3 , INFORMATION34 ATTRIBUTE4 , INFORMATION35 ATTRIBUTE5 , INFORMATION36 ATTRIBUTE6 , INFORMATION37 ATTRIBUTE7 , INFORMATION38 ATTRIBUTE8 , INFORMATION39 ATTRIBUTE9 , INFORMATION40 ATTRIBUTE10 , INFORMATION41 ATTRIBUTE11 , INFORMATION42 ATTRIBUTE12 , INFORMATION43 ATTRIBUTE13 , INFORMATION44 ATTRIBUTE14 , INFORMATION45 ATTRIBUTE15 , INFORMATION46 ATTRIBUTE16 , INFORMATION47 ATTRIBUTE17 , INFORMATION48 ATTRIBUTE18 , INFORMATION49 ATTRIBUTE19 , INFORMATION50 ATTRIBUTE20 , INFORMATION51 OBJECT_VERSION_NUMBER , INFORMATION52 LAST_UPDATE_DATE , INFORMATION53 LAST_UPDATED_BY , INFORMATION54 LAST_UPDATE_LOGIN , INFORMATION55 CREATED_BY , INFORMATION56 CREATION_DATE , INFORMATION57 STATUS FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_POSITIONS'

View Text - HTML Formatted

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 POSITION_ID
, INFORMATION8 BUSINESS_GROUP_ID
, INFORMATION9 JOB_ID
, INFORMATION10 ORGANIZATION_ID
, INFORMATION11 SUCCESSOR_POSITION_ID
, INFORMATION12 RELIEF_POSITION_ID
, INFORMATION13 LOCATION_ID
, INFORMATION14 POSITION_DEFINITION_ID
, INFORMATION15 DATE_EFFECTIVE
, INFORMATION16 COMMENTS
, INFORMATION17 DATE_END
, INFORMATION18 FREQUENCY
, INFORMATION19 NAME
, INFORMATION20 PROBATION_PERIOD
, INFORMATION21 PROBATION_PERIOD_UNITS
, INFORMATION22 REPLACEMENT_REQUIRED_FLAG
, INFORMATION23 TIME_NORMAL_FINISH
, INFORMATION24 TIME_NORMAL_START
, INFORMATION25 WORKING_HOURS
, INFORMATION26 REQUEST_ID
, INFORMATION27 PROGRAM_APPLICATION_ID
, INFORMATION28 PROGRAM_ID
, INFORMATION29 PROGRAM_UPDATE_DATE
, INFORMATION30 ATTRIBUTE_CATEGORY
, INFORMATION31 ATTRIBUTE1
, INFORMATION32 ATTRIBUTE2
, INFORMATION33 ATTRIBUTE3
, INFORMATION34 ATTRIBUTE4
, INFORMATION35 ATTRIBUTE5
, INFORMATION36 ATTRIBUTE6
, INFORMATION37 ATTRIBUTE7
, INFORMATION38 ATTRIBUTE8
, INFORMATION39 ATTRIBUTE9
, INFORMATION40 ATTRIBUTE10
, INFORMATION41 ATTRIBUTE11
, INFORMATION42 ATTRIBUTE12
, INFORMATION43 ATTRIBUTE13
, INFORMATION44 ATTRIBUTE14
, INFORMATION45 ATTRIBUTE15
, INFORMATION46 ATTRIBUTE16
, INFORMATION47 ATTRIBUTE17
, INFORMATION48 ATTRIBUTE18
, INFORMATION49 ATTRIBUTE19
, INFORMATION50 ATTRIBUTE20
, INFORMATION51 OBJECT_VERSION_NUMBER
, INFORMATION52 LAST_UPDATE_DATE
, INFORMATION53 LAST_UPDATED_BY
, INFORMATION54 LAST_UPDATE_LOGIN
, INFORMATION55 CREATED_BY
, INFORMATION56 CREATION_DATE
, INFORMATION57 STATUS
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_POSITIONS'