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.

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

TABLE: HR.PQH_COPY_ENTITY_RESULTS

Object Details

Object Name:	PQH_COPY_ENTITY_RESULTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_COPY_ENTITY_RESULTS
Subobject Name:
Status:	VALID

Transaction entity which holds process data

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_COPY_ENTITY_RESULTS_PK

COPY_ENTITY_RESULT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_COPY_ENTITY_RESULTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	COPY_ENTITY_RESULT_ID
SYS_IL0000085977C00208$$	LOB	UNIQUE	APPS_TS_TX_DATA
PQH_COPY_ENTITY_RESULTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SRC_COPY_ENTITY_RESULT_ID
PQH_COPY_ENTITY_RESULTS_NK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION1
PQH_COPY_ENTITY_RESULTS_NK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COPY_ENTITY_TXN_ID MIRROR_SRC_ENTITY_RESULT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_RESULTS SRC_COPY_ENTITY_RESULT_ID
PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_TXNS	PQH_COPY_ENTITY_RESULTS COPY_ENTITY_TXN_ID
PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_RESULTS SRC_COPY_ENTITY_RESULT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COPY_ENTITY_RESULT_ID	NUMBER	(15)	Yes	Primary Key
COPY_ENTITY_TXN_ID	NUMBER	(15)	Yes	Batch Identifier
SRC_COPY_ENTITY_RESULT_ID	NUMBER	(15)		Associated Master record (if any)
RESULT_TYPE_CD	VARCHAR2	(30)	Yes	Record type (Source / Target)
NUMBER_OF_COPIES	NUMBER	(10)		Number of copies
STATUS	VARCHAR2	(30)		Record Status (Pending Original Records, Pending New Records, Error New Records, Completed)
INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield
INFORMATION1	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION2	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION3	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION4	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION5	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION6	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION7	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION8	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION9	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION10	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION11	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION12	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION13	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION14	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION15	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION16	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION17	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION18	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION19	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION20	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION21	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION22	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION23	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION24	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION25	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION26	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION27	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION28	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION29	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION30	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION31	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION32	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION33	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION34	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION35	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION36	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION37	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION38	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION39	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION40	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION41	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION42	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION43	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION44	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION45	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION46	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION47	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION48	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION49	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION50	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION51	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION52	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION53	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION54	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION55	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION56	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION57	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION58	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION59	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION60	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION61	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION62	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION63	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION64	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION65	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION66	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION67	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION68	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION69	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION70	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION71	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION72	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION73	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION74	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION75	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION76	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION77	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION78	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION79	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION80	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION81	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION82	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION83	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION84	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION85	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION86	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION87	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION88	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION89	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION90	VARCHAR2	(255)		Developer descriptive flexfield
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version Number
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
INFORMATION91	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION92	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION93	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION94	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION95	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION96	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION97	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION98	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION99	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION100	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION101	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION102	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION103	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION104	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION105	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION106	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION107	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION108	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION109	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION110	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION111	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION112	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION113	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION114	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION115	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION116	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION117	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION118	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION119	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION120	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION121	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION122	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION123	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION124	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION125	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION126	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION127	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION128	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION129	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION130	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION131	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION132	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION133	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION134	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION135	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION136	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION137	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION138	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION139	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION140	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION141	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION142	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION143	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION144	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION145	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION146	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION147	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION148	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION149	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION150	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION151	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION152	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION153	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION154	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION155	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION156	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION157	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION158	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION159	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION160	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION161	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION162	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION163	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION164	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION165	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION166	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION167	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION168	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION169	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION170	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION171	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION172	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION173	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION174	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION175	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION176	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION177	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION178	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION179	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION180	VARCHAR2	(255)		Developer descriptive flexfield
INFORMATION181	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION182	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION183	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION184	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION185	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION186	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION187	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION188	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION189	VARCHAR2	(2000)		Developer descriptive flexfield
INFORMATION190	VARCHAR2	(2000)		Developer descriptive flexfield
MIRROR_ENTITY_RESULT_ID	NUMBER	(15)		Mirror attribute of PK, used to track uploaded data hierarchy
MIRROR_SRC_ENTITY_RESULT_ID	NUMBER	(15)		Mirror attribute of source identifier, used to track uploaded data hierarchy
PARENT_ENTITY_RESULT_ID	NUMBER	(15)		Parent information exclusive to UI support
TABLE_ROUTE_ID	NUMBER	(15)		Associated Table Identifier for BEN Plan copy
LONG_ATTRIBUTE1	CLOB	(4000)		Long Developer descriptive flexfield

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 does not reference any database object

HR.PQH_COPY_ENTITY_RESULTS is referenced by following:

HR: PQH_COPY_ENTITY_RESULTS#