VIEW: APPS.AMS_TAR_PERSON_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'