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

VIEW: APPS.OKX_CUST_ROLE_RESP_V

Object Details
Object Name: OKX_CUST_ROLE_RESP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUST_ROLE_RESP_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 (360) Yes Formatted address
NAME VARCHAR2 (360) Yes Party name for the contact
EMAIL_ADDRESS VARCHAR2 (2000)
Contact email address
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
RESPONSIBILITY_TYPE VARCHAR2 (30) Yes Lookup for Responsibility Type
PRIMARY_FLAG VARCHAR2 (1)
"Y" if this is the primary responsibility for the party for the role played by the party in the account.
STATUS VARCHAR2 (1) Yes Party relationship status flag
Query Text

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


SELECT ID1
,      ID2
,      PARTY_ID
,      PARTY_ID2
,      DESCRIPTION
,      NAME
,      EMAIL_ADDRESS
,      CUST_ACCT_ID
,      ROLE_TYPE
,      CUST_ACCT_SITE_ID
,      RESPONSIBILITY_TYPE
,      PRIMARY_FLAG
,      STATUS
FROM APPS.OKX_CUST_ROLE_RESP_V;

Dependencies

[top of page]

APPS.OKX_CUST_ROLE_RESP_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
SynonymHZ_ROLE_RESPONSIBILITY

APPS.OKX_CUST_ROLE_RESP_V is not referenced by any database object