VIEW: APPS.AMS_TAR_CONTACT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'