eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PQH_COPY_ENTITY_POSUPD_V

Source

View Text - Preformatted


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 , 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 , 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 , fnd_date.date_to_chardate(fnd_date.canonical_to_date(information12), 1) information112 , information113 , information114 , fnd_date.date_to_chardate(fnd_date.canonical_to_date(information15), 1) information115 , fnd_date.date_to_chardate(fnd_date.canonical_to_date(information16), 1) 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 , fnd_date.date_to_chardate(fnd_date.canonical_to_date(information45), 1) information145 , information146 , information147 , fnd_date.date_to_chardate(fnd_date.canonical_to_date(information48), 1) 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

View Text - HTML Formatted

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
, 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
, 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
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION12)
, 1) INFORMATION112
, INFORMATION113
, INFORMATION114
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION15)
, 1) INFORMATION115
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION16)
, 1) 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
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION45)
, 1) INFORMATION145
, INFORMATION146
, INFORMATION147
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION48)
, 1) 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