VIEW: AMS.AMS_LIST_ENTRIES#

Source

View Text - Preformatted

select LIST_ENTRY_ID LIST_ENTRY_ID, LIST_HEADER_ID LIST_HEADER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID, ARC_LIST_SELECT_ACTION_FROM ARC_LIST_SELECT_ACTION_FROM, LIST_SELECT_ACTION_FROM_NAME LIST_SELECT_ACTION_FROM_NAME, SOURCE_CODE SOURCE_CODE, ARC_LIST_USED_BY_SOURCE ARC_LIST_USED_BY_SOURCE, SOURCE_CODE_FOR_ID SOURCE_CODE_FOR_ID, PIN_CODE PIN_CODE, LIST_ENTRY_SOURCE_SYSTEM_ID LIST_ENTRY_SOURCE_SYSTEM_ID, LIST_ENTRY_SOURCE_SYSTEM_TYPE LIST_ENTRY_SOURCE_SYSTEM_TYPE, VIEW_APPLICATION_ID VIEW_APPLICATION_ID, MANUALLY_ENTERED_FLAG MANUALLY_ENTERED_FLAG, MARKED_AS_DUPLICATE_FLAG MARKED_AS_DUPLICATE_FLAG, MARKED_AS_RANDOM_FLAG MARKED_AS_RANDOM_FLAG, PART_OF_CONTROL_GROUP_FLAG PART_OF_CONTROL_GROUP_FLAG, EXCLUDE_IN_TRIGGERED_LIST_FLAG EXCLUDE_IN_TRIGGERED_LIST_FLAG, ENABLED_FLAG ENABLED_FLAG, CELL_CODE CELL_CODE, DEDUPE_KEY DEDUPE_KEY, RANDOMLY_GENERATED_NUMBER RANDOMLY_GENERATED_NUMBER, CAMPAIGN_ID CAMPAIGN_ID, MEDIA_ID MEDIA_ID, CHANNEL_ID CHANNEL_ID, CHANNEL_SCHEDULE_ID CHANNEL_SCHEDULE_ID, EVENT_OFFER_ID EVENT_OFFER_ID, CUSTOMER_ID CUSTOMER_ID, MARKET_SEGMENT_ID MARKET_SEGMENT_ID, VENDOR_ID VENDOR_ID, TRANSFER_FLAG TRANSFER_FLAG, TRANSFER_STATUS TRANSFER_STATUS, LIST_SOURCE LIST_SOURCE, DUPLICATE_MASTER_ENTRY_ID DUPLICATE_MASTER_ENTRY_ID, MARKED_FLAG MARKED_FLAG, LEAD_ID LEAD_ID, LETTER_ID LETTER_ID, PICKING_HEADER_ID PICKING_HEADER_ID, BATCH_ID BATCH_ID, SUFFIX SUFFIX, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, CUSTOMER_NAME CUSTOMER_NAME, TITLE TITLE, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, CITY CITY, STATE STATE, ZIPCODE ZIPCODE, COUNTRY COUNTRY, FAX FAX, PHONE PHONE, EMAIL_ADDRESS EMAIL_ADDRESS, COL1 COL1, COL2 COL2, COL3 COL3, COL4 COL4, COL5 COL5, COL6 COL6, COL7 COL7, COL8 COL8, COL9 COL9, COL10 COL10, COL11 COL11, COL12 COL12, COL13 COL13, COL14 COL14, COL15 COL15, COL16 COL16, COL17 COL17, COL18 COL18, COL19 COL19, COL20 COL20, COL21 COL21, COL22 COL22, COL23 COL23, COL24 COL24, COL25 COL25, COL26 COL26, COL27 COL27, COL28 COL28, COL29 COL29, COL30 COL30, COL31 COL31, COL32 COL32, COL33 COL33, COL34 COL34, COL35 COL35, COL36 COL36, COL37 COL37, COL38 COL38, COL39 COL39, COL40 COL40, COL41 COL41, COL42 COL42, COL43 COL43, COL44 COL44, COL45 COL45, COL46 COL46, COL47 COL47, COL48 COL48, COL49 COL49, COL50 COL50, COL51 COL51, COL52 COL52, COL53 COL53, COL54 COL54, COL55 COL55, COL56 COL56, COL57 COL57, COL58 COL58, COL59 COL59, COL60 COL60, COL61 COL61, COL62 COL62, COL63 COL63, COL64 COL64, COL65 COL65, COL66 COL66, COL67 COL67, COL68 COL68, COL69 COL69, COL70 COL70, COL71 COL71, COL72 COL72, COL73 COL73, COL74 COL74, COL75 COL75, COL76 COL76, COL77 COL77, COL78 COL78, COL79 COL79, COL80 COL80, COL81 COL81, COL82 COL82, COL83 COL83, COL84 COL84, COL85 COL85, COL86 COL86, COL87 COL87, COL88 COL88, COL89 COL89, COL90 COL90, COL91 COL91, COL92 COL92, COL93 COL93, COL94 COL94, COL95 COL95, COL96 COL96, COL97 COL97, COL98 COL98, COL99 COL99, COL100 COL100, COL101 COL101, COL102 COL102, COL103 COL103, COL104 COL104, COL105 COL105, COL106 COL106, COL107 COL107, COL108 COL108, COL109 COL109, COL110 COL110, COL111 COL111, COL112 COL112, COL113 COL113, COL114 COL114, COL115 COL115, COL116 COL116, COL117 COL117, COL118 COL118, COL119 COL119, COL120 COL120, COL121 COL121, COL122 COL122, COL123 COL123, COL124 COL124, COL125 COL125, COL126 COL126, COL127 COL127, COL128 COL128, COL129 COL129, COL130 COL130, COL131 COL131, COL132 COL132, COL133 COL133, COL134 COL134, COL135 COL135, COL136 COL136, COL137 COL137, COL138 COL138, COL139 COL139, COL140 COL140, COL141 COL141, COL142 COL142, COL143 COL143, COL144 COL144, COL145 COL145, COL146 COL146, COL147 COL147, COL148 COL148, COL149 COL149, COL150 COL150, COL151 COL151, COL152 COL152, COL153 COL153, COL154 COL154, COL155 COL155, COL156 COL156, COL157 COL157, COL158 COL158, COL159 COL159, COL160 COL160, COL161 COL161, COL162 COL162, COL163 COL163, COL164 COL164, COL165 COL165, COL166 COL166, COL167 COL167, COL168 COL168, COL169 COL169, COL170 COL170, COL171 COL171, COL172 COL172, COL173 COL173, COL174 COL174, COL175 COL175, COL176 COL176, COL177 COL177, COL178 COL178, COL179 COL179, COL180 COL180, COL181 COL181, COL182 COL182, COL183 COL183, COL184 COL184, COL185 COL185, COL186 COL186, COL187 COL187, COL188 COL188, COL189 COL189, COL190 COL190, COL191 COL191, COL192 COL192, COL193 COL193, COL194 COL194, COL195 COL195, COL196 COL196, COL197 COL197, COL198 COL198, COL199 COL199, COL200 COL200, COL201 COL201, COL202 COL202, COL203 COL203, COL204 COL204, COL205 COL205, COL206 COL206, COL207 COL207, COL208 COL208, COL209 COL209, COL210 COL210, COL211 COL211, COL212 COL212, COL213 COL213, COL214 COL214, COL215 COL215, COL216 COL216, COL217 COL217, COL218 COL218, COL219 COL219, COL220 COL220, COL221 COL221, COL222 COL222, COL223 COL223, COL224 COL224, COL225 COL225, COL226 COL226, COL227 COL227, COL228 COL228, COL229 COL229, COL230 COL230, COL231 COL231, COL232 COL232, COL233 COL233, COL234 COL234, COL235 COL235, COL236 COL236, COL237 COL237, COL238 COL238, COL239 COL239, COL240 COL240, COL241 COL241, COL242 COL242, COL243 COL243, COL244 COL244, COL245 COL245, COL246 COL246, COL247 COL247, COL248 COL248, COL249 COL249, COL250 COL250, PARTY_ID PARTY_ID, PARENT_PARTY_ID PARENT_PARTY_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, GEOMETRY GEOMETRY, IMP_SOURCE_LINE_ID IMP_SOURCE_LINE_ID, USAGE_RESTRICTION USAGE_RESTRICTION, NEXT_CALL_TIME NEXT_CALL_TIME, CALLBACK_FLAG CALLBACK_FLAG, DO_NOT_USE_FLAG DO_NOT_USE_FLAG, DO_NOT_USE_REASON DO_NOT_USE_REASON, RECORD_OUT_FLAG RECORD_OUT_FLAG, RECORD_RELEASE_TIME RECORD_RELEASE_TIME, CURR_CP_ID CURR_CP_ID, CURR_CP_TIME_ZONE CURR_CP_TIME_ZONE, CURR_CP_TIME_ZONE_AUX CURR_CP_TIME_ZONE_AUX, CURR_CP_COUNTRY_CODE CURR_CP_COUNTRY_CODE, CURR_CP_INDEX CURR_CP_INDEX, CURR_CP_AREA_CODE CURR_CP_AREA_CODE, CURR_CP_PHONE_NUMBER CURR_CP_PHONE_NUMBER, CURR_CP_RAW_PHONE_NUMBER CURR_CP_RAW_PHONE_NUMBER, COL251 COL251, COL252 COL252, COL253 COL253, COL254 COL254, COL256 COL256, COL255 COL255, COL257 COL257, COL258 COL258, COL259 COL259, COL260 COL260, COL261 COL261, COL262 COL262, COL263 COL263, COL264 COL264, COL265 COL265, COL266 COL266, COL267 COL267, COL268 COL268, COL269 COL269, COL270 COL270, COL271 COL271, COL272 COL272, COL273 COL273, COL274 COL274, COL275 COL275, COL276 COL276, COL277 COL277, COL278 COL278, COL279 COL279, COL280 COL280, COL281 COL281, COL282 COL282, COL283 COL283, COL284 COL284, COL285 COL285, COL286 COL286, COL287 COL287, COL288 COL288, COL289 COL289, COL290 COL290, COL291 COL291, COL292 COL292, COL293 COL293, COL294 COL294, COL295 COL295, COL296 COL296, COL297 COL297, COL298 COL298, COL299 COL299, COL300 COL300, GROUP_CODE GROUP_CODE, NEWLY_UPDATED_FLAG NEWLY_UPDATED_FLAG, OUTCOME_ID OUTCOME_ID, RESULT_ID RESULT_ID, REASON_ID REASON_ID, NOTES NOTES, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE, SALES_AGENT_EMAIL_ADDRESS SALES_AGENT_EMAIL_ADDRESS, RESOURCE_ID RESOURCE_ID, LOCATION_ID LOCATION_ID, CONTACT_POINT_ID CONTACT_POINT_ID, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, LAST_CONTACTED_DATE LAST_CONTACTED_DATE, CUSTOM_COLUMN1 CUSTOM_COLUMN1, CUSTOM_COLUMN2 CUSTOM_COLUMN2, CUSTOM_COLUMN3 CUSTOM_COLUMN3, CUSTOM_COLUMN4 CUSTOM_COLUMN4, CUSTOM_COLUMN5 CUSTOM_COLUMN5, CUSTOM_COLUMN6 CUSTOM_COLUMN6, CUSTOM_COLUMN7 CUSTOM_COLUMN7, CUSTOM_COLUMN8 CUSTOM_COLUMN8, CUSTOM_COLUMN9 CUSTOM_COLUMN9, CUSTOM_COLUMN10 CUSTOM_COLUMN10, CUSTOM_COLUMN11 CUSTOM_COLUMN11, CUSTOM_COLUMN12 CUSTOM_COLUMN12, CUSTOM_COLUMN13 CUSTOM_COLUMN13, CUSTOM_COLUMN14 CUSTOM_COLUMN14, CUSTOM_COLUMN15 CUSTOM_COLUMN15, CUSTOM_COLUMN16 CUSTOM_COLUMN16, CUSTOM_COLUMN17 CUSTOM_COLUMN17, CUSTOM_COLUMN18 CUSTOM_COLUMN18, CUSTOM_COLUMN19 CUSTOM_COLUMN19, CUSTOM_COLUMN20 CUSTOM_COLUMN20, CUSTOM_COLUMN21 CUSTOM_COLUMN21, CUSTOM_COLUMN22 CUSTOM_COLUMN22, CUSTOM_COLUMN23 CUSTOM_COLUMN23, CUSTOM_COLUMN24 CUSTOM_COLUMN24, CUSTOM_COLUMN25 CUSTOM_COLUMN25, MARKED_AS_FATIGUED_FLAG MARKED_AS_FATIGUED_FLAG, MARKED_AS_SUPPRESSED_FLAG MARKED_AS_SUPPRESSED_FLAG, REMOTE_LIST_ENTRY_ID REMOTE_LIST_ENTRY_ID, TCA_LOAD_STATUS TCA_LOAD_STATUS, RANK RANK, ERROR_FLAG ERROR_FLAG, ERROR_TEXT ERROR_TEXT from "AMS"."AMS_LIST_ENTRIES"

View Text - HTML Formatted

SELECT LIST_ENTRY_ID LIST_ENTRY_ID
, LIST_HEADER_ID LIST_HEADER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID
, ARC_LIST_SELECT_ACTION_FROM ARC_LIST_SELECT_ACTION_FROM
, LIST_SELECT_ACTION_FROM_NAME LIST_SELECT_ACTION_FROM_NAME
, SOURCE_CODE SOURCE_CODE
, ARC_LIST_USED_BY_SOURCE ARC_LIST_USED_BY_SOURCE
, SOURCE_CODE_FOR_ID SOURCE_CODE_FOR_ID
, PIN_CODE PIN_CODE
, LIST_ENTRY_SOURCE_SYSTEM_ID LIST_ENTRY_SOURCE_SYSTEM_ID
, LIST_ENTRY_SOURCE_SYSTEM_TYPE LIST_ENTRY_SOURCE_SYSTEM_TYPE
, VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, MANUALLY_ENTERED_FLAG MANUALLY_ENTERED_FLAG
, MARKED_AS_DUPLICATE_FLAG MARKED_AS_DUPLICATE_FLAG
, MARKED_AS_RANDOM_FLAG MARKED_AS_RANDOM_FLAG
, PART_OF_CONTROL_GROUP_FLAG PART_OF_CONTROL_GROUP_FLAG
, EXCLUDE_IN_TRIGGERED_LIST_FLAG EXCLUDE_IN_TRIGGERED_LIST_FLAG
, ENABLED_FLAG ENABLED_FLAG
, CELL_CODE CELL_CODE
, DEDUPE_KEY DEDUPE_KEY
, RANDOMLY_GENERATED_NUMBER RANDOMLY_GENERATED_NUMBER
, CAMPAIGN_ID CAMPAIGN_ID
, MEDIA_ID MEDIA_ID
, CHANNEL_ID CHANNEL_ID
, CHANNEL_SCHEDULE_ID CHANNEL_SCHEDULE_ID
, EVENT_OFFER_ID EVENT_OFFER_ID
, CUSTOMER_ID CUSTOMER_ID
, MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, VENDOR_ID VENDOR_ID
, TRANSFER_FLAG TRANSFER_FLAG
, TRANSFER_STATUS TRANSFER_STATUS
, LIST_SOURCE LIST_SOURCE
, DUPLICATE_MASTER_ENTRY_ID DUPLICATE_MASTER_ENTRY_ID
, MARKED_FLAG MARKED_FLAG
, LEAD_ID LEAD_ID
, LETTER_ID LETTER_ID
, PICKING_HEADER_ID PICKING_HEADER_ID
, BATCH_ID BATCH_ID
, SUFFIX SUFFIX
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, TITLE TITLE
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, CITY CITY
, STATE STATE
, ZIPCODE ZIPCODE
, COUNTRY COUNTRY
, FAX FAX
, PHONE PHONE
, EMAIL_ADDRESS EMAIL_ADDRESS
, COL1 COL1
, COL2 COL2
, COL3 COL3
, COL4 COL4
, COL5 COL5
, COL6 COL6
, COL7 COL7
, COL8 COL8
, COL9 COL9
, COL10 COL10
, COL11 COL11
, COL12 COL12
, COL13 COL13
, COL14 COL14
, COL15 COL15
, COL16 COL16
, COL17 COL17
, COL18 COL18
, COL19 COL19
, COL20 COL20
, COL21 COL21
, COL22 COL22
, COL23 COL23
, COL24 COL24
, COL25 COL25
, COL26 COL26
, COL27 COL27
, COL28 COL28
, COL29 COL29
, COL30 COL30
, COL31 COL31
, COL32 COL32
, COL33 COL33
, COL34 COL34
, COL35 COL35
, COL36 COL36
, COL37 COL37
, COL38 COL38
, COL39 COL39
, COL40 COL40
, COL41 COL41
, COL42 COL42
, COL43 COL43
, COL44 COL44
, COL45 COL45
, COL46 COL46
, COL47 COL47
, COL48 COL48
, COL49 COL49
, COL50 COL50
, COL51 COL51
, COL52 COL52
, COL53 COL53
, COL54 COL54
, COL55 COL55
, COL56 COL56
, COL57 COL57
, COL58 COL58
, COL59 COL59
, COL60 COL60
, COL61 COL61
, COL62 COL62
, COL63 COL63
, COL64 COL64
, COL65 COL65
, COL66 COL66
, COL67 COL67
, COL68 COL68
, COL69 COL69
, COL70 COL70
, COL71 COL71
, COL72 COL72
, COL73 COL73
, COL74 COL74
, COL75 COL75
, COL76 COL76
, COL77 COL77
, COL78 COL78
, COL79 COL79
, COL80 COL80
, COL81 COL81
, COL82 COL82
, COL83 COL83
, COL84 COL84
, COL85 COL85
, COL86 COL86
, COL87 COL87
, COL88 COL88
, COL89 COL89
, COL90 COL90
, COL91 COL91
, COL92 COL92
, COL93 COL93
, COL94 COL94
, COL95 COL95
, COL96 COL96
, COL97 COL97
, COL98 COL98
, COL99 COL99
, COL100 COL100
, COL101 COL101
, COL102 COL102
, COL103 COL103
, COL104 COL104
, COL105 COL105
, COL106 COL106
, COL107 COL107
, COL108 COL108
, COL109 COL109
, COL110 COL110
, COL111 COL111
, COL112 COL112
, COL113 COL113
, COL114 COL114
, COL115 COL115
, COL116 COL116
, COL117 COL117
, COL118 COL118
, COL119 COL119
, COL120 COL120
, COL121 COL121
, COL122 COL122
, COL123 COL123
, COL124 COL124
, COL125 COL125
, COL126 COL126
, COL127 COL127
, COL128 COL128
, COL129 COL129
, COL130 COL130
, COL131 COL131
, COL132 COL132
, COL133 COL133
, COL134 COL134
, COL135 COL135
, COL136 COL136
, COL137 COL137
, COL138 COL138
, COL139 COL139
, COL140 COL140
, COL141 COL141
, COL142 COL142
, COL143 COL143
, COL144 COL144
, COL145 COL145
, COL146 COL146
, COL147 COL147
, COL148 COL148
, COL149 COL149
, COL150 COL150
, COL151 COL151
, COL152 COL152
, COL153 COL153
, COL154 COL154
, COL155 COL155
, COL156 COL156
, COL157 COL157
, COL158 COL158
, COL159 COL159
, COL160 COL160
, COL161 COL161
, COL162 COL162
, COL163 COL163
, COL164 COL164
, COL165 COL165
, COL166 COL166
, COL167 COL167
, COL168 COL168
, COL169 COL169
, COL170 COL170
, COL171 COL171
, COL172 COL172
, COL173 COL173
, COL174 COL174
, COL175 COL175
, COL176 COL176
, COL177 COL177
, COL178 COL178
, COL179 COL179
, COL180 COL180
, COL181 COL181
, COL182 COL182
, COL183 COL183
, COL184 COL184
, COL185 COL185
, COL186 COL186
, COL187 COL187
, COL188 COL188
, COL189 COL189
, COL190 COL190
, COL191 COL191
, COL192 COL192
, COL193 COL193
, COL194 COL194
, COL195 COL195
, COL196 COL196
, COL197 COL197
, COL198 COL198
, COL199 COL199
, COL200 COL200
, COL201 COL201
, COL202 COL202
, COL203 COL203
, COL204 COL204
, COL205 COL205
, COL206 COL206
, COL207 COL207
, COL208 COL208
, COL209 COL209
, COL210 COL210
, COL211 COL211
, COL212 COL212
, COL213 COL213
, COL214 COL214
, COL215 COL215
, COL216 COL216
, COL217 COL217
, COL218 COL218
, COL219 COL219
, COL220 COL220
, COL221 COL221
, COL222 COL222
, COL223 COL223
, COL224 COL224
, COL225 COL225
, COL226 COL226
, COL227 COL227
, COL228 COL228
, COL229 COL229
, COL230 COL230
, COL231 COL231
, COL232 COL232
, COL233 COL233
, COL234 COL234
, COL235 COL235
, COL236 COL236
, COL237 COL237
, COL238 COL238
, COL239 COL239
, COL240 COL240
, COL241 COL241
, COL242 COL242
, COL243 COL243
, COL244 COL244
, COL245 COL245
, COL246 COL246
, COL247 COL247
, COL248 COL248
, COL249 COL249
, COL250 COL250
, PARTY_ID PARTY_ID
, PARENT_PARTY_ID PARENT_PARTY_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, GEOMETRY GEOMETRY
, IMP_SOURCE_LINE_ID IMP_SOURCE_LINE_ID
, USAGE_RESTRICTION USAGE_RESTRICTION
, NEXT_CALL_TIME NEXT_CALL_TIME
, CALLBACK_FLAG CALLBACK_FLAG
, DO_NOT_USE_FLAG DO_NOT_USE_FLAG
, DO_NOT_USE_REASON DO_NOT_USE_REASON
, RECORD_OUT_FLAG RECORD_OUT_FLAG
, RECORD_RELEASE_TIME RECORD_RELEASE_TIME
, CURR_CP_ID CURR_CP_ID
, CURR_CP_TIME_ZONE CURR_CP_TIME_ZONE
, CURR_CP_TIME_ZONE_AUX CURR_CP_TIME_ZONE_AUX
, CURR_CP_COUNTRY_CODE CURR_CP_COUNTRY_CODE
, CURR_CP_INDEX CURR_CP_INDEX
, CURR_CP_AREA_CODE CURR_CP_AREA_CODE
, CURR_CP_PHONE_NUMBER CURR_CP_PHONE_NUMBER
, CURR_CP_RAW_PHONE_NUMBER CURR_CP_RAW_PHONE_NUMBER
, COL251 COL251
, COL252 COL252
, COL253 COL253
, COL254 COL254
, COL256 COL256
, COL255 COL255
, COL257 COL257
, COL258 COL258
, COL259 COL259
, COL260 COL260
, COL261 COL261
, COL262 COL262
, COL263 COL263
, COL264 COL264
, COL265 COL265
, COL266 COL266
, COL267 COL267
, COL268 COL268
, COL269 COL269
, COL270 COL270
, COL271 COL271
, COL272 COL272
, COL273 COL273
, COL274 COL274
, COL275 COL275
, COL276 COL276
, COL277 COL277
, COL278 COL278
, COL279 COL279
, COL280 COL280
, COL281 COL281
, COL282 COL282
, COL283 COL283
, COL284 COL284
, COL285 COL285
, COL286 COL286
, COL287 COL287
, COL288 COL288
, COL289 COL289
, COL290 COL290
, COL291 COL291
, COL292 COL292
, COL293 COL293
, COL294 COL294
, COL295 COL295
, COL296 COL296
, COL297 COL297
, COL298 COL298
, COL299 COL299
, COL300 COL300
, GROUP_CODE GROUP_CODE
, NEWLY_UPDATED_FLAG NEWLY_UPDATED_FLAG
, OUTCOME_ID OUTCOME_ID
, RESULT_ID RESULT_ID
, REASON_ID REASON_ID
, NOTES NOTES
, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, SALES_AGENT_EMAIL_ADDRESS SALES_AGENT_EMAIL_ADDRESS
, RESOURCE_ID RESOURCE_ID
, LOCATION_ID LOCATION_ID
, CONTACT_POINT_ID CONTACT_POINT_ID
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LAST_CONTACTED_DATE LAST_CONTACTED_DATE
, CUSTOM_COLUMN1 CUSTOM_COLUMN1
, CUSTOM_COLUMN2 CUSTOM_COLUMN2
, CUSTOM_COLUMN3 CUSTOM_COLUMN3
, CUSTOM_COLUMN4 CUSTOM_COLUMN4
, CUSTOM_COLUMN5 CUSTOM_COLUMN5
, CUSTOM_COLUMN6 CUSTOM_COLUMN6
, CUSTOM_COLUMN7 CUSTOM_COLUMN7
, CUSTOM_COLUMN8 CUSTOM_COLUMN8
, CUSTOM_COLUMN9 CUSTOM_COLUMN9
, CUSTOM_COLUMN10 CUSTOM_COLUMN10
, CUSTOM_COLUMN11 CUSTOM_COLUMN11
, CUSTOM_COLUMN12 CUSTOM_COLUMN12
, CUSTOM_COLUMN13 CUSTOM_COLUMN13
, CUSTOM_COLUMN14 CUSTOM_COLUMN14
, CUSTOM_COLUMN15 CUSTOM_COLUMN15
, CUSTOM_COLUMN16 CUSTOM_COLUMN16
, CUSTOM_COLUMN17 CUSTOM_COLUMN17
, CUSTOM_COLUMN18 CUSTOM_COLUMN18
, CUSTOM_COLUMN19 CUSTOM_COLUMN19
, CUSTOM_COLUMN20 CUSTOM_COLUMN20
, CUSTOM_COLUMN21 CUSTOM_COLUMN21
, CUSTOM_COLUMN22 CUSTOM_COLUMN22
, CUSTOM_COLUMN23 CUSTOM_COLUMN23
, CUSTOM_COLUMN24 CUSTOM_COLUMN24
, CUSTOM_COLUMN25 CUSTOM_COLUMN25
, MARKED_AS_FATIGUED_FLAG MARKED_AS_FATIGUED_FLAG
, MARKED_AS_SUPPRESSED_FLAG MARKED_AS_SUPPRESSED_FLAG
, REMOTE_LIST_ENTRY_ID REMOTE_LIST_ENTRY_ID
, TCA_LOAD_STATUS TCA_LOAD_STATUS
, RANK RANK
, ERROR_FLAG ERROR_FLAG
, ERROR_TEXT ERROR_TEXT
FROM "AMS"."AMS_LIST_ENTRIES"