View: AMS_TAR_CONTACT_V

Product:	AMS - Marketing
Description:	This View shows the information stored for an "AMS_CONTACT" List source type.
Implementation/DBA Data:	APPS.AMS_TAR_CONTACT_V

View Text

SELECT COL2 ACADEMIC_TITLE
, COL16 DECISION_MAKER
, COL15 DEPARTMENT
, FIRST_NAME FIRST_NAME
, COL3 KNOWN_AS
, LAST_NAME LAST_NAME
, COL17 MAIL_STOP
, COL1 MIDDLE_NAME
, PARTY_ID PARTY_ID
, SUFFIX SUFFIX
, TITLE TITLE
, ADDRESS_LINE1 BILL_TO_ADDRESS1
, ADDRESS_LINE2 BILL_TO_ADDRESS2
, COL4 BILL_TO_ADDRESS3
, COL5 BILL_TO_ADDRESS4
, CITY BILL_TO_CITY
, COUNTRY BILL_TO_COUNTRY
, ZIPCODE BILL_TO_POSTAL_CODE
, COL6 BILL_TO_STATE
, COL16 CUSTOMER_KEY
, COL18 DUNS_NUMBER
, EMAIL_ADDRESS EMAIL_ADDRESS
, COL20 JGZZ_FISCAL_CODE
, CUSTOMER_NAME ORGANIZATION_NAME
, PHONE PHONE_NUMBER
, COL7 SHIP_TO_ADDRESS1
, COL8 SHIP_TO_ADDRESS2
, COL9 SHIP_TO_ADDRESS3
, COL10 SHIP_TO_ADDRESS4
, COL11 SHIP_TO_CITY
, COL14 SHIP_TO_COUNTRY
, COL13 SHIP_TO_POSTAL_CODE
, COL12 SHIP_TO_STATE
, COL15 SIC_CODE
, COL19 TAX_NAME
, COL17 TAX_REFERENCE
, LIST_ENTRY_ID
, LIST_HEADER_ID
, 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
, ENABLED_FLAG
, CELL_CODE
, CAMPAIGN_ID
, MEDIA_ID
, CHANNEL_ID
, CHANNEL_SCHEDULE_ID
, EVENT_OFFER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM AMS_LIST_ENTRIES
WHERE LIST_ENTRY_SOURCE_SYSTEM_TYPE ='AMS_CONTACT'

Columns