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_PEOPLE_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Id from HZ_PARTIES
PERSON_NAME	VARCHAR2	(360)	Yes	Person Name
USER_NAME	VARCHAR2	(100)	Yes	User Name
USER_ID	NUMBER	(15)	Yes	User Id from fnd_user
EMAIL_ADDRESS	VARCHAR2	(2000)		Email Address
PERSON_TYPE	VARCHAR2	(8)		Person Type
COMPANY_ID	NUMBER	(15)		Company Id
COMPANY_NAME	VARCHAR2	(360)		Name of the company
PERSON_TITLE	VARCHAR2	(80)		Title of the person
PERSON_PREFIX	VARCHAR2	(30)		Person Prefix
PERSON_FIRST_NAME	VARCHAR2	(150)		First name of the person
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
PERSON_LAST_NAME	VARCHAR2	(150)		Last name of the person
PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person name suffix
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Phone country Code
PHONE_AREA_CODE	VARCHAR2	(10)		Area code
PHONE_NUMBER	VARCHAR2	(60)		Phone number
PHONE_EXTENSION	VARCHAR2	(20)		Phone extension
FAX_COUNTRY_CODE	VARCHAR2	(10)		Fax country code
FAX_AREA_CODE	VARCHAR2	(10)		Fax Area Code
FAX_NUMBER	VARCHAR2	(60)		Fax Number
FAX_EXTENSION	VARCHAR2	(20)		Fax Extension
KNOWN_AS	VARCHAR2	(80)		Nick name of the person

Query Text

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


SELECT PERSON_ID
,      PERSON_NAME
,      USER_NAME
,      USER_ID
,      EMAIL_ADDRESS
,      PERSON_TYPE
,      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
,      KNOWN_AS
FROM APPS.EGO_PEOPLE_V;

Dependencies

[top of page]

APPS.EGO_PEOPLE_V references the following:

APPS: AK_WEB_USER_SEC_ATTR_VALUES; AR_LOOKUPS; FND_USER; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_RELATIONSHIPS; PER_ALL_PEOPLE_F; PER_PHONES; PO_VENDORS
PUBLIC: DUAL

APPS.EGO_PEOPLE_V is referenced by following:

APPS: BOM_IMPORT_PUB - show dependent code; EGO_CHANGE_PEOPLE_IMPORT_PKG - show dependent code; EGO_CHANGE_USER_ATTRS_PUB - show dependent code; EGO_ITEM_COMPARE_PKG - show dependent code; EGO_ITEM_PEOPLE_IMPORT_PKG - show dependent code; EGO_ITEM_USER_ATTRS_CP_PUB - show dependent code; EGO_PARTY_PUB - show dependent code; ENG_DEFAULT_ECO - show dependent code; ENG_NIR_UTIL_PKG - show dependent code; ENG_VAL_TO_ID - show dependent code; ENG_WORKFLOW_UTIL - show dependent code; INV_EGO_REVISION_VALIDATE - show dependent code; POS_BULKLOAD_ENTITIES - show dependent code; RRS_BULKLOAD_ENTITIES - show dependent code; RRS_SITE_UDA_BULKLOAD_INTF - show dependent code; WF_PUB_ICC - show dependent code