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

VIEW: APPS.IES_AMS_LIST_ENTRIES_V

Object Details
Object Name: IES_AMS_LIST_ENTRIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIES.IES_AMS_LIST_ENTRIES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View on AMS_LIST_ENTRIES table


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IES_AMS_LIST_ENTRIES_V references the following:

SchemaAPPS
SynonymAMS_LIST_ENTRIES
APPS.IES_AMS_LIST_ENTRIES_V is referenced by following:

SchemaAPPS
Package BodyIES_SURVEY_SUMMARY - show dependent code