[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_PA_HISTORY# |
|---|---|
| Object Type: | VIEW |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_HISTORY_ID | NUMBER | (15) | Yes | |
| PA_REQUEST_ID | NUMBER | (15) | ||
| PROCESS_DATE | DATE | Yes | ||
| NATURE_OF_ACTION_ID | NUMBER | (15) | ||
| EFFECTIVE_DATE | DATE | Yes | ||
| ALTERED_PA_REQUEST_ID | NUMBER | (15) | ||
| PERSON_ID | NUMBER | (10) | ||
| ASSIGNMENT_ID | NUMBER | (10) | ||
| DML_OPERATION | VARCHAR2 | (1) | ||
| TABLE_NAME | VARCHAR2 | (30) | Yes | |
| PRE_VALUES_FLAG | VARCHAR2 | (1) | ||
| INFORMATION1 | VARCHAR2 | (255) | ||
| INFORMATION2 | VARCHAR2 | (255) | ||
| INFORMATION3 | VARCHAR2 | (255) | ||
| INFORMATION4 | VARCHAR2 | (255) | ||
| INFORMATION5 | VARCHAR2 | (255) | ||
| INFORMATION6 | VARCHAR2 | (255) | ||
| INFORMATION7 | VARCHAR2 | (255) | ||
| INFORMATION8 | VARCHAR2 | (255) | ||
| INFORMATION9 | VARCHAR2 | (255) | ||
| INFORMATION10 | VARCHAR2 | (255) | ||
| INFORMATION11 | VARCHAR2 | (255) | ||
| INFORMATION12 | VARCHAR2 | (255) | ||
| INFORMATION13 | VARCHAR2 | (255) | ||
| INFORMATION14 | VARCHAR2 | (255) | ||
| INFORMATION15 | VARCHAR2 | (255) | ||
| INFORMATION16 | VARCHAR2 | (255) | ||
| INFORMATION17 | VARCHAR2 | (255) | ||
| INFORMATION18 | VARCHAR2 | (255) | ||
| INFORMATION19 | VARCHAR2 | (255) | ||
| INFORMATION20 | VARCHAR2 | (255) | ||
| INFORMATION21 | VARCHAR2 | (255) | ||
| INFORMATION22 | VARCHAR2 | (255) | ||
| INFORMATION23 | VARCHAR2 | (255) | ||
| INFORMATION24 | VARCHAR2 | (255) | ||
| INFORMATION25 | VARCHAR2 | (255) | ||
| INFORMATION26 | VARCHAR2 | (255) | ||
| INFORMATION27 | VARCHAR2 | (255) | ||
| INFORMATION28 | VARCHAR2 | (255) | ||
| INFORMATION29 | VARCHAR2 | (255) | ||
| INFORMATION30 | VARCHAR2 | (255) | ||
| INFORMATION31 | VARCHAR2 | (255) | ||
| INFORMATION32 | VARCHAR2 | (255) | ||
| INFORMATION33 | VARCHAR2 | (255) | ||
| INFORMATION34 | VARCHAR2 | (255) | ||
| INFORMATION35 | VARCHAR2 | (255) | ||
| INFORMATION36 | VARCHAR2 | (255) | ||
| INFORMATION37 | VARCHAR2 | (255) | ||
| INFORMATION38 | VARCHAR2 | (255) | ||
| INFORMATION39 | VARCHAR2 | (255) | ||
| INFORMATION47 | VARCHAR2 | (255) | ||
| INFORMATION48 | VARCHAR2 | (255) | ||
| INFORMATION49 | VARCHAR2 | (255) | ||
| INFORMATION40 | VARCHAR2 | (255) | ||
| INFORMATION41 | VARCHAR2 | (255) | ||
| INFORMATION42 | VARCHAR2 | (255) | ||
| INFORMATION43 | VARCHAR2 | (255) | ||
| INFORMATION44 | VARCHAR2 | (255) | ||
| INFORMATION45 | VARCHAR2 | (255) | ||
| INFORMATION46 | VARCHAR2 | (255) | ||
| INFORMATION50 | VARCHAR2 | (255) | ||
| INFORMATION51 | VARCHAR2 | (255) | ||
| INFORMATION52 | VARCHAR2 | (255) | ||
| INFORMATION53 | VARCHAR2 | (255) | ||
| INFORMATION54 | VARCHAR2 | (255) | ||
| INFORMATION55 | VARCHAR2 | (255) | ||
| INFORMATION56 | VARCHAR2 | (255) | ||
| INFORMATION57 | VARCHAR2 | (255) | ||
| INFORMATION58 | VARCHAR2 | (255) | ||
| INFORMATION59 | VARCHAR2 | (255) | ||
| INFORMATION60 | VARCHAR2 | (255) | ||
| INFORMATION61 | VARCHAR2 | (255) | ||
| INFORMATION62 | VARCHAR2 | (255) | ||
| INFORMATION63 | VARCHAR2 | (255) | ||
| INFORMATION64 | VARCHAR2 | (255) | ||
| INFORMATION65 | VARCHAR2 | (255) | ||
| INFORMATION66 | VARCHAR2 | (255) | ||
| INFORMATION67 | VARCHAR2 | (255) | ||
| INFORMATION68 | VARCHAR2 | (255) | ||
| INFORMATION69 | VARCHAR2 | (255) | ||
| INFORMATION70 | VARCHAR2 | (255) | ||
| INFORMATION71 | VARCHAR2 | (255) | ||
| INFORMATION72 | VARCHAR2 | (255) | ||
| INFORMATION73 | VARCHAR2 | (255) | ||
| INFORMATION74 | VARCHAR2 | (255) | ||
| INFORMATION75 | VARCHAR2 | (255) | ||
| INFORMATION76 | VARCHAR2 | (255) | ||
| INFORMATION77 | VARCHAR2 | (255) | ||
| INFORMATION78 | VARCHAR2 | (255) | ||
| INFORMATION79 | VARCHAR2 | (255) | ||
| INFORMATION80 | VARCHAR2 | (255) | ||
| INFORMATION81 | VARCHAR2 | (255) | ||
| INFORMATION82 | VARCHAR2 | (255) | ||
| INFORMATION83 | VARCHAR2 | (255) | ||
| INFORMATION84 | VARCHAR2 | (255) | ||
| INFORMATION85 | VARCHAR2 | (255) | ||
| INFORMATION86 | VARCHAR2 | (255) | ||
| INFORMATION87 | VARCHAR2 | (255) | ||
| INFORMATION88 | VARCHAR2 | (255) | ||
| INFORMATION89 | VARCHAR2 | (255) | ||
| INFORMATION90 | VARCHAR2 | (255) | ||
| INFORMATION91 | VARCHAR2 | (255) | ||
| INFORMATION92 | VARCHAR2 | (255) | ||
| INFORMATION93 | VARCHAR2 | (255) | ||
| INFORMATION94 | VARCHAR2 | (255) | ||
| INFORMATION95 | VARCHAR2 | (255) | ||
| INFORMATION96 | VARCHAR2 | (255) | ||
| INFORMATION97 | VARCHAR2 | (255) | ||
| INFORMATION98 | VARCHAR2 | (255) | ||
| INFORMATION99 | VARCHAR2 | (255) | ||
| INFORMATION100 | VARCHAR2 | (255) | ||
| INFORMATION101 | VARCHAR2 | (255) | ||
| INFORMATION102 | VARCHAR2 | (255) | ||
| INFORMATION103 | VARCHAR2 | (255) | ||
| INFORMATION104 | VARCHAR2 | (255) | ||
| INFORMATION105 | VARCHAR2 | (255) | ||
| INFORMATION106 | VARCHAR2 | (255) | ||
| INFORMATION107 | VARCHAR2 | (255) | ||
| INFORMATION108 | VARCHAR2 | (255) | ||
| INFORMATION109 | VARCHAR2 | (255) | ||
| INFORMATION110 | VARCHAR2 | (255) | ||
| INFORMATION111 | VARCHAR2 | (255) | ||
| INFORMATION112 | VARCHAR2 | (255) | ||
| INFORMATION113 | VARCHAR2 | (255) | ||
| INFORMATION114 | VARCHAR2 | (255) | ||
| INFORMATION115 | VARCHAR2 | (255) | ||
| INFORMATION116 | VARCHAR2 | (255) | ||
| INFORMATION117 | VARCHAR2 | (255) | ||
| INFORMATION118 | VARCHAR2 | (255) | ||
| INFORMATION119 | VARCHAR2 | (255) | ||
| INFORMATION120 | VARCHAR2 | (255) | ||
| INFORMATION121 | VARCHAR2 | (255) | ||
| INFORMATION122 | VARCHAR2 | (255) | ||
| INFORMATION123 | VARCHAR2 | (255) | ||
| INFORMATION124 | VARCHAR2 | (255) | ||
| INFORMATION125 | VARCHAR2 | (255) | ||
| INFORMATION126 | VARCHAR2 | (255) | ||
| INFORMATION127 | VARCHAR2 | (255) | ||
| INFORMATION128 | VARCHAR2 | (255) | ||
| INFORMATION129 | VARCHAR2 | (255) | ||
| INFORMATION130 | VARCHAR2 | (255) | ||
| INFORMATION131 | VARCHAR2 | (255) | ||
| INFORMATION132 | VARCHAR2 | (255) | ||
| INFORMATION133 | VARCHAR2 | (255) | ||
| INFORMATION134 | VARCHAR2 | (255) | ||
| INFORMATION135 | VARCHAR2 | (255) | ||
| INFORMATION136 | VARCHAR2 | (255) | ||
| INFORMATION137 | VARCHAR2 | (255) | ||
| INFORMATION138 | VARCHAR2 | (255) | ||
| INFORMATION139 | VARCHAR2 | (255) | ||
| INFORMATION140 | VARCHAR2 | (255) | ||
| INFORMATION141 | VARCHAR2 | (255) | ||
| INFORMATION142 | VARCHAR2 | (255) | ||
| INFORMATION143 | VARCHAR2 | (255) | ||
| INFORMATION144 | VARCHAR2 | (255) | ||
| INFORMATION145 | VARCHAR2 | (255) | ||
| INFORMATION146 | VARCHAR2 | (255) | ||
| INFORMATION147 | VARCHAR2 | (255) | ||
| INFORMATION148 | VARCHAR2 | (255) | ||
| INFORMATION149 | VARCHAR2 | (255) | ||
| INFORMATION150 | VARCHAR2 | (255) | ||
| INFORMATION151 | VARCHAR2 | (255) | ||
| INFORMATION152 | VARCHAR2 | (255) | ||
| INFORMATION153 | VARCHAR2 | (255) | ||
| INFORMATION154 | VARCHAR2 | (255) | ||
| INFORMATION155 | VARCHAR2 | (255) | ||
| INFORMATION156 | VARCHAR2 | (255) | ||
| INFORMATION157 | VARCHAR2 | (255) | ||
| INFORMATION158 | VARCHAR2 | (255) | ||
| INFORMATION159 | VARCHAR2 | (255) | ||
| INFORMATION160 | VARCHAR2 | (255) | ||
| INFORMATION161 | VARCHAR2 | (255) | ||
| INFORMATION162 | VARCHAR2 | (255) | ||
| INFORMATION163 | VARCHAR2 | (255) | ||
| INFORMATION164 | VARCHAR2 | (255) | ||
| INFORMATION165 | VARCHAR2 | (255) | ||
| INFORMATION166 | VARCHAR2 | (255) | ||
| INFORMATION167 | VARCHAR2 | (255) | ||
| INFORMATION168 | VARCHAR2 | (255) | ||
| INFORMATION169 | VARCHAR2 | (255) | ||
| INFORMATION170 | VARCHAR2 | (255) | ||
| INFORMATION171 | VARCHAR2 | (255) | ||
| INFORMATION172 | VARCHAR2 | (255) | ||
| INFORMATION173 | VARCHAR2 | (255) | ||
| INFORMATION174 | VARCHAR2 | (255) | ||
| INFORMATION175 | VARCHAR2 | (255) | ||
| INFORMATION176 | VARCHAR2 | (255) | ||
| INFORMATION177 | VARCHAR2 | (255) | ||
| INFORMATION178 | VARCHAR2 | (255) | ||
| INFORMATION179 | VARCHAR2 | (255) | ||
| INFORMATION180 | VARCHAR2 | (255) | ||
| INFORMATION181 | VARCHAR2 | (255) | ||
| INFORMATION182 | VARCHAR2 | (255) | ||
| INFORMATION183 | VARCHAR2 | (255) | ||
| INFORMATION184 | VARCHAR2 | (255) | ||
| INFORMATION185 | VARCHAR2 | (255) | ||
| INFORMATION186 | VARCHAR2 | (255) | ||
| INFORMATION187 | VARCHAR2 | (255) | ||
| INFORMATION188 | VARCHAR2 | (255) | ||
| INFORMATION189 | VARCHAR2 | (255) | ||
| INFORMATION190 | VARCHAR2 | (255) | ||
| INFORMATION191 | VARCHAR2 | (255) | ||
| INFORMATION192 | VARCHAR2 | (255) | ||
| INFORMATION193 | VARCHAR2 | (255) | ||
| INFORMATION194 | VARCHAR2 | (255) | ||
| INFORMATION195 | VARCHAR2 | (255) | ||
| INFORMATION196 | VARCHAR2 | (255) | ||
| INFORMATION197 | VARCHAR2 | (255) | ||
| INFORMATION198 | VARCHAR2 | (255) | ||
| INFORMATION199 | VARCHAR2 | (255) | ||
| INFORMATION200 | VARCHAR2 | (255) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PA_HISTORY_ID
, PA_REQUEST_ID
, PROCESS_DATE
, NATURE_OF_ACTION_ID
, EFFECTIVE_DATE
, ALTERED_PA_REQUEST_ID
, PERSON_ID
, ASSIGNMENT_ID
, DML_OPERATION
, TABLE_NAME
, PRE_VALUES_FLAG
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION13
, INFORMATION14
, INFORMATION15
, INFORMATION16
, INFORMATION17
, INFORMATION18
, INFORMATION19
, INFORMATION20
, INFORMATION21
, INFORMATION22
, INFORMATION23
, INFORMATION24
, INFORMATION25
, INFORMATION26
, INFORMATION27
, INFORMATION28
, INFORMATION29
, INFORMATION30
, INFORMATION31
, INFORMATION32
, INFORMATION33
, INFORMATION34
, INFORMATION35
, INFORMATION36
, INFORMATION37
, INFORMATION38
, INFORMATION39
, INFORMATION47
, INFORMATION48
, INFORMATION49
, INFORMATION40
, INFORMATION41
, INFORMATION42
, INFORMATION43
, INFORMATION44
, INFORMATION45
, INFORMATION46
, INFORMATION50
, INFORMATION51
, INFORMATION52
, INFORMATION53
, INFORMATION54
, INFORMATION55
, INFORMATION56
, INFORMATION57
, INFORMATION58
, INFORMATION59
, INFORMATION60
, INFORMATION61
, INFORMATION62
, INFORMATION63
, INFORMATION64
, INFORMATION65
, INFORMATION66
, INFORMATION67
, INFORMATION68
, INFORMATION69
, INFORMATION70
, INFORMATION71
, INFORMATION72
, INFORMATION73
, INFORMATION74
, INFORMATION75
, INFORMATION76
, INFORMATION77
, INFORMATION78
, INFORMATION79
, INFORMATION80
, INFORMATION81
, INFORMATION82
, INFORMATION83
, INFORMATION84
, INFORMATION85
, INFORMATION86
, INFORMATION87
, INFORMATION88
, INFORMATION89
, INFORMATION90
, INFORMATION91
, INFORMATION92
, INFORMATION93
, INFORMATION94
, INFORMATION95
, INFORMATION96
, INFORMATION97
, INFORMATION98
, INFORMATION99
, INFORMATION100
, INFORMATION101
, INFORMATION102
, INFORMATION103
, INFORMATION104
, INFORMATION105
, INFORMATION106
, INFORMATION107
, INFORMATION108
, INFORMATION109
, INFORMATION110
, INFORMATION111
, INFORMATION112
, INFORMATION113
, INFORMATION114
, INFORMATION115
, INFORMATION116
, INFORMATION117
, INFORMATION118
, INFORMATION119
, INFORMATION120
, INFORMATION121
, INFORMATION122
, INFORMATION123
, INFORMATION124
, INFORMATION125
, INFORMATION126
, INFORMATION127
, INFORMATION128
, INFORMATION129
, INFORMATION130
, INFORMATION131
, INFORMATION132
, INFORMATION133
, INFORMATION134
, INFORMATION135
, INFORMATION136
, INFORMATION137
, INFORMATION138
, INFORMATION139
, INFORMATION140
, INFORMATION141
, INFORMATION142
, INFORMATION143
, INFORMATION144
, INFORMATION145
, INFORMATION146
, INFORMATION147
, INFORMATION148
, INFORMATION149
, INFORMATION150
, INFORMATION151
, INFORMATION152
, INFORMATION153
, INFORMATION154
, INFORMATION155
, INFORMATION156
, INFORMATION157
, INFORMATION158
, INFORMATION159
, INFORMATION160
, INFORMATION161
, INFORMATION162
, INFORMATION163
, INFORMATION164
, INFORMATION165
, INFORMATION166
, INFORMATION167
, INFORMATION168
, INFORMATION169
, INFORMATION170
, INFORMATION171
, INFORMATION172
, INFORMATION173
, INFORMATION174
, INFORMATION175
, INFORMATION176
, INFORMATION177
, INFORMATION178
, INFORMATION179
, INFORMATION180
, INFORMATION181
, INFORMATION182
, INFORMATION183
, INFORMATION184
, INFORMATION185
, INFORMATION186
, INFORMATION187
, INFORMATION188
, INFORMATION189
, INFORMATION190
, INFORMATION191
, INFORMATION192
, INFORMATION193
, INFORMATION194
, INFORMATION195
, INFORMATION196
, INFORMATION197
, INFORMATION198
, INFORMATION199
, INFORMATION200
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.GHR_PA_HISTORY#;
HR
GHR_PA_HISTORY
APPS
GHR_PA_HISTORY
GHR_PA_HISTORY_WHO
|
|
|
|