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

TABLE: CN.CN_IMP_LINES

Object Details
Object Name: CN_IMP_LINES
Object Type: TABLE
Owner: CN
FND Design Data: TableCN.CN_IMP_LINES
Subobject Name:
Status: VALID


CN_IMP_LINES is the staging table for import process. It contains all mapped data transfered from user data file.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CN_IMP_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnIMP_LINE_ID
CN_IMP_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnIMP_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
IMP_LINE_ID NUMBER (15) Yes Identifier
IMP_HEADER_ID NUMBER (15) Yes Foreign key
STATUS_CODE VARCHAR2 (30) Yes Import status
ERROR_CODE VARCHAR2 (30)
Import error
IMPORT_TYPE_CODE VARCHAR2 (30) Yes Import Type code
UNMAP VARCHAR2 (240)
Dummy column used for unmapped columns.
OBJECT_VERSION_NUMBER NUMBER
Yes Standard Who column
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

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

Used in hosted environments
ERROR_MSG VARCHAR2 (2000)
Error messages
RECORD_NUM NUMBER

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

CN.CN_IMP_LINES is referenced by following:

SchemaAPPS
SynonymCN_IMP_LINES