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

Object Details

Object Name:	UMX_PERSON_PVT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.UMX_PERSON_PVT_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
PARTY_ID	NUMBER	(15)	Yes	See documentation for HZ_PARTIES
PARTY_NAME	VARCHAR2	(360)	Yes	See documentation for HZ_PARTIES
PARTY_NUMBER	VARCHAR2	(30)	Yes	See documentation for HZ_PARTIES
LAST_UPDATE_DATE	DATE		Yes	See documentation for HZ_PARTIES
LAST_UPDATED_BY	NUMBER	(15)	Yes	See documentation for HZ_PARTIES
CREATION_DATE	DATE		Yes	See documentation for HZ_PARTIES
CREATED_BY	NUMBER	(15)	Yes	See documentation for HZ_PARTIES
LAST_UPDATE_LOGIN	NUMBER	(15)		See documentation for HZ_PARTIES
WH_UPDATE_DATE	DATE			See documentation for HZ_PARTIES
REQUEST_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_APPLICATION_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_UPDATE_DATE	DATE			See documentation for HZ_PARTIES
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		See documentation for HZ_PARTIES
PERSON_FIRST_NAME	VARCHAR2	(150)		See documentation for HZ_PARTIES
PERSON_MIDDLE_NAME	VARCHAR2	(60)		See documentation for HZ_PARTIES
PERSON_LAST_NAME	VARCHAR2	(150)		See documentation for HZ_PARTIES
PERSON_NAME_SUFFIX	VARCHAR2	(30)		See documentation for HZ_PARTIES
PERSON_TITLE	VARCHAR2	(60)		See documentation for HZ_PARTIES
PERSON_ACADEMIC_TITLE	VARCHAR2	(30)		See documentation for HZ_PARTIES
PERSON_PREVIOUS_LAST_NAME	VARCHAR2	(150)		See documentation for HZ_PARTIES
KNOWN_AS	VARCHAR2	(240)		See documentation for HZ_PARTIES
TAX_NAME	VARCHAR2	(60)		See documentation for HZ_PARTIES
PERSON_FIRST_NAME_PHONETIC	VARCHAR2	(60)		See documentation for HZ_PARTIES
PERSON_LAST_NAME_PHONETIC	VARCHAR2	(60)		See documentation for HZ_PARTIES
TAX_REFERENCE	VARCHAR2	(50)		See documentation for HZ_PARTIES
JGZZ_FISCAL_CODE	VARCHAR2	(20)		See documentation for HZ_PARTIES
PERSON_IDEN_TYPE	VARCHAR2	(30)		See documentation for HZ_PARTIES
PERSON_IDENTIFIER	VARCHAR2	(60)		See documentation for HZ_PARTIES
KNOWN_AS2	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS3	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS4	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS5	VARCHAR2	(240)		See documentation for HZ_PARTIES
STATUS	VARCHAR2	(1)	Yes	See documentation for HZ_PARTIES
OBJECT_VERSION_NUMBER	NUMBER			See documentation for HZ_PARTIES
CREATED_BY_MODULE	VARCHAR2	(150)		See documentation for HZ_PARTIES
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	See documentation for HZ_PARTIES
APPLICATION_ID	NUMBER			See documentation for HZ_PARTIES
COUNTRY	VARCHAR2	(60)		See documentation for HZ_PARTIES
ADDRESS1	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS2	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS3	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS4	VARCHAR2	(240)		See documentation for HZ_PARTIES
CITY	VARCHAR2	(60)		See documentation for HZ_PARTIES
POSTAL_CODE	VARCHAR2	(60)		See documentation for HZ_PARTIES
STATE	VARCHAR2	(60)		See documentation for HZ_PARTIES
PROVINCE	VARCHAR2	(60)		See documentation for HZ_PARTIES
COUNTY	VARCHAR2	(60)		See documentation for HZ_PARTIES
EMAIL_ADDRESS	VARCHAR2	(2000)		See documentation for HZ_PARTIES

Query Text

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


SELECT PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WH_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      KNOWN_AS
,      TAX_NAME
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_LAST_NAME_PHONETIC
,      TAX_REFERENCE
,      JGZZ_FISCAL_CODE
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      ORIG_SYSTEM_REFERENCE
,      APPLICATION_ID
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      EMAIL_ADDRESS
FROM APPS.UMX_PERSON_PVT_V;

Dependencies

[top of page]

APPS.UMX_PERSON_PVT_V references the following:

APPS: HZ_PARTIES

APPS.UMX_PERSON_PVT_V is not referenced by any database object