[Home] [Help] [Dependency Information]
Object Name: | IBE_OE_CONTACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBE.IBE_OE_CONTACTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_ACCOUNT_ROLE_ID | NUMBER | (15) | Yes | Unique identifier for the role played by the party in the customer account |
CUST_ACCT_SITE_ID | NUMBER | (15) | Customer account site identifier. Foreign key to the HZ_CUST_ACCT_SITES_ALL table | |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Foreign key to the HZ_CUST_ACCOUNTS table |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
COMPANY_PARTY_ID | NUMBER | (15) | Yes | Companys party Id |
REL_PARTY_ID | NUMBER | (15) | Identifier for the party. Foreign key to the HZ_PARTIES table. | |
PERSON_PARTY_ID | NUMBER | (15) | Yes | The identifier of the subject in this relationship |
PARTY_NAME | VARCHAR2 | (301) | Party first name and last name | |
FIRST_NAME | VARCHAR2 | (150) | Party first name | |
LAST_NAME | VARCHAR2 | (150) | Party last name | |
JOB_TITLE | VARCHAR2 | (100) | Free form text for job title | |
STATUS | VARCHAR2 | (1) | Record status flag |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_ACCOUNT_ROLE_ID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, ACCOUNT_NUMBER
, COMPANY_PARTY_ID
, REL_PARTY_ID
, PERSON_PARTY_ID
, PARTY_NAME
, FIRST_NAME
, LAST_NAME
, JOB_TITLE
, STATUS
FROM APPS.IBE_OE_CONTACTS_V;
|
|
|