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:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
SynonymOKS_K_HEADERS_B

APPS.OKI_HQTCONT_DTL_V is not referenced by any database object