VIEW: APPS.GHR_MT_ANALYSIS_CRITERIA_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 SEGMENT1 , INFORMATION8 SEGMENT2 , INFORMATION9 SEGMENT3 , INFORMATION10 SEGMENT4 , INFORMATION11 SEGMENT5 , INFORMATION12 SEGMENT6 , INFORMATION13 SEGMENT7 , INFORMATION14 SEGMENT8 , INFORMATION15 SEGMENT9 , INFORMATION16 SEGMENT10 , INFORMATION17 SEGMENT11 , INFORMATION18 SEGMENT12 , INFORMATION19 SEGMENT13 , INFORMATION20 SEGMENT14 , INFORMATION21 SEGMENT15 , INFORMATION22 SEGMENT16 , INFORMATION23 SEGMENT17 , INFORMATION24 SEGMENT18 , INFORMATION25 SEGMENT19 , INFORMATION26 SEGMENT20 , INFORMATION27 SEGMENT21 , INFORMATION28 SEGMENT22 , INFORMATION29 SEGMENT23 , INFORMATION30 SEGMENT24 , INFORMATION31 SEGMENT25 , INFORMATION32 SEGMENT26 , INFORMATION33 SEGMENT27 , INFORMATION34 SEGMENT28, INFORMATION35 SEGMENT29 , INFORMATION36 SEGMENT30 , INFORMATION73 SEGMENT1_MEANING , INFORMATION74 SEGMENT2_MEANING , INFORMATION75 SEGMENT3_MEANING , INFORMATION76 SEGMENT4_MEANING , INFORMATION77 SEGMENT5_MEANING , INFORMATION78 SEGMENT6_MEANING , INFORMATION79 SEGMENT7_MEANING , INFORMATION80 SEGMENT8_MEANING , INFORMATION81 SEGMENT9_MEANING , INFORMATION82 SEGMENT10_MEANING , INFORMATION83 SEGMENT11_MEANING , INFORMATION84 SEGMENT12_MEANING , INFORMATION85 SEGMENT13_MEANING , INFORMATION86 SEGMENT14_MEANING , INFORMATION87 SEGMENT15_MEANING , INFORMATION88 SEGMENT16_MEANING , INFORMATION89 SEGMENT17_MEANING , INFORMATION90 SEGMENT18_MEANING , INFORMATION91 SEGMENT19_MEANING , INFORMATION92 SEGMENT20_MEANING , INFORMATION93 SEGMENT21_MEANING , INFORMATION94 SEGMENT22_MEANING , INFORMATION95 SEGMENT23_MEANING , INFORMATION96 SEGMENT24_MEANING , INFORMATION97 SEGMENT25_MEANING , INFORMATION98 SEGMENT26_MEANING , INFORMATION99 SEGMENT27_MEANING , INFORMATION100 SEGMENT28_MEANING, INFORMATION101 SEGMENT29_MEANING , INFORMATION102 SEGMENT30_MEANING FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_ANALYSIS_CRITERIA'

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 SEGMENT1
, INFORMATION8 SEGMENT2
, INFORMATION9 SEGMENT3
, INFORMATION10 SEGMENT4
, INFORMATION11 SEGMENT5
, INFORMATION12 SEGMENT6
, INFORMATION13 SEGMENT7
, INFORMATION14 SEGMENT8
, INFORMATION15 SEGMENT9
, INFORMATION16 SEGMENT10
, INFORMATION17 SEGMENT11
, INFORMATION18 SEGMENT12
, INFORMATION19 SEGMENT13
, INFORMATION20 SEGMENT14
, INFORMATION21 SEGMENT15
, INFORMATION22 SEGMENT16
, INFORMATION23 SEGMENT17
, INFORMATION24 SEGMENT18
, INFORMATION25 SEGMENT19
, INFORMATION26 SEGMENT20
, INFORMATION27 SEGMENT21
, INFORMATION28 SEGMENT22
, INFORMATION29 SEGMENT23
, INFORMATION30 SEGMENT24
, INFORMATION31 SEGMENT25
, INFORMATION32 SEGMENT26
, INFORMATION33 SEGMENT27
, INFORMATION34 SEGMENT28
, INFORMATION35 SEGMENT29
, INFORMATION36 SEGMENT30
, INFORMATION73 SEGMENT1_MEANING
, INFORMATION74 SEGMENT2_MEANING
, INFORMATION75 SEGMENT3_MEANING
, INFORMATION76 SEGMENT4_MEANING
, INFORMATION77 SEGMENT5_MEANING
, INFORMATION78 SEGMENT6_MEANING
, INFORMATION79 SEGMENT7_MEANING
, INFORMATION80 SEGMENT8_MEANING
, INFORMATION81 SEGMENT9_MEANING
, INFORMATION82 SEGMENT10_MEANING
, INFORMATION83 SEGMENT11_MEANING
, INFORMATION84 SEGMENT12_MEANING
, INFORMATION85 SEGMENT13_MEANING
, INFORMATION86 SEGMENT14_MEANING
, INFORMATION87 SEGMENT15_MEANING
, INFORMATION88 SEGMENT16_MEANING
, INFORMATION89 SEGMENT17_MEANING
, INFORMATION90 SEGMENT18_MEANING
, INFORMATION91 SEGMENT19_MEANING
, INFORMATION92 SEGMENT20_MEANING
, INFORMATION93 SEGMENT21_MEANING
, INFORMATION94 SEGMENT22_MEANING
, INFORMATION95 SEGMENT23_MEANING
, INFORMATION96 SEGMENT24_MEANING
, INFORMATION97 SEGMENT25_MEANING
, INFORMATION98 SEGMENT26_MEANING
, INFORMATION99 SEGMENT27_MEANING
, INFORMATION100 SEGMENT28_MEANING
, INFORMATION101 SEGMENT29_MEANING
, INFORMATION102 SEGMENT30_MEANING
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_ANALYSIS_CRITERIA'