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_INTERNAL_PEOPLE_V

Object Details

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

View Type

A Business Intelligence System view

View EGO_INTERNAL_PEOPLE_V provides all the information related to internal people. Each row of this view provides the person full name, email address, title, phone, fax, and user id for a givem person. The unique identifier for each row is PERSON_ID.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	hz_party.party_id
USER_NAME	VARCHAR2	(100)	Yes	fnd_user.user_name
PERSON_NAME	VARCHAR2	(360)	Yes	hz_party.party_name
EMAIL_ADDRESS	VARCHAR2	(240)		hr 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	(80)		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	(60)		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	(60)		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
KNOWN_AS	VARCHAR2	(80)		Preferred Name from HR table

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
,      KNOWN_AS
FROM APPS.EGO_INTERNAL_PEOPLE_V;

Dependencies

[top of page]

APPS.EGO_INTERNAL_PEOPLE_V references the following:

APPS: AR_LOOKUPS; FND_USER; HZ_CONTACT_POINTS; HZ_PARTIES; HZ_RELATIONSHIPS; PER_ALL_PEOPLE_F; PER_PHONES

APPS.EGO_INTERNAL_PEOPLE_V is referenced by following:

APPS: BOM_EXPLODER_PUB - show dependent code