View: PER_MASS_APP_ASSIGN_UPDATE_V

Product:	PER - Human Resources
Description:	Used to support Mass Assignment Update UI
Implementation/DBA Data:	APPS.PER_MASS_APP_ASSIGN_UPDATE_V

View Text

SELECT COPY_ENTITY_RESULT_ID
, COPY_ENTITY_TXN_ID
, RESULT_TYPE_CD
, STATUS
, SRC_COPY_ENTITY_RESULT_ID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION13
, INFORMATION14
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(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
, INFORMATION40
, INFORMATION41
, INFORMATION42
, INFORMATION43
, INFORMATION44
, INFORMATION45
, INFORMATION46
, INFORMATION47
, INFORMATION48
, INFORMATION49
, INFORMATION50
, INFORMATION51
, INFORMATION52
, INFORMATION53
, INFORMATION54
, INFORMATION55
, INFORMATION56
, INFORMATION57
, INFORMATION58
, INFORMATION59
, INFORMATION60
, INFORMATION61
, INFORMATION62
, INFORMATION63
, INFORMATION64
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(DECODE(INFORMATION62
, '4712/12/31 00:00:00'
, NULL
, INFORMATION62))) INFORMATION65
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION61)) 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
, OBJECT_VERSION_NUMBER
, NUMBER_OF_COPIES
FROM PQH_COPY_ENTITY_RESULTS

Columns