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_PERSON_PROFILES_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AMS_PERSON_PROFILE_ID	NUMBER	(15)	Yes	Person Profile Id
PARTY_ID	NUMBER	(15)	Yes	Party Identifier. FK to HZ_PARTIES.
PERSON_NAME	VARCHAR2	(450)		Person Name. The combination of title, first, middle, last, and suffix names, in English format.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Segment column
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for Globalization Functionality
DATE_OF_BIRTH	DATE			Date the person was born
PLACE_OF_BIRTH	VARCHAR2	(60)		Where the person was born. Typically, the city and country.
DATE_OF_DEATH	DATE			Date the person was deceased
GENDER	VARCHAR2	(30)		The gender (male, female, unknown) of the person
DECLARED_ETHNICITY	VARCHAR2	(60)		The declared ethnicity of the person
MARITAL_STATUS	VARCHAR2	(30)		Marital status of the person
MARITAL_STATUS_EFFECTIVE_DATE	DATE			Date when person achieved the marital status
PERSONAL_INCOME	NUMBER			An estimated gross annual income of the person in US dollars
HEAD_OF_HOUSEHOLD_FLAG	VARCHAR2	(1)		Y if this person is the head of a household
HOUSEHOLD_INCOME	NUMBER			Income of the household that this person is a part of
HOUSEHOLD_SIZE	NUMBER			The size of the household this person is a part of
RENT_OWN_IND	VARCHAR2	(30)		Indicates whether the person rents or owns his or her residence.. Lookup of values for rent, own, lease, etc.
BEST_TIME_CONTACT_BEGIN	DATE			Beginning of the best period of time to contact the person
BEST_TIME_CONTACT_END	DATE			End of the best period of time to contact the person
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of data content
INTERNAL_FLAG	VARCHAR2	(1)		Indicates whether the person is internal or external. Y for Internal, N for External.
AGE	NUMBER

Query Text

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


SELECT AMS_PERSON_PROFILE_ID
,      PARTY_ID
,      PERSON_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      DATE_OF_DEATH
,      GENDER
,      DECLARED_ETHNICITY
,      MARITAL_STATUS
,      MARITAL_STATUS_EFFECTIVE_DATE
,      PERSONAL_INCOME
,      HEAD_OF_HOUSEHOLD_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      RENT_OWN_IND
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      CONTENT_SOURCE_TYPE
,      INTERNAL_FLAG
,      AGE
FROM APPS.AMS_PERSON_PROFILES_V;

Dependencies

[top of page]

APPS.AMS_PERSON_PROFILES_V references the following:

APPS: HZ_PERSON_PROFILES

APPS.AMS_PERSON_PROFILES_V is not referenced by any database object