View: AMS_TAR_ORGANIZATION_V

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

View Text

SELECT COL2 CUSTOMER_KEY
, COL5 DUNS_NUMBER
, COL4 JGZZ_FISCAL_CODE
, CUSTOMER_NAME ORGANIZATION_NAME
, PARTY_ID PARTY_ID
, COL1 SIC_CODE
, COL6 TAX_NAME
, COL3 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_ORGANIZATION'

Columns