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

Object Details

Object Name:	OKL_AM_PARTY_CONTACTS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_PARTY_CONTACTS_UV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	The identifier of the object in this relationship
PERSON_PARTY_ID	NUMBER	(15)	Yes	Party identifier
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
PERSON_FIRST_NAME	VARCHAR2	(150)		First name of the person
PERSON_LAST_NAME	VARCHAR2	(150)		Last or surname of the person
DEPARTMENT	VARCHAR2	(60)		Free form text used to name the department
JOB_TITLE	VARCHAR2	(100)		Free form text for job title
RANK	VARCHAR2	(30)		Importance of the contact relative to other contacts
CONTACT_POINT_TYPE	VARCHAR2	(30)		Lookup: CONTACT_POINT_TYPE of phone, fax, e-mail, web, telex, or EDI.
RAW_PHONE_NUMBER	VARCHAR2	(60)		Unformatted telephone number
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address of the contact point
TELEX_NUMBER	VARCHAR2	(50)		Reference number (usually a telephone number) that TELEX messages are sent to.
DATE_NOTIFIED	DATE			Date and time of last contact placed to this contact point.
PRIMARY_FLAG	VARCHAR2	(1)		Indicates if this is the primary contact point of this contact point type for referenced party, site, or location. Y for primary contact, N for all others.
DETAILS	VARCHAR2	(30)		Lookup: CONTACT_POINT_TYPE of phone, fax, e-mail, web, telex, or EDI.

Query Text

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


SELECT PARTY_ID
,      PERSON_PARTY_ID
,      PARTY_NAME
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
,      DEPARTMENT
,      JOB_TITLE
,      RANK
,      CONTACT_POINT_TYPE
,      RAW_PHONE_NUMBER
,      EMAIL_ADDRESS
,      TELEX_NUMBER
,      DATE_NOTIFIED
,      PRIMARY_FLAG
,      DETAILS
FROM APPS.OKL_AM_PARTY_CONTACTS_UV;

Dependencies

[top of page]

APPS.OKL_AM_PARTY_CONTACTS_UV references the following:

APPS: HZ_CONTACT_POINTS; HZ_ORG_CONTACTS; HZ_ORG_CONTACT_ROLES; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.OKL_AM_PARTY_CONTACTS_UV is not referenced by any database object