[Home] [Help] [Dependency Information]
Object Name: | OE_CONTACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OE_CONTACTS_V |
Subobject Name: | |
Status: | VALID |
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..)
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 |
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;
|
|
|