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.EGO_CUSTOMER_PEOPLE_V

Object Details

Object Name:	EGO_CUSTOMER_PEOPLE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_CUSTOMER_PEOPLE_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_CUSTOMER_PEOPLE_V provides all information for Customer People. The information stored in each row for each person includes name, title, email, company, and telephone among others.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)		hz_party.party_id
USER_NAME	VARCHAR2	(100)	Yes	fnd_user.user_name
PERSON_NAME	VARCHAR2	(360)		hz_party.party_name
EMAIL_ADDRESS	VARCHAR2	(240)		hz contact points email address
COMPANY_ID	NUMBER	(15)		hz_party.party_id for company
COMPANY_NAME	VARCHAR2	(360)		hz_party.party_name for company
PERSON_TITLE	VARCHAR2	(60)		Person_title
PERSON_PREFIX	VARCHAR2	(30)		Person prefix
PERSON_FIRST_NAME	VARCHAR2	(150)		Person first name
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person middle name
PERSON_LAST_NAME	VARCHAR2	(150)		Person last name
PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person suffix
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Country code from hz_contact_points
PHONE_AREA_CODE	VARCHAR2	(10)		area code from hz_contact_points
PHONE_NUMBER	VARCHAR2	(40)		Phone number from hz_contact_points
PHONE_EXTENSION	VARCHAR2	(20)		Phone extension from hz_contact_points
FAX_COUNTRY_CODE	VARCHAR2	(10)		fax country code from hz_contact_points
FAX_AREA_CODE	VARCHAR2	(10)		fax area code from hz_contact_points
FAX_NUMBER	VARCHAR2	(40)		fax number from hz_contact_points
FAX_EXTENSION	VARCHAR2	(20)		fax extension from hz_contact_points
USER_ID	NUMBER	(15)	Yes	fnd_user.user_id

Query Text

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


SELECT PERSON_ID
,      USER_NAME
,      PERSON_NAME
,      EMAIL_ADDRESS
,      COMPANY_ID
,      COMPANY_NAME
,      PERSON_TITLE
,      PERSON_PREFIX
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      FAX_COUNTRY_CODE
,      FAX_AREA_CODE
,      FAX_NUMBER
,      FAX_EXTENSION
,      USER_ID
FROM APPS.EGO_CUSTOMER_PEOPLE_V;

Dependencies

[top of page]

APPS.EGO_CUSTOMER_PEOPLE_V references the following:

APPS: FND_USER; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.EGO_CUSTOMER_PEOPLE_V is not referenced by any database object