DBA Data[Home] [Help] [Dependency Information]


VIEW: HR.PQH_COPY_ENTITY_RESULTS#

Object Details
Object Name: PQH_COPY_ENTITY_RESULTS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COPY_ENTITY_RESULT_ID NUMBER (15) Yes
COPY_ENTITY_TXN_ID NUMBER (15) Yes
SRC_COPY_ENTITY_RESULT_ID NUMBER (15)
RESULT_TYPE_CD VARCHAR2 (30) Yes
NUMBER_OF_COPIES NUMBER (10)
STATUS VARCHAR2 (30)
INFORMATION_CATEGORY VARCHAR2 (30)
INFORMATION1 VARCHAR2 (2000)
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)
INFORMATION40 VARCHAR2 (255)
INFORMATION41 VARCHAR2 (255)
INFORMATION42 VARCHAR2 (255)
INFORMATION43 VARCHAR2 (255)
INFORMATION44 VARCHAR2 (255)
INFORMATION45 VARCHAR2 (255)
INFORMATION46 VARCHAR2 (255)
INFORMATION47 VARCHAR2 (255)
INFORMATION48 VARCHAR2 (255)
INFORMATION49 VARCHAR2 (255)
INFORMATION50 VARCHAR2 (255)
INFORMATION51 VARCHAR2 (255)
INFORMATION52 VARCHAR2 (2000)
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)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
INFORMATION91 VARCHAR2 (255)
INFORMATION92 VARCHAR2 (255)
INFORMATION93 VARCHAR2 (255)
INFORMATION94 VARCHAR2 (255)
INFORMATION95 VARCHAR2 (255)
INFORMATION96 VARCHAR2 (255)
INFORMATION97 VARCHAR2 (255)
INFORMATION98 VARCHAR2 (2000)
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 (2000)
INFORMATION182 VARCHAR2 (2000)
INFORMATION183 VARCHAR2 (2000)
INFORMATION184 VARCHAR2 (2000)
INFORMATION185 VARCHAR2 (2000)
INFORMATION186 VARCHAR2 (2000)
INFORMATION187 VARCHAR2 (2000)
INFORMATION188 VARCHAR2 (2000)
INFORMATION189 VARCHAR2 (2000)
INFORMATION190 VARCHAR2 (2000)
MIRROR_ENTITY_RESULT_ID NUMBER (15)
MIRROR_SRC_ENTITY_RESULT_ID NUMBER (15)
PARENT_ENTITY_RESULT_ID NUMBER (15)
TABLE_ROUTE_ID NUMBER (15)
LONG_ATTRIBUTE1 CLOB (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COPY_ENTITY_RESULT_ID
,      COPY_ENTITY_TXN_ID
,      SRC_COPY_ENTITY_RESULT_ID
,      RESULT_TYPE_CD
,      NUMBER_OF_COPIES
,      STATUS
,      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
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      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
,      MIRROR_ENTITY_RESULT_ID
,      MIRROR_SRC_ENTITY_RESULT_ID
,      PARENT_ENTITY_RESULT_ID
,      TABLE_ROUTE_ID
,      LONG_ATTRIBUTE1
FROM HR.PQH_COPY_ENTITY_RESULTS#;

Dependencies

[top of page]

HR.PQH_COPY_ENTITY_RESULTS# references the following:

SchemaHR
TablePQH_COPY_ENTITY_RESULTS
HR.PQH_COPY_ENTITY_RESULTS# is referenced by following:

SchemaAPPS
SynonymPQH_COPY_ENTITY_RESULTS
TriggerPQH_COPY_ENTITY_RESULTS_WHO