VIEW: APPS.PER_MASS_APP_ASSIGN_UPDATE_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, fnd_date.date_to_chardate(fnd_date.canonical_to_date(information14), 1) 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)), 1) information65, fnd_date.date_to_chardate(fnd_date.canonical_to_date(information61), 1) 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

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
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION14)
, 1) 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))
, 1) INFORMATION65
, FND_DATE.DATE_TO_CHARDATE(FND_DATE.CANONICAL_TO_DATE(INFORMATION61)
, 1) 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