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

Object Details

Object Name:	OKI_HQTCONT_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view shows the contact points defined for contacts for specific contracts Contacts points might be email id, phone number, fax number, etc.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHR_ID	NUMBER		Yes	Internal idenitifer for the original contract
CONTACT	VARCHAR2	(120)		Contact details to whom quote would be sent
EMAIL	VARCHAR2	(2000)		Contact EMail-ID
PHONE	VARCHAR2	(40)		Contact Phone
FAX	VARCHAR2	(40)		Contact Fax
ADDRESS	VARCHAR2	(80)		Contact Address

Query Text

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


SELECT CHR_ID
,      CONTACT
,      EMAIL
,      PHONE
,      FAX
,      ADDRESS
FROM APPS.OKI_HQTCONT_DTL_V;

Dependencies

[top of page]

APPS.OKI_HQTCONT_DTL_V references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; OKS_K_HEADERS_B

APPS.OKI_HQTCONT_DTL_V is not referenced by any database object