eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length	Mandatory
CUSTOMER_KEY	VARCHAR2	(500)
DUNS_NUMBER	VARCHAR2	(500)
HQ_BRANCH_IND	VARCHAR2	(500)
JGZZ_FISCAL_CODE	VARCHAR2	(500)
KNOWN_AS	VARCHAR2	(500)
PARTY_ID	NUMBER
PERSON_ACADEMIC_TITLE	VARCHAR2	(500)
PERSON_FIRST_NAME	VARCHAR2	(150)
PERSON_IDENTIFIER	VARCHAR2	(500)
PERSON_IDEN_TYPE	VARCHAR2	(500)
PERSON_LAST_NAME	VARCHAR2	(150)
PERSON_MIDDLE_NAME	VARCHAR2	(500)
PERSON_NAME	VARCHAR2	(500)
PERSON_NAME_SUFFIX	VARCHAR2	(30)
PERSON_NUMBER	VARCHAR2	(500)
PERSON_PREVIOUS_LAST_NAME	VARCHAR2	(500)
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(500)
PERSON_TITLE	VARCHAR2	(150)
SIC_CODE	VARCHAR2	(500)
SIC_CODE_TYPE	VARCHAR2	(500)
TAX_NAME	VARCHAR2	(500)
TAX_REFERENCE	VARCHAR2	(500)
LIST_ENTRY_ID	NUMBER		Yes
LIST_HEADER_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)
LIST_SELECT_ACTION_ID	NUMBER		Yes
ARC_LIST_SELECT_ACTION_FROM	VARCHAR2	(30)	Yes
LIST_SELECT_ACTION_FROM_NAME	VARCHAR2	(254)
SOURCE_CODE	VARCHAR2	(30)	Yes
ARC_LIST_USED_BY_SOURCE	VARCHAR2	(30)	Yes
PIN_CODE	VARCHAR2	(30)	Yes
LIST_ENTRY_SOURCE_SYSTEM_ID	NUMBER		Yes
LIST_ENTRY_SOURCE_SYSTEM_TYPE	VARCHAR2	(30)	Yes
VIEW_APPLICATION_ID	NUMBER		Yes
MANUALLY_ENTERED_FLAG	VARCHAR2	(1)	Yes
MARKED_AS_DUPLICATE_FLAG	VARCHAR2	(1)	Yes
MARKED_AS_RANDOM_FLAG	VARCHAR2	(1)	Yes
PART_OF_CONTROL_GROUP_FLAG	VARCHAR2	(1)	Yes
ENABLED_FLAG	VARCHAR2	(1)	Yes
CELL_CODE	VARCHAR2	(30)
CAMPAIGN_ID	NUMBER
MEDIA_ID	NUMBER
CHANNEL_ID	NUMBER
CHANNEL_SCHEDULE_ID	NUMBER
EVENT_OFFER_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes

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_TAR_PERSON_V references the following:

APPS: AMS_LIST_ENTRIES

APPS.AMS_TAR_PERSON_V is not referenced by any database object