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

VIEW: APPS.IBE_OE_CONTACTS_V

Object Details
Object Name: IBE_OE_CONTACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBE.IBE_OE_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
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
Query Text

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;

Dependencies

[top of page]

APPS.IBE_OE_CONTACTS_V references the following:

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

SchemaAPPS
ViewIBE_ORDER_HEADER_V
ViewIBE_ORDER_LINE_DTL_V