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

Object Details

Object Name:	OKS_ENT_PARTY_CONT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_ENT_PARTY_CONT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Lists all Party Contacts

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_ID	NUMBER		Yes	FK to Contract Header.
CONTACT_ID	NUMBER		Yes	Contact Identifier
CONTACT_ROLE_ID	NUMBER		Yes	Contact Role Identifier
PARTY_CONTACT_ID	NUMBER			Partty Identifier.
CONTACT_ROLE_CODE	VARCHAR2	(30)	Yes	Contact Role Code
CONTACT_ROLE_NAME	VARCHAR2	(80)	Yes	Contact Role Name

Query Text

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


SELECT CONTRACT_ID
,      CONTACT_ID
,      CONTACT_ROLE_ID
,      PARTY_CONTACT_ID
,      CONTACT_ROLE_CODE
,      CONTACT_ROLE_NAME
FROM APPS.OKS_ENT_PARTY_CONT_V;

Dependencies

[top of page]

APPS.OKS_ENT_PARTY_CONT_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_CONTACTS; OKC_K_HEADERS_ALL_B; OKC_K_PARTY_ROLES_B

APPS.OKS_ENT_PARTY_CONT_V is not referenced by any database object