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

VIEW: APPS.OE_CONTACTS_V

Object Details
Object Name: OE_CONTACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_CONTACTS_V
Subobject Name:
Status: VALID

View Type

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


This view is based on ra_contacts. Used for validation of contact identifications(deliver to contact, sold to contact etc..)


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTACT_ID NUMBER (15) Yes Unique identifier for the role played by the party in the customer account
ORG_ID NUMBER (15)
Customer account site identifier. Foreign key to the HZ_CUST_ACCT_SITES_ALL table
CUSTOMER_ID NUMBER (15) Yes Foreign key to the HZ_CUST_ACCOUNTS table
NAME VARCHAR2 (302)
Party name
JOB_TITLE VARCHAR2 (100)
Code given to the job title
STATUS VARCHAR2 (1)
Record status flag
EMAIL_ADDRESS VARCHAR2 (2000)
Email address
Query Text

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


SELECT CONTACT_ID
,      ORG_ID
,      CUSTOMER_ID
,      NAME
,      JOB_TITLE
,      STATUS
,      EMAIL_ADDRESS
FROM APPS.OE_CONTACTS_V;

Dependencies

[top of page]

APPS.OE_CONTACTS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
APPS.OE_CONTACTS_V is referenced by following:

SchemaAPPS
Package BodyAHL_OSP_SHIPMENT_PUB - show dependent code
Package BodyOE_BULK_VALUE_TO_ID - show dependent code
Package BodyOE_CNCL_VALUE_TO_ID - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
PL/SQL PackageOE_OE_FORM_HEADER - show dependent code
Package BodyOE_OE_FORM_HEADER - show dependent code
Package BodyOE_OE_FORM_LINE - show dependent code
PL/SQL PackageOE_OE_FORM_LINE - show dependent code
Package BodyOE_VALUE_TO_ID - show dependent code
Package BodyONT_OEXOECOD_XMLP_PKG - show dependent code
Package BodyQP_ID_TO_VALUE - show dependent code