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]

VIEW: CN.CN_IMP_LINES#

Object Details

Object Name:	CN_IMP_LINES#
Object Type:	VIEW
Owner:	CN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
IMP_LINE_ID	NUMBER	(15)	Yes
IMP_HEADER_ID	NUMBER	(15)	Yes
STATUS_CODE	VARCHAR2	(30)	Yes
ERROR_CODE	VARCHAR2	(30)
IMPORT_TYPE_CODE	VARCHAR2	(30)	Yes
UNMAP	VARCHAR2	(240)
OBJECT_VERSION_NUMBER	NUMBER		Yes
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
COL1	VARCHAR2	(240)
COL2	VARCHAR2	(240)
COL3	VARCHAR2	(240)
COL4	VARCHAR2	(240)
COL5	VARCHAR2	(240)
COL6	VARCHAR2	(240)
COL7	VARCHAR2	(240)
COL8	VARCHAR2	(240)
COL9	VARCHAR2	(240)
COL10	VARCHAR2	(240)
COL11	VARCHAR2	(240)
COL12	VARCHAR2	(240)
COL13	VARCHAR2	(240)
COL14	VARCHAR2	(240)
COL15	VARCHAR2	(240)
COL16	VARCHAR2	(240)
COL17	VARCHAR2	(240)
COL18	VARCHAR2	(240)
COL19	VARCHAR2	(240)
COL20	VARCHAR2	(240)
COL21	VARCHAR2	(240)
COL22	VARCHAR2	(240)
COL23	VARCHAR2	(240)
COL24	VARCHAR2	(240)
COL25	VARCHAR2	(240)
COL26	VARCHAR2	(240)
COL27	VARCHAR2	(240)
COL28	VARCHAR2	(240)
COL29	VARCHAR2	(240)
COL30	VARCHAR2	(240)
COL31	VARCHAR2	(240)
COL32	VARCHAR2	(240)
COL33	VARCHAR2	(240)
COL34	VARCHAR2	(240)
COL35	VARCHAR2	(240)
COL36	VARCHAR2	(240)
COL37	VARCHAR2	(240)
COL38	VARCHAR2	(240)
COL39	VARCHAR2	(240)
COL40	VARCHAR2	(240)
COL41	VARCHAR2	(240)
COL42	VARCHAR2	(240)
COL43	VARCHAR2	(240)
COL44	VARCHAR2	(240)
COL45	VARCHAR2	(240)
COL46	VARCHAR2	(240)
COL47	VARCHAR2	(240)
COL48	VARCHAR2	(240)
COL49	VARCHAR2	(240)
COL50	VARCHAR2	(240)
COL51	VARCHAR2	(240)
COL52	VARCHAR2	(240)
COL53	VARCHAR2	(240)
COL54	VARCHAR2	(240)
COL55	VARCHAR2	(240)
COL56	VARCHAR2	(240)
COL57	VARCHAR2	(240)
COL58	VARCHAR2	(240)
COL59	VARCHAR2	(240)
COL60	VARCHAR2	(240)
COL61	VARCHAR2	(240)
COL62	VARCHAR2	(240)
COL63	VARCHAR2	(240)
COL64	VARCHAR2	(240)
COL65	VARCHAR2	(240)
COL66	VARCHAR2	(240)
COL67	VARCHAR2	(240)
COL68	VARCHAR2	(240)
COL69	VARCHAR2	(240)
COL70	VARCHAR2	(240)
COL71	VARCHAR2	(240)
COL72	VARCHAR2	(240)
COL73	VARCHAR2	(240)
COL74	VARCHAR2	(240)
COL75	VARCHAR2	(240)
COL76	VARCHAR2	(240)
COL77	VARCHAR2	(240)
COL78	VARCHAR2	(240)
COL79	VARCHAR2	(240)
COL80	VARCHAR2	(240)
COL81	VARCHAR2	(240)
COL82	VARCHAR2	(240)
COL83	VARCHAR2	(240)
COL84	VARCHAR2	(240)
COL85	VARCHAR2	(240)
COL86	VARCHAR2	(240)
COL87	VARCHAR2	(240)
COL88	VARCHAR2	(240)
COL89	VARCHAR2	(240)
COL90	VARCHAR2	(240)
COL91	VARCHAR2	(240)
COL92	VARCHAR2	(240)
COL93	VARCHAR2	(240)
COL94	VARCHAR2	(240)
COL95	VARCHAR2	(240)
COL96	VARCHAR2	(240)
COL97	VARCHAR2	(240)
COL98	VARCHAR2	(240)
COL99	VARCHAR2	(240)
COL100	VARCHAR2	(240)
COL101	VARCHAR2	(240)
COL102	VARCHAR2	(240)
COL103	VARCHAR2	(240)
COL104	VARCHAR2	(240)
COL105	VARCHAR2	(240)
COL106	VARCHAR2	(240)
COL107	VARCHAR2	(240)
COL108	VARCHAR2	(240)
COL109	VARCHAR2	(240)
COL110	VARCHAR2	(240)
COL111	VARCHAR2	(240)
COL112	VARCHAR2	(240)
COL113	VARCHAR2	(240)
COL114	VARCHAR2	(240)
COL115	VARCHAR2	(240)
COL116	VARCHAR2	(240)
COL117	VARCHAR2	(240)
COL118	VARCHAR2	(240)
COL119	VARCHAR2	(240)
COL120	VARCHAR2	(240)
COL121	VARCHAR2	(240)
COL122	VARCHAR2	(240)
COL123	VARCHAR2	(240)
COL124	VARCHAR2	(240)
COL125	VARCHAR2	(240)
COL126	VARCHAR2	(240)
COL127	VARCHAR2	(240)
COL128	VARCHAR2	(240)
COL129	VARCHAR2	(240)
COL130	VARCHAR2	(240)
COL131	VARCHAR2	(240)
COL132	VARCHAR2	(240)
COL133	VARCHAR2	(240)
COL134	VARCHAR2	(240)
COL135	VARCHAR2	(240)
COL136	VARCHAR2	(240)
COL137	VARCHAR2	(240)
COL138	VARCHAR2	(240)
COL139	VARCHAR2	(240)
COL140	VARCHAR2	(240)
COL141	VARCHAR2	(240)
COL142	VARCHAR2	(240)
COL143	VARCHAR2	(240)
COL144	VARCHAR2	(240)
COL145	VARCHAR2	(240)
COL146	VARCHAR2	(240)
COL147	VARCHAR2	(240)
COL148	VARCHAR2	(240)
COL149	VARCHAR2	(240)
COL150	VARCHAR2	(240)
COL151	VARCHAR2	(240)
COL152	VARCHAR2	(240)
COL153	VARCHAR2	(240)
COL154	VARCHAR2	(240)
COL155	VARCHAR2	(240)
COL156	VARCHAR2	(240)
COL157	VARCHAR2	(240)
COL158	VARCHAR2	(240)
COL159	VARCHAR2	(240)
COL160	VARCHAR2	(240)
COL161	VARCHAR2	(240)
COL162	VARCHAR2	(240)
COL163	VARCHAR2	(240)
COL164	VARCHAR2	(240)
COL165	VARCHAR2	(240)
COL166	VARCHAR2	(240)
COL167	VARCHAR2	(240)
COL168	VARCHAR2	(240)
COL169	VARCHAR2	(240)
COL170	VARCHAR2	(240)
COL171	VARCHAR2	(240)
COL172	VARCHAR2	(240)
COL173	VARCHAR2	(240)
COL174	VARCHAR2	(240)
COL175	VARCHAR2	(240)
COL176	VARCHAR2	(240)
COL177	VARCHAR2	(240)
COL178	VARCHAR2	(240)
COL179	VARCHAR2	(240)
COL180	VARCHAR2	(240)
COL181	VARCHAR2	(240)
COL182	VARCHAR2	(240)
COL183	VARCHAR2	(240)
COL184	VARCHAR2	(240)
COL185	VARCHAR2	(240)
COL186	VARCHAR2	(240)
COL187	VARCHAR2	(240)
COL188	VARCHAR2	(240)
COL189	VARCHAR2	(240)
COL190	VARCHAR2	(240)
COL191	VARCHAR2	(240)
COL192	VARCHAR2	(240)
COL193	VARCHAR2	(240)
COL194	VARCHAR2	(240)
COL195	VARCHAR2	(240)
COL196	VARCHAR2	(240)
COL197	VARCHAR2	(240)
COL198	VARCHAR2	(240)
COL199	VARCHAR2	(240)
COL200	VARCHAR2	(240)
COL201	VARCHAR2	(240)
COL202	VARCHAR2	(240)
COL203	VARCHAR2	(240)
COL204	VARCHAR2	(240)
COL205	VARCHAR2	(240)
COL206	VARCHAR2	(240)
COL207	VARCHAR2	(240)
COL208	VARCHAR2	(240)
COL209	VARCHAR2	(240)
COL210	VARCHAR2	(240)
COL211	VARCHAR2	(240)
COL212	VARCHAR2	(240)
COL213	VARCHAR2	(240)
COL214	VARCHAR2	(240)
COL215	VARCHAR2	(240)
COL216	VARCHAR2	(240)
COL217	VARCHAR2	(240)
COL218	VARCHAR2	(240)
COL219	VARCHAR2	(240)
COL220	VARCHAR2	(240)
COL221	VARCHAR2	(240)
COL222	VARCHAR2	(240)
COL223	VARCHAR2	(240)
COL224	VARCHAR2	(240)
COL225	VARCHAR2	(240)
COL226	VARCHAR2	(240)
COL227	VARCHAR2	(240)
COL228	VARCHAR2	(240)
COL229	VARCHAR2	(240)
COL230	VARCHAR2	(240)
COL231	VARCHAR2	(240)
COL232	VARCHAR2	(240)
COL233	VARCHAR2	(240)
COL234	VARCHAR2	(240)
COL235	VARCHAR2	(240)
COL236	VARCHAR2	(240)
COL237	VARCHAR2	(240)
COL238	VARCHAR2	(240)
COL239	VARCHAR2	(240)
COL240	VARCHAR2	(240)
COL241	VARCHAR2	(240)
COL242	VARCHAR2	(240)
COL243	VARCHAR2	(240)
COL244	VARCHAR2	(240)
COL245	VARCHAR2	(240)
COL246	VARCHAR2	(240)
COL247	VARCHAR2	(240)
COL248	VARCHAR2	(240)
COL249	VARCHAR2	(240)
COL250	VARCHAR2	(240)
SECURITY_GROUP_ID	NUMBER
ERROR_MSG	VARCHAR2	(2000)
RECORD_NUM	NUMBER

Query Text

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


SELECT IMP_LINE_ID
,      IMP_HEADER_ID
,      STATUS_CODE
,      ERROR_CODE
,      IMPORT_TYPE_CODE
,      UNMAP
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      COL6
,      COL7
,      COL8
,      COL9
,      COL10
,      COL11
,      COL12
,      COL13
,      COL14
,      COL15
,      COL16
,      COL17
,      COL18
,      COL19
,      COL20
,      COL21
,      COL22
,      COL23
,      COL24
,      COL25
,      COL26
,      COL27
,      COL28
,      COL29
,      COL30
,      COL31
,      COL32
,      COL33
,      COL34
,      COL35
,      COL36
,      COL37
,      COL38
,      COL39
,      COL40
,      COL41
,      COL42
,      COL43
,      COL44
,      COL45
,      COL46
,      COL47
,      COL48
,      COL49
,      COL50
,      COL51
,      COL52
,      COL53
,      COL54
,      COL55
,      COL56
,      COL57
,      COL58
,      COL59
,      COL60
,      COL61
,      COL62
,      COL63
,      COL64
,      COL65
,      COL66
,      COL67
,      COL68
,      COL69
,      COL70
,      COL71
,      COL72
,      COL73
,      COL74
,      COL75
,      COL76
,      COL77
,      COL78
,      COL79
,      COL80
,      COL81
,      COL82
,      COL83
,      COL84
,      COL85
,      COL86
,      COL87
,      COL88
,      COL89
,      COL90
,      COL91
,      COL92
,      COL93
,      COL94
,      COL95
,      COL96
,      COL97
,      COL98
,      COL99
,      COL100
,      COL101
,      COL102
,      COL103
,      COL104
,      COL105
,      COL106
,      COL107
,      COL108
,      COL109
,      COL110
,      COL111
,      COL112
,      COL113
,      COL114
,      COL115
,      COL116
,      COL117
,      COL118
,      COL119
,      COL120
,      COL121
,      COL122
,      COL123
,      COL124
,      COL125
,      COL126
,      COL127
,      COL128
,      COL129
,      COL130
,      COL131
,      COL132
,      COL133
,      COL134
,      COL135
,      COL136
,      COL137
,      COL138
,      COL139
,      COL140
,      COL141
,      COL142
,      COL143
,      COL144
,      COL145
,      COL146
,      COL147
,      COL148
,      COL149
,      COL150
,      COL151
,      COL152
,      COL153
,      COL154
,      COL155
,      COL156
,      COL157
,      COL158
,      COL159
,      COL160
,      COL161
,      COL162
,      COL163
,      COL164
,      COL165
,      COL166
,      COL167
,      COL168
,      COL169
,      COL170
,      COL171
,      COL172
,      COL173
,      COL174
,      COL175
,      COL176
,      COL177
,      COL178
,      COL179
,      COL180
,      COL181
,      COL182
,      COL183
,      COL184
,      COL185
,      COL186
,      COL187
,      COL188
,      COL189
,      COL190
,      COL191
,      COL192
,      COL193
,      COL194
,      COL195
,      COL196
,      COL197
,      COL198
,      COL199
,      COL200
,      COL201
,      COL202
,      COL203
,      COL204
,      COL205
,      COL206
,      COL207
,      COL208
,      COL209
,      COL210
,      COL211
,      COL212
,      COL213
,      COL214
,      COL215
,      COL216
,      COL217
,      COL218
,      COL219
,      COL220
,      COL221
,      COL222
,      COL223
,      COL224
,      COL225
,      COL226
,      COL227
,      COL228
,      COL229
,      COL230
,      COL231
,      COL232
,      COL233
,      COL234
,      COL235
,      COL236
,      COL237
,      COL238
,      COL239
,      COL240
,      COL241
,      COL242
,      COL243
,      COL244
,      COL245
,      COL246
,      COL247
,      COL248
,      COL249
,      COL250
,      SECURITY_GROUP_ID
,      ERROR_MSG
,      RECORD_NUM
FROM CN.CN_IMP_LINES#;

Dependencies

[top of page]

CN.CN_IMP_LINES# references the following:

CN: CN_IMP_LINES

CN.CN_IMP_LINES# is referenced by following:

APPS: CN_IMP_LINES