[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_TAR_PERSON_V

Object Details

Object Name:	AMS_TAR_PERSON_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_TAR_PERSON_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT CUSTOMER_KEY
,      DUNS_NUMBER
,      HQ_BRANCH_IND
,      JGZZ_FISCAL_CODE
,      KNOWN_AS
,      PARTY_ID
,      PERSON_ACADEMIC_TITLE
,      PERSON_FIRST_NAME
,      PERSON_IDENTIFIER
,      PERSON_IDEN_TYPE
,      PERSON_LAST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_NUMBER
,      PERSON_PREVIOUS_LAST_NAME
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_TITLE
,      SIC_CODE
,      SIC_CODE_TYPE
,      TAX_NAME
,      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 APPS.AMS_TAR_PERSON_V;

Dependencies

[top of page]

APPS

AMS_LIST_ENTRIES

APPS.AMS_TAR_PERSON_V is not referenced by any database object