[Home] [Help] [Dependency Information]
Object Name: | IES_AMS_LIST_ENTRIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IES.IES_AMS_LIST_ENTRIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View on AMS_LIST_ENTRIES table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_ENTRY_ID | NUMBER | Yes | Unique Indentifier for Name in the List | |
FIRST_NAME | VARCHAR2 | (150) | First Name of Survey Take | |
LAST_NAME | VARCHAR2 | (150) | Last Name of Survey Taker | |
EMAIL_ADDRESS | VARCHAR2 | (500) | Email address of Survey Taker | |
LIST_HEADER_ID | NUMBER | Yes | List Header ID | |
SOURCE_CODE | VARCHAR2 | (30) | Yes | Source Code |
CAMPAIGN_ID | NUMBER | Campaign ID | ||
MEDIA_ID | NUMBER | Media ID | ||
CHANNEL_ID | NUMBER | Channel ID | ||
CHANNEL_SCHEDULE_ID | NUMBER | Channel Schedule ID | ||
EVENT_OFFER_ID | NUMBER | Event Offered ID | ||
CUSTOMER_ID | NUMBER | Customer ID | ||
MARKET_SEGMENT_ID | NUMBER | Market Segment ID | ||
VENDOR_ID | NUMBER | Vendor D | ||
LIST_SOURCE | VARCHAR2 | (240) | List Source | |
LEAD_ID | NUMBER | Lead ID | ||
CUSTOMER_NAME | VARCHAR2 | (500) | Customer ID | |
TITLE | VARCHAR2 | (150) | Title | |
ADDRESS_LINE1 | VARCHAR2 | (500) | Address Line1 | |
ADDRESS_LINE2 | VARCHAR2 | (500) | Address Line2 | |
CITY | VARCHAR2 | (100) | City | |
STATE | VARCHAR2 | (100) | State | |
ZIPCODE | VARCHAR2 | (100) | ZipCode | |
COUNTRY | VARCHAR2 | (100) | Country | |
FAX | VARCHAR2 | (150) | Fax no. | |
PHONE | VARCHAR2 | (150) | Phone no. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object version number required for HTML interfaces | |
F_DELETEDFLAG | VARCHAR2 | (0) | Used by AOM for soft Delete |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_ENTRY_ID
, FIRST_NAME
, LAST_NAME
, EMAIL_ADDRESS
, LIST_HEADER_ID
, SOURCE_CODE
, CAMPAIGN_ID
, MEDIA_ID
, CHANNEL_ID
, CHANNEL_SCHEDULE_ID
, EVENT_OFFER_ID
, CUSTOMER_ID
, MARKET_SEGMENT_ID
, VENDOR_ID
, LIST_SOURCE
, LEAD_ID
, CUSTOMER_NAME
, TITLE
, ADDRESS_LINE1
, ADDRESS_LINE2
, CITY
, STATE
, ZIPCODE
, COUNTRY
, FAX
, PHONE
, OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
FROM APPS.IES_AMS_LIST_ENTRIES_V;
|
|
|