View: AMS_TAR_PERSON_V

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

View Text

SELECT COL4 CUSTOMER_KEY
, COL7 DUNS_NUMBER
, COL3 HQ_BRANCH_IND
, COL6 JGZZ_FISCAL_CODE
, COL24 KNOWN_AS
, PARTY_ID PARTY_ID
, COL11 PERSON_ACADEMIC_TITLE
, FIRST_NAME PERSON_FIRST_NAME
, COL14 PERSON_IDENTIFIER
, COL13 PERSON_IDEN_TYPE
, LAST_NAME PERSON_LAST_NAME
, COL10 PERSON_MIDDLE_NAME
, CUSTOMER_NAME PERSON_NAME
, SUFFIX PERSON_NAME_SUFFIX
, COL1 PERSON_NUMBER
, COL12 PERSON_PREVIOUS_LAST_NAME
, COL9 PERSON_PRE_NAME_ADJUNCT
, TITLE PERSON_TITLE
, COL2 SIC_CODE
, COL15 SIC_CODE_TYPE
, COL8 TAX_NAME
, COL5 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_PERSON'

Columns