[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_LIST_ENTRIES |
|---|---|
| Object Type: | TABLE |
| Owner: | AMS |
| FND Design Data: |  AMS.AMS_LIST_ENTRIES
|
| Subobject Name: | |
| Status: | VALID |
AMS_LIST_ENTRIES table is used to hold all customers/contacts/target prospects
generated for a list, to be used for mailshots, telemarketing etc.
The List Generation process populates this table. Rows are inserted into this table. No customer interaction result is inserted into this table. The only update done to this table is if deduplication is done or if a person manually adds a row to the table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMS_LIST_ENTRIES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LIST_ENTRY_ID
|
| SYS_IL0000080938C00318$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| SYS_IL0000080938C00319$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| AMS_LIST_ENTRIES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LIST_HEADER_ID
ENABLED_FLAG
IMP_SOURCE_LINE_ID
|
| AMS_LIST_ENTRIES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_CODE
ARC_LIST_USED_BY_SOURCE
|
| AMS_LIST_ENTRIES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PIN_CODE
|
| AMS_LIST_ENTRIES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LIST_HEADER_ID
LIST_ENTRY_SOURCE_SYSTEM_ID
LIST_ENTRY_SOURCE_SYSTEM_TYPE
|
| AMS_LIST_ENTRIES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
LIST_HEADER_ID
|
| AMS_LIST_ENTRIES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_ID
LIST_HEADER_ID
|
| AMS_LIST_ENTRIES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LIST_ENTRY_ID | NUMBER | Yes | The Unique identifer . | |
| LIST_HEADER_ID | NUMBER | Yes | Foreign key to ams_list_headers_all table. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
| LIST_SELECT_ACTION_ID | NUMBER | Yes | Foreign key to ams_list_select_actions table. | |
| ARC_LIST_SELECT_ACTION_FROM | VARCHAR2 | (30) | Yes | denormalized from ams_list_select_actions. |
| LIST_SELECT_ACTION_FROM_NAME | VARCHAR2 | (254) | denormalized from ams_list_select_actions. | |
| SOURCE_CODE | VARCHAR2 | (30) | Yes | Source code of marketing activity associated with the list. |
| ARC_LIST_USED_BY_SOURCE | VARCHAR2 | (30) | Yes | Qualifier used to identify activity. |
| SOURCE_CODE_FOR_ID | NUMBER | (30) | Yes | Foreign key to marketing activity. |
| PIN_CODE | VARCHAR2 | (30) | Yes | Uniquely identify list entry. |
| LIST_ENTRY_SOURCE_SYSTEM_ID | NUMBER | Yes | Foreign key to ams_list_src_type table. | |
| LIST_ENTRY_SOURCE_SYSTEM_TYPE | VARCHAR2 | (30) | Yes | List source type. |
| VIEW_APPLICATION_ID | NUMBER | Yes | Identifier of Oracle application owner. | |
| MANUALLY_ENTERED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate manual entry. |
| MARKED_AS_DUPLICATE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate marked as duplicate. |
| MARKED_AS_RANDOM_FLAG | VARCHAR2 | (1) | Yes | Chosen as a valid entry in random generation process. |
| PART_OF_CONTROL_GROUP_FLAG | VARCHAR2 | (1) | Yes | Flag to determine part of control group. |
| EXCLUDE_IN_TRIGGERED_LIST_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate exclusion of entry when generating a repeated list. |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to determine if list entry is enabled. |
| CELL_CODE | VARCHAR2 | (30) | Cell code. | |
| DEDUPE_KEY | VARCHAR2 | (500) | Key generated to join deduplication process. | |
| RANDOMLY_GENERATED_NUMBER | NUMBER | (15) | key generated during random process. | |
| CAMPAIGN_ID | NUMBER | Foreign key to campaign. | ||
| MEDIA_ID | NUMBER | Foreign key to media. | ||
| CHANNEL_ID | NUMBER | Foreign key to channel. | ||
| CHANNEL_SCHEDULE_ID | NUMBER | Foreign key to channel schedule. | ||
| EVENT_OFFER_ID | NUMBER | Foreign key to event offer. | ||
| CUSTOMER_ID | NUMBER | Foreign key to customer. | ||
| MARKET_SEGMENT_ID | NUMBER | Foreign key to market segment. | ||
| VENDOR_ID | NUMBER | Foreign key to vendor. | ||
| TRANSFER_FLAG | VARCHAR2 | (1) | For OSM upgrade only | |
| TRANSFER_STATUS | VARCHAR2 | (1) | For OSM upgrade only | |
| LIST_SOURCE | VARCHAR2 | (240) | For OSM upgrade only | |
| DUPLICATE_MASTER_ENTRY_ID | NUMBER | For OSM upgrade only | ||
| MARKED_FLAG | VARCHAR2 | (1) | For OSM upgrade only | |
| LEAD_ID | NUMBER | For OSM upgrade only | ||
| LETTER_ID | NUMBER | (15) | For OSM upgrade only | |
| PICKING_HEADER_ID | NUMBER | For OSM upgrade only | ||
| BATCH_ID | NUMBER | For OSM upgrade only | ||
| SUFFIX | VARCHAR2 | (30) | Suffix to a name. | |
| FIRST_NAME | VARCHAR2 | (150) | First name entry in a list. | |
| LAST_NAME | VARCHAR2 | (150) | Last name entry in a list. | |
| CUSTOMER_NAME | VARCHAR2 | (500) | Customer name entry in a list. | |
| TITLE | VARCHAR2 | (150) | title entry in a list. | |
| ADDRESS_LINE1 | VARCHAR2 | (500) | Address line1entry in a list. | |
| ADDRESS_LINE2 | VARCHAR2 | (500) | Address line2 entry in a list. | |
| CITY | VARCHAR2 | (100) | city entry in a list. | |
| STATE | VARCHAR2 | (100) | state entry in a list. | |
| ZIPCODE | VARCHAR2 | (100) | zipcode entry in a list. | |
| COUNTRY | VARCHAR2 | (100) | country entry in a list. | |
| FAX | VARCHAR2 | (150) | fax entry in a list. | |
| PHONE | VARCHAR2 | (150) | phone entry in a list. | |
| EMAIL_ADDRESS | VARCHAR2 | (500) | email entry in a list. | |
| COL1 | VARCHAR2 | (500) | User defined field. | |
| COL2 | VARCHAR2 | (500) | User defined field. | |
| COL3 | VARCHAR2 | (500) | User defined field. | |
| COL4 | VARCHAR2 | (500) | User defined field. | |
| COL5 | VARCHAR2 | (500) | User defined field. | |
| COL6 | VARCHAR2 | (500) | User defined field. | |
| COL7 | VARCHAR2 | (500) | User defined field. | |
| COL8 | VARCHAR2 | (500) | User defined field. | |
| COL9 | VARCHAR2 | (500) | User defined field. | |
| COL10 | VARCHAR2 | (500) | User defined field. | |
| COL11 | VARCHAR2 | (500) | User defined field. | |
| COL12 | VARCHAR2 | (500) | User defined field. | |
| COL13 | VARCHAR2 | (500) | User defined field. | |
| COL14 | VARCHAR2 | (500) | User defined field. | |
| COL15 | VARCHAR2 | (500) | User defined field. | |
| COL16 | VARCHAR2 | (500) | User defined field. | |
| COL17 | VARCHAR2 | (500) | User defined field. | |
| COL18 | VARCHAR2 | (500) | User defined field. | |
| COL19 | VARCHAR2 | (500) | User defined field. | |
| COL20 | VARCHAR2 | (500) | User defined field. | |
| COL21 | VARCHAR2 | (500) | User defined field. | |
| COL22 | VARCHAR2 | (500) | User defined field. | |
| COL23 | VARCHAR2 | (500) | User defined field. | |
| COL24 | VARCHAR2 | (500) | User defined field. | |
| COL25 | VARCHAR2 | (500) | User defined field. | |
| COL26 | VARCHAR2 | (500) | User defined field. | |
| COL27 | VARCHAR2 | (500) | User defined field. | |
| COL28 | VARCHAR2 | (500) | User defined field. | |
| COL29 | VARCHAR2 | (500) | User defined field. | |
| COL30 | VARCHAR2 | (500) | User defined field. | |
| COL31 | VARCHAR2 | (500) | User defined field. | |
| COL32 | VARCHAR2 | (500) | User defined field. | |
| COL33 | VARCHAR2 | (500) | User defined field. | |
| COL34 | VARCHAR2 | (500) | User defined field. | |
| COL35 | VARCHAR2 | (500) | User defined field. | |
| COL36 | VARCHAR2 | (500) | User defined field. | |
| COL37 | VARCHAR2 | (500) | User defined field. | |
| COL38 | VARCHAR2 | (500) | User defined field. | |
| COL39 | VARCHAR2 | (500) | User defined field. | |
| COL40 | VARCHAR2 | (500) | User defined field. | |
| COL41 | VARCHAR2 | (500) | User defined field. | |
| COL42 | VARCHAR2 | (500) | User defined field. | |
| COL43 | VARCHAR2 | (500) | User defined field. | |
| COL44 | VARCHAR2 | (500) | User defined field. | |
| COL45 | VARCHAR2 | (500) | User defined field. | |
| COL46 | VARCHAR2 | (500) | User defined field. | |
| COL47 | VARCHAR2 | (500) | User defined field. | |
| COL48 | VARCHAR2 | (500) | User defined field. | |
| COL49 | VARCHAR2 | (500) | User defined field. | |
| COL50 | VARCHAR2 | (500) | User defined field. | |
| COL51 | VARCHAR2 | (500) | User defined field. | |
| COL52 | VARCHAR2 | (500) | User defined field. | |
| COL53 | VARCHAR2 | (500) | User defined field. | |
| COL54 | VARCHAR2 | (500) | User defined field. | |
| COL55 | VARCHAR2 | (500) | User defined field. | |
| COL56 | VARCHAR2 | (500) | User defined field. | |
| COL57 | VARCHAR2 | (500) | User defined field. | |
| COL58 | VARCHAR2 | (500) | User defined field. | |
| COL59 | VARCHAR2 | (500) | User defined field. | |
| COL60 | VARCHAR2 | (500) | User defined field. | |
| COL61 | VARCHAR2 | (500) | User defined field. | |
| COL62 | VARCHAR2 | (500) | User defined field. | |
| COL63 | VARCHAR2 | (500) | User defined field. | |
| COL64 | VARCHAR2 | (500) | User defined field. | |
| COL65 | VARCHAR2 | (500) | User defined field. | |
| COL66 | VARCHAR2 | (500) | User defined field. | |
| COL67 | VARCHAR2 | (500) | User defined field. | |
| COL68 | VARCHAR2 | (500) | User defined field. | |
| COL69 | VARCHAR2 | (500) | User defined field. | |
| COL70 | VARCHAR2 | (500) | User defined field. | |
| COL71 | VARCHAR2 | (500) | User defined field. | |
| COL72 | VARCHAR2 | (500) | User defined field. | |
| COL73 | VARCHAR2 | (500) | User defined field. | |
| COL74 | VARCHAR2 | (500) | User defined field. | |
| COL75 | VARCHAR2 | (500) | User defined field. | |
| COL76 | VARCHAR2 | (500) | User defined field. | |
| COL77 | VARCHAR2 | (500) | User defined field. | |
| COL78 | VARCHAR2 | (500) | User defined field. | |
| COL79 | VARCHAR2 | (500) | User defined field. | |
| COL80 | VARCHAR2 | (500) | User defined field. | |
| COL81 | VARCHAR2 | (500) | User defined field. | |
| COL82 | VARCHAR2 | (500) | User defined field. | |
| COL83 | VARCHAR2 | (500) | User defined field. | |
| COL84 | VARCHAR2 | (500) | User defined field. | |
| COL85 | VARCHAR2 | (500) | User defined field. | |
| COL86 | VARCHAR2 | (500) | User defined field. | |
| COL87 | VARCHAR2 | (500) | User defined field. | |
| COL88 | VARCHAR2 | (500) | User defined field. | |
| COL89 | VARCHAR2 | (500) | User defined field. | |
| COL90 | VARCHAR2 | (500) | User defined field. | |
| COL91 | VARCHAR2 | (500) | User defined field. | |
| COL92 | VARCHAR2 | (500) | User defined field. | |
| COL93 | VARCHAR2 | (500) | User defined field. | |
| COL94 | VARCHAR2 | (500) | User defined field. | |
| COL95 | VARCHAR2 | (500) | User defined field. | |
| COL96 | VARCHAR2 | (500) | User defined field. | |
| COL97 | VARCHAR2 | (500) | User defined field. | |
| COL98 | VARCHAR2 | (500) | User defined field. | |
| COL99 | VARCHAR2 | (500) | User defined field. | |
| COL100 | VARCHAR2 | (500) | User defined field. | |
| COL101 | VARCHAR2 | (500) | User defined field. | |
| COL102 | VARCHAR2 | (500) | User defined field. | |
| COL103 | VARCHAR2 | (500) | User defined field. | |
| COL104 | VARCHAR2 | (500) | User defined field. | |
| COL105 | VARCHAR2 | (500) | User defined field. | |
| COL106 | VARCHAR2 | (500) | User defined field. | |
| COL107 | VARCHAR2 | (500) | User defined field. | |
| COL108 | VARCHAR2 | (500) | User defined field. | |
| COL109 | VARCHAR2 | (500) | User defined field. | |
| COL110 | VARCHAR2 | (500) | User defined field. | |
| COL111 | VARCHAR2 | (500) | User defined field. | |
| COL112 | VARCHAR2 | (500) | User defined field. | |
| COL113 | VARCHAR2 | (500) | User defined field. | |
| COL114 | VARCHAR2 | (500) | User defined field. | |
| COL115 | VARCHAR2 | (500) | User defined field. | |
| COL116 | VARCHAR2 | (500) | User defined field. | |
| COL117 | VARCHAR2 | (500) | User defined field. | |
| COL118 | VARCHAR2 | (500) | User defined field. | |
| COL119 | VARCHAR2 | (500) | User defined field. | |
| COL120 | VARCHAR2 | (500) | User defined field. | |
| COL121 | VARCHAR2 | (500) | User defined field. | |
| COL122 | VARCHAR2 | (500) | User defined field. | |
| COL123 | VARCHAR2 | (500) | User defined field. | |
| COL124 | VARCHAR2 | (500) | User defined field. | |
| COL125 | VARCHAR2 | (500) | User defined field. | |
| COL126 | VARCHAR2 | (500) | User defined field. | |
| COL127 | VARCHAR2 | (500) | User defined field. | |
| COL128 | VARCHAR2 | (500) | User defined field. | |
| COL129 | VARCHAR2 | (500) | User defined field. | |
| COL130 | VARCHAR2 | (500) | User defined field. | |
| COL131 | VARCHAR2 | (500) | User defined field. | |
| COL132 | VARCHAR2 | (500) | User defined field. | |
| COL133 | VARCHAR2 | (500) | User defined field. | |
| COL134 | VARCHAR2 | (500) | User defined field. | |
| COL135 | VARCHAR2 | (500) | User defined field. | |
| COL136 | VARCHAR2 | (500) | User defined field. | |
| COL137 | VARCHAR2 | (500) | User defined field. | |
| COL138 | VARCHAR2 | (500) | User defined field. | |
| COL139 | VARCHAR2 | (500) | User defined field. | |
| COL140 | VARCHAR2 | (500) | User defined field. | |
| COL141 | VARCHAR2 | (500) | User defined field. | |
| COL142 | VARCHAR2 | (500) | User defined field. | |
| COL143 | VARCHAR2 | (500) | User defined field. | |
| COL144 | VARCHAR2 | (500) | User defined field. | |
| COL145 | VARCHAR2 | (500) | User defined field. | |
| COL146 | VARCHAR2 | (500) | User defined field. | |
| COL147 | VARCHAR2 | (500) | User defined field. | |
| COL148 | VARCHAR2 | (500) | User defined field. | |
| COL149 | VARCHAR2 | (500) | User defined field. | |
| COL150 | VARCHAR2 | (500) | User defined field. | |
| COL151 | VARCHAR2 | (500) | User defined field. | |
| COL152 | VARCHAR2 | (500) | User defined field. | |
| COL153 | VARCHAR2 | (500) | User defined field. | |
| COL154 | VARCHAR2 | (500) | User defined field. | |
| COL155 | VARCHAR2 | (500) | User defined field. | |
| COL156 | VARCHAR2 | (500) | User defined field. | |
| COL157 | VARCHAR2 | (500) | User defined field. | |
| COL158 | VARCHAR2 | (500) | User defined field. | |
| COL159 | VARCHAR2 | (500) | User defined field. | |
| COL160 | VARCHAR2 | (500) | User defined field. | |
| COL161 | VARCHAR2 | (500) | User defined field. | |
| COL162 | VARCHAR2 | (500) | User defined field. | |
| COL163 | VARCHAR2 | (500) | User defined field. | |
| COL164 | VARCHAR2 | (500) | User defined field. | |
| COL165 | VARCHAR2 | (500) | User defined field. | |
| COL166 | VARCHAR2 | (500) | User defined field. | |
| COL167 | VARCHAR2 | (500) | User defined field. | |
| COL168 | VARCHAR2 | (500) | User defined field. | |
| COL169 | VARCHAR2 | (500) | User defined field. | |
| COL170 | VARCHAR2 | (500) | User defined field. | |
| COL171 | VARCHAR2 | (500) | User defined field. | |
| COL172 | VARCHAR2 | (500) | User defined field. | |
| COL173 | VARCHAR2 | (500) | User defined field. | |
| COL174 | VARCHAR2 | (500) | User defined field. | |
| COL175 | VARCHAR2 | (500) | User defined field. | |
| COL176 | VARCHAR2 | (500) | User defined field. | |
| COL177 | VARCHAR2 | (500) | User defined field. | |
| COL178 | VARCHAR2 | (500) | User defined field. | |
| COL179 | VARCHAR2 | (500) | User defined field. | |
| COL180 | VARCHAR2 | (500) | User defined field. | |
| COL181 | VARCHAR2 | (500) | User defined field. | |
| COL182 | VARCHAR2 | (500) | User defined field. | |
| COL183 | VARCHAR2 | (500) | User defined field. | |
| COL184 | VARCHAR2 | (500) | User defined field. | |
| COL185 | VARCHAR2 | (500) | User defined field. | |
| COL186 | VARCHAR2 | (500) | User defined field. | |
| COL187 | VARCHAR2 | (500) | User defined field. | |
| COL188 | VARCHAR2 | (500) | User defined field. | |
| COL189 | VARCHAR2 | (500) | User defined field. | |
| COL190 | VARCHAR2 | (500) | User defined field. | |
| COL191 | VARCHAR2 | (500) | User defined field. | |
| COL192 | VARCHAR2 | (500) | User defined field. | |
| COL193 | VARCHAR2 | (500) | User defined field. | |
| COL194 | VARCHAR2 | (500) | User defined field. | |
| COL195 | VARCHAR2 | (500) | User defined field. | |
| COL196 | VARCHAR2 | (500) | User defined field. | |
| COL197 | VARCHAR2 | (500) | User defined field. | |
| COL198 | VARCHAR2 | (500) | User defined field. | |
| COL199 | VARCHAR2 | (500) | User defined field. | |
| COL200 | VARCHAR2 | (500) | User defined field. | |
| COL201 | VARCHAR2 | (500) | User defined field. | |
| COL202 | VARCHAR2 | (500) | User defined field. | |
| COL203 | VARCHAR2 | (500) | User defined field. | |
| COL204 | VARCHAR2 | (500) | User defined field. | |
| COL205 | VARCHAR2 | (500) | User defined field. | |
| COL206 | VARCHAR2 | (500) | User defined field. | |
| COL207 | VARCHAR2 | (500) | User defined field. | |
| COL208 | VARCHAR2 | (500) | User defined field. | |
| COL209 | VARCHAR2 | (500) | User defined field. | |
| COL210 | VARCHAR2 | (500) | User defined field. | |
| COL211 | VARCHAR2 | (500) | User defined field. | |
| COL212 | VARCHAR2 | (500) | User defined field. | |
| COL213 | VARCHAR2 | (500) | User defined field. | |
| COL214 | VARCHAR2 | (500) | User defined field. | |
| COL215 | VARCHAR2 | (500) | User defined field. | |
| COL216 | VARCHAR2 | (500) | User defined field. | |
| COL217 | VARCHAR2 | (500) | User defined field. | |
| COL218 | VARCHAR2 | (500) | User defined field. | |
| COL219 | VARCHAR2 | (500) | User defined field. | |
| COL220 | VARCHAR2 | (500) | User defined field. | |
| COL221 | VARCHAR2 | (500) | User defined field. | |
| COL222 | VARCHAR2 | (500) | User defined field. | |
| COL223 | VARCHAR2 | (500) | User defined field. | |
| COL224 | VARCHAR2 | (500) | User defined field. | |
| COL225 | VARCHAR2 | (500) | User defined field. | |
| COL226 | VARCHAR2 | (500) | User defined field. | |
| COL227 | VARCHAR2 | (500) | User defined field. | |
| COL228 | VARCHAR2 | (500) | User defined field. | |
| COL229 | VARCHAR2 | (500) | User defined field. | |
| COL230 | VARCHAR2 | (500) | User defined field. | |
| COL231 | VARCHAR2 | (500) | User defined field. | |
| COL232 | VARCHAR2 | (500) | User defined field. | |
| COL233 | VARCHAR2 | (500) | User defined field. | |
| COL234 | VARCHAR2 | (500) | User defined field. | |
| COL235 | VARCHAR2 | (500) | User defined field. | |
| COL236 | VARCHAR2 | (500) | User defined field. | |
| COL237 | VARCHAR2 | (500) | User defined field. | |
| COL238 | VARCHAR2 | (500) | User defined field. | |
| COL239 | VARCHAR2 | (500) | User defined field. | |
| COL240 | VARCHAR2 | (500) | User defined field. | |
| COL241 | VARCHAR2 | (4000) | User defined field. | |
| COL242 | VARCHAR2 | (4000) | User defined field. | |
| COL243 | VARCHAR2 | (4000) | User defined field. | |
| COL244 | VARCHAR2 | (4000) | User defined field. | |
| COL245 | VARCHAR2 | (4000) | User defined field. | |
| COL246 | VARCHAR2 | (4000) | User defined field. | |
| COL247 | VARCHAR2 | (4000) | User defined field. | |
| COL248 | VARCHAR2 | (4000) | User defined field. | |
| COL249 | VARCHAR2 | (4000) | User defined field. | |
| COL250 | VARCHAR2 | (4000) | User defined field. | |
| PARTY_ID | NUMBER | Foreign Key to a Party. | ||
| PARENT_PARTY_ID | NUMBER | Obseleted | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| GEOMETRY | SDO_GEOMETRY | (1) | ||
| IMP_SOURCE_LINE_ID | NUMBER | Not Used | ||
| USAGE_RESTRICTION | VARCHAR2 | (1) | Not Used | |
| NEXT_CALL_TIME | DATE | Advanced outbound purposes | ||
| CALLBACK_FLAG | VARCHAR2 | (1) | Advanced outbound purposes | |
| DO_NOT_USE_FLAG | VARCHAR2 | (1) | Advanced outbound purposes | |
| DO_NOT_USE_REASON | VARCHAR2 | (30) | Advanced outbound purposes | |
| RECORD_OUT_FLAG | VARCHAR2 | (1) | Advanced outbound purposes | |
| RECORD_RELEASE_TIME | DATE | Advanced outbound purposes | ||
| CURR_CP_ID | NUMBER | Advanced outbound purposes | ||
| CURR_CP_TIME_ZONE | NUMBER | Advanced outbound purposes | ||
| CURR_CP_TIME_ZONE_AUX | NUMBER | Advanced outbound purposes | ||
| CURR_CP_COUNTRY_CODE | VARCHAR2 | (30) | Advanced outbound purposes | |
| CURR_CP_INDEX | NUMBER | Advanced outbound purposes | ||
| CURR_CP_AREA_CODE | NUMBER | Advanced outbound purposes | ||
| CURR_CP_PHONE_NUMBER | VARCHAR2 | (10) | Advanced outbound purposes | |
| CURR_CP_RAW_PHONE_NUMBER | VARCHAR2 | (60) | Advanced outbound purposes | |
| COL251 | VARCHAR2 | (500) | User defined field. | |
| COL252 | VARCHAR2 | (500) | User defined field. | |
| COL253 | VARCHAR2 | (500) | User defined field. | |
| COL254 | VARCHAR2 | (500) | User defined field. | |
| COL256 | VARCHAR2 | (500) | User defined field. | |
| COL255 | VARCHAR2 | (500) | User defined field. | |
| COL257 | VARCHAR2 | (500) | User defined field. | |
| COL258 | VARCHAR2 | (500) | User defined field. | |
| COL259 | VARCHAR2 | (500) | User defined field. | |
| COL260 | VARCHAR2 | (500) | User defined field. | |
| COL261 | VARCHAR2 | (500) | User defined field. | |
| COL262 | VARCHAR2 | (500) | User defined field. | |
| COL263 | VARCHAR2 | (500) | User defined field. | |
| COL264 | VARCHAR2 | (500) | User defined field. | |
| COL265 | VARCHAR2 | (500) | User defined field. | |
| COL266 | VARCHAR2 | (500) | User defined field. | |
| COL267 | VARCHAR2 | (500) | User defined field. | |
| COL268 | VARCHAR2 | (500) | User defined field. | |
| COL269 | VARCHAR2 | (500) | User defined field. | |
| COL270 | VARCHAR2 | (500) | User defined field. | |
| COL271 | VARCHAR2 | (500) | User defined field. | |
| COL272 | VARCHAR2 | (500) | User defined field. | |
| COL273 | VARCHAR2 | (500) | User defined field. | |
| COL274 | VARCHAR2 | (500) | User defined field. | |
| COL275 | VARCHAR2 | (500) | User defined field. | |
| COL276 | VARCHAR2 | (500) | User defined field. | |
| COL277 | VARCHAR2 | (500) | User defined field. | |
| COL278 | VARCHAR2 | (500) | User defined field. | |
| COL279 | VARCHAR2 | (500) | User defined field. | |
| COL280 | VARCHAR2 | (500) | User defined field. | |
| COL281 | VARCHAR2 | (500) | User defined field. | |
| COL282 | VARCHAR2 | (500) | User defined field. | |
| COL283 | VARCHAR2 | (500) | User defined field. | |
| COL284 | VARCHAR2 | (500) | User defined field. | |
| COL285 | VARCHAR2 | (500) | User defined field. | |
| COL286 | VARCHAR2 | (500) | User defined field. | |
| COL287 | VARCHAR2 | (500) | User defined field. | |
| COL288 | VARCHAR2 | (500) | User defined field. | |
| COL289 | VARCHAR2 | (500) | User defined field. | |
| COL290 | VARCHAR2 | (500) | User defined field. | |
| COL291 | VARCHAR2 | (500) | User defined field. | |
| COL292 | VARCHAR2 | (500) | User defined field. | |
| COL293 | VARCHAR2 | (500) | User defined field. | |
| COL294 | VARCHAR2 | (500) | User defined field. | |
| COL295 | VARCHAR2 | (500) | User defined field. | |
| COL296 | VARCHAR2 | (500) | User defined field. | |
| COL297 | VARCHAR2 | (500) | User defined field. | |
| COL298 | VARCHAR2 | (500) | User defined field. | |
| COL299 | VARCHAR2 | (500) | User defined field. | |
| COL300 | VARCHAR2 | (500) | User defined field. | |
| GROUP_CODE | VARCHAR2 | (10) | Group Code | |
| NEWLY_UPDATED_FLAG | VARCHAR2 | (1) | Newly Updated Flag | |
| OUTCOME_ID | NUMBER | Outcome of the call | ||
| RESULT_ID | NUMBER | Result of the call | ||
| REASON_ID | NUMBER | Reason for the result | ||
| NOTES | VARCHAR2 | (4000) | Notes | |
| VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | Source from which customer was first contacted | |
| SALES_AGENT_EMAIL_ADDRESS | VARCHAR2 | (2000) | Email address of sales agent | |
| RESOURCE_ID | NUMBER | Resource id of sales agent | ||
| LOCATION_ID | NUMBER | Location Identifier of the contact | ||
| CONTACT_POINT_ID | NUMBER | Contact Point Identifier of the contact | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Stores the ID from the source system. | |
| LAST_CONTACTED_DATE | DATE | Stores last contacted date. | ||
| CUSTOM_COLUMN1 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN2 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN3 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN4 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN5 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN6 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN7 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN8 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN9 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN10 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN11 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN12 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN13 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN14 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN15 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN16 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN17 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN18 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN19 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN20 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN21 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN22 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN23 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN24 | VARCHAR2 | (2000) | Custom columns | |
| CUSTOM_COLUMN25 | VARCHAR2 | (2000) | Custom columns | |
| MARKED_AS_FATIGUED_FLAG | VARCHAR2 | (1) | Marked as 'Y' by the traffic cop engine if the entry is fatigued. | |
| MARKED_AS_SUPPRESSED_FLAG | VARCHAR2 | (1) | If this entry is suppressed, the value of this flag is 'Y'. | |
| REMOTE_LIST_ENTRY_ID | NUMBER | Remote List entry id, used in case of lists based on remote data sources. | ||
| TCA_LOAD_STATUS | VARCHAR2 | (30) | TCA load status | |
| RANK | NUMBER | Rank | ||
| ERROR_FLAG | VARCHAR2 | (1) | Error Flag, used to indicate error in AMS_LIST_ENTRIES. | |
| ERROR_TEXT | VARCHAR2 | (4000) | Error text. |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_ENTRY_ID
, LIST_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, LIST_SELECT_ACTION_ID
, ARC_LIST_SELECT_ACTION_FROM
, LIST_SELECT_ACTION_FROM_NAME
, SOURCE_CODE
, ARC_LIST_USED_BY_SOURCE
, SOURCE_CODE_FOR_ID
, PIN_CODE
, LIST_ENTRY_SOURCE_SYSTEM_ID
, LIST_ENTRY_SOURCE_SYSTEM_TYPE
, VIEW_APPLICATION_ID
, MANUALLY_ENTERED_FLAG
, MARKED_AS_DUPLICATE_FLAG
, MARKED_AS_RANDOM_FLAG
, PART_OF_CONTROL_GROUP_FLAG
, EXCLUDE_IN_TRIGGERED_LIST_FLAG
, ENABLED_FLAG
, CELL_CODE
, DEDUPE_KEY
, RANDOMLY_GENERATED_NUMBER
, CAMPAIGN_ID
, MEDIA_ID
, CHANNEL_ID
, CHANNEL_SCHEDULE_ID
, EVENT_OFFER_ID
, CUSTOMER_ID
, MARKET_SEGMENT_ID
, VENDOR_ID
, TRANSFER_FLAG
, TRANSFER_STATUS
, LIST_SOURCE
, DUPLICATE_MASTER_ENTRY_ID
, MARKED_FLAG
, LEAD_ID
, LETTER_ID
, PICKING_HEADER_ID
, BATCH_ID
, SUFFIX
, FIRST_NAME
, LAST_NAME
, CUSTOMER_NAME
, TITLE
, ADDRESS_LINE1
, ADDRESS_LINE2
, CITY
, STATE
, ZIPCODE
, COUNTRY
, FAX
, PHONE
, EMAIL_ADDRESS
, 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
, PARTY_ID
, PARENT_PARTY_ID
, SECURITY_GROUP_ID
, GEOMETRY
, IMP_SOURCE_LINE_ID
, USAGE_RESTRICTION
, NEXT_CALL_TIME
, CALLBACK_FLAG
, DO_NOT_USE_FLAG
, DO_NOT_USE_REASON
, RECORD_OUT_FLAG
, RECORD_RELEASE_TIME
, CURR_CP_ID
, CURR_CP_TIME_ZONE
, CURR_CP_TIME_ZONE_AUX
, CURR_CP_COUNTRY_CODE
, CURR_CP_INDEX
, CURR_CP_AREA_CODE
, CURR_CP_PHONE_NUMBER
, CURR_CP_RAW_PHONE_NUMBER
, COL251
, COL252
, COL253
, COL254
, COL256
, COL255
, COL257
, COL258
, COL259
, COL260
, COL261
, COL262
, COL263
, COL264
, COL265
, COL266
, COL267
, COL268
, COL269
, COL270
, COL271
, COL272
, COL273
, COL274
, COL275
, COL276
, COL277
, COL278
, COL279
, COL280
, COL281
, COL282
, COL283
, COL284
, COL285
, COL286
, COL287
, COL288
, COL289
, COL290
, COL291
, COL292
, COL293
, COL294
, COL295
, COL296
, COL297
, COL298
, COL299
, COL300
, GROUP_CODE
, NEWLY_UPDATED_FLAG
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, NOTES
, VEHICLE_RESPONSE_CODE
, SALES_AGENT_EMAIL_ADDRESS
, RESOURCE_ID
, LOCATION_ID
, CONTACT_POINT_ID
, ORIG_SYSTEM_REFERENCE
, LAST_CONTACTED_DATE
, CUSTOM_COLUMN1
, CUSTOM_COLUMN2
, CUSTOM_COLUMN3
, CUSTOM_COLUMN4
, CUSTOM_COLUMN5
, CUSTOM_COLUMN6
, CUSTOM_COLUMN7
, CUSTOM_COLUMN8
, CUSTOM_COLUMN9
, CUSTOM_COLUMN10
, CUSTOM_COLUMN11
, CUSTOM_COLUMN12
, CUSTOM_COLUMN13
, CUSTOM_COLUMN14
, CUSTOM_COLUMN15
, CUSTOM_COLUMN16
, CUSTOM_COLUMN17
, CUSTOM_COLUMN18
, CUSTOM_COLUMN19
, CUSTOM_COLUMN20
, CUSTOM_COLUMN21
, CUSTOM_COLUMN22
, CUSTOM_COLUMN23
, CUSTOM_COLUMN24
, CUSTOM_COLUMN25
, MARKED_AS_FATIGUED_FLAG
, MARKED_AS_SUPPRESSED_FLAG
, REMOTE_LIST_ENTRY_ID
, TCA_LOAD_STATUS
, RANK
, ERROR_FLAG
, ERROR_TEXT
FROM AMS.AMS_LIST_ENTRIES;
MDSYS
SDO_GEOMETRY
SYS
STANDARD
- show dependent code
APPS
AMS_LIST_ENTRIES
|
|
|
|