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


VIEW: APPS.AMS_P_LIST_ENTRIES_V

Object Details
Object Name: AMS_P_LIST_ENTRIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_P_LIST_ENTRIES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query 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
,      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;

Dependencies

[top of page]

APPS.AMS_P_LIST_ENTRIES_V references the following:

SchemaAPPS
SynonymAMS_LIST_ENTRIES

APPS.AMS_P_LIST_ENTRIES_V is not referenced by any database object