DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_CUST_CONTACTS_V

Object Details
Object Name: OKX_CUST_CONTACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUST_CONTACTS_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
ID1 NUMBER (15) Yes Unique identifier of the party playing a contact role in the customer account
ID2 CHAR (1)
Not used
PARTY_ID NUMBER (15) Yes Contact's party identifier (Primary key)
PARTY_ID2 CHAR (1)
Contact's party identifier (Multi-part primary key)
DESCRIPTION VARCHAR2 (40)
Formatted address
NAME VARCHAR2 (92)
Party name for the contact
CUST_ACCT_ID NUMBER (15) Yes FK to HZ_CUST_ACCOUNTS_ALL
ROLE_TYPE VARCHAR2 (30) Yes Role type
CUST_ACCT_SITE_ID NUMBER (15)
Customer account site identifier. FK to HZ_CUST_ACCT_SITES_ALL
STATUS VARCHAR2 (1)
Status
EMAIL_ADDRESS VARCHAR2 (2000)
CONTACT_REFERENCE_ID VARCHAR2 (240) Yes
JOB_TITLE VARCHAR2 (100)
DEPARTMENT VARCHAR2 (60)
ADDRESS VARCHAR2 (4000)
TITLE VARCHAR2 (30)
PERSON_PARTY_ID NUMBER (15) Yes
Query Text

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


SELECT ID1
,      ID2
,      PARTY_ID
,      PARTY_ID2
,      DESCRIPTION
,      NAME
,      CUST_ACCT_ID
,      ROLE_TYPE
,      CUST_ACCT_SITE_ID
,      STATUS
,      EMAIL_ADDRESS
,      CONTACT_REFERENCE_ID
,      JOB_TITLE
,      DEPARTMENT
,      ADDRESS
,      TITLE
,      PERSON_PARTY_ID
FROM APPS.OKX_CUST_CONTACTS_V;

Dependencies

[top of page]

APPS.OKX_CUST_CONTACTS_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
APPS.OKX_CUST_CONTACTS_V is referenced by following:

SchemaAPPS
Package BodyOKS_ATTR_DEFAULTS_PVT - show dependent code
Package BodyOKS_CONTRACTS_PUB - show dependent code
Package BodyOKS_EXTWARPRGM_OSO_PVT - show dependent code
Package BodyOKS_EXTWARPRGM_PVT - show dependent code
Package BodyOKS_QA_DATA_INTEGRITY - show dependent code
Package BodyOKS_SETUP_UTIL_PUB - show dependent code