VIEW: APPS.GHR_MT_POSITION_DEFINITIONS_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_DEFINITION_ID , INFORMATION8 ID_FLEX_NUM , INFORMATION9 SUMMARY_FLAG , INFORMATION10 ENABLED_FLAG , INFORMATION11 START_DATE_ACTIVE , INFORMATION12 END_DATE_ACTIVE , INFORMATION13 SEGMENT1 , INFORMATION14 SEGMENT2 , INFORMATION15 SEGMENT3 , INFORMATION16 SEGMENT4 , INFORMATION17 SEGMENT5 , INFORMATION18 SEGMENT6 , INFORMATION19 SEGMENT7 , INFORMATION20 SEGMENT8 , INFORMATION21 SEGMENT9 , INFORMATION22 SEGMENT10 , INFORMATION23 SEGMENT11 , INFORMATION24 SEGMENT12 , INFORMATION25 SEGMENT13 , INFORMATION26 SEGMENT14 , INFORMATION27 SEGMENT15 , INFORMATION28 SEGMENT16 , INFORMATION29 SEGMENT17 , INFORMATION30 SEGMENT18 , INFORMATION31 SEGMENT19 , INFORMATION32 SEGMENT20 , INFORMATION33 SEGMENT21, INFORMATION34 SEGMENT22 , INFORMATION35 SEGMENT23 , INFORMATION36 SEGMENT24 , INFORMATION37 SEGMENT25 , INFORMATION38 SEGMENT26 , INFORMATION39 SEGMENT27 , INFORMATION40 SEGMENT28 , INFORMATION41 SEGMENT29 , INFORMATION42 SEGMENT30 , INFORMATION43 LAST_UPDATE_DATE , INFORMATION44 LAST_UPDATED_BY , INFORMATION45 LAST_UPDATE_LOGIN , INFORMATION46 CREATED_BY , INFORMATION47 CREATION_DATE FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_POSITION_DEFINITIONS'

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_DEFINITION_ID
, INFORMATION8 ID_FLEX_NUM
, INFORMATION9 SUMMARY_FLAG
, INFORMATION10 ENABLED_FLAG
, INFORMATION11 START_DATE_ACTIVE
, INFORMATION12 END_DATE_ACTIVE
, INFORMATION13 SEGMENT1
, INFORMATION14 SEGMENT2
, INFORMATION15 SEGMENT3
, INFORMATION16 SEGMENT4
, INFORMATION17 SEGMENT5
, INFORMATION18 SEGMENT6
, INFORMATION19 SEGMENT7
, INFORMATION20 SEGMENT8
, INFORMATION21 SEGMENT9
, INFORMATION22 SEGMENT10
, INFORMATION23 SEGMENT11
, INFORMATION24 SEGMENT12
, INFORMATION25 SEGMENT13
, INFORMATION26 SEGMENT14
, INFORMATION27 SEGMENT15
, INFORMATION28 SEGMENT16
, INFORMATION29 SEGMENT17
, INFORMATION30 SEGMENT18
, INFORMATION31 SEGMENT19
, INFORMATION32 SEGMENT20
, INFORMATION33 SEGMENT21
, INFORMATION34 SEGMENT22
, INFORMATION35 SEGMENT23
, INFORMATION36 SEGMENT24
, INFORMATION37 SEGMENT25
, INFORMATION38 SEGMENT26
, INFORMATION39 SEGMENT27
, INFORMATION40 SEGMENT28
, INFORMATION41 SEGMENT29
, INFORMATION42 SEGMENT30
, INFORMATION43 LAST_UPDATE_DATE
, INFORMATION44 LAST_UPDATED_BY
, INFORMATION45 LAST_UPDATE_LOGIN
, INFORMATION46 CREATED_BY
, INFORMATION47 CREATION_DATE
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_POSITION_DEFINITIONS'