Product: | GHR - US Federal Human Resources |
---|---|
Description: | This views is used by mass transfer in and out processes for datatransfer. |
Implementation/DBA Data: | APPS.GHR_MT_ANALYSIS_CRITERIA_V |
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'