[Home] [Help] [Dependency Information]
Object Name: | AMS_P_LIST_ENTRIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_LIST_ENTRIES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_ENTRY_ID | NUMBER | Yes | Unique Identifier | |
LIST_HEADER_ID | NUMBER | Yes | Foreign key to 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 | |
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. |
PIN_CODE | VARCHAR2 | (30) | Yes | Used to uniquely identify list entry. |
LIST_ENTRY_SOURCE_SYSTEM_ID | NUMBER | Yes | Foreign key to ams_list_src_type | |
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 a random generated process. |
PART_OF_CONTROL_GROUP_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate part of control group. |
EXCLUDE_IN_TRIGGERED_LIST_FLAG | VARCHAR2 | (1) | Yes | Exclude an entry when generating 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. | ||
PARTY_ID | NUMBER | |||
PARENT_PARTY_ID | NUMBER | |||
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 | ||
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 |
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
, 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
, PARTY_ID
, PARENT_PARTY_ID
, VENDOR_ID
, TRANSFER_FLAG
, TRANSFER_STATUS
, LIST_SOURCE
, DUPLICATE_MASTER_ENTRY_ID
, MARKED_FLAG
, LEAD_ID
, LETTER_ID
, PICKING_HEADER_ID
, BATCH_ID
, 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
FROM APPS.AMS_P_LIST_ENTRIES_V;
APPS.AMS_P_LIST_ENTRIES_V is not referenced by any database object
|
|
|