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


VIEW: APPS.AR_CBA_BANK_BRANCH_CONTACTS_V

Object Details
Object Name: AR_CBA_BANK_BRANCH_CONTACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_CBA_BANK_BRANCH_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
LAST_NAME VARCHAR2 (150)
Last or surname of the person
FIRST_NAME VARCHAR2 (150)
First name of the person
MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
PREFIX VARCHAR2 (30)
Salutary introduction, such as Mr. or Herr
PHONE_COUNTRY_CODE VARCHAR2 (10)
International country code for a telephone number. For example, 33 for France.
PHONE_AREA_CODE VARCHAR2 (10)
The area code within a country code.
PHONE_NUMBER VARCHAR2 (40)
A telephone number formatted in the local format. The number should not include area code, country code, or extension.
RAW_PHONE_NUMBER VARCHAR2 (60)
Unformatted telephone number
FAX_COUNTRY_CODE VARCHAR2 (10)
International country code for a telephone number. For example, 33 for France.
FAX_AREA_CODE VARCHAR2 (10)
The area code within a country code.
FAX_NUMBER VARCHAR2 (40)
A telephone number formatted in the local format. The number should not include area code, country code, or extension.
RAW_FAX_NUMBER VARCHAR2 (60)
Unformatted telephone number
EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address of the contact point
URL VARCHAR2 (2000)
Uniform resource locator
BANK_OR_BRANCH_ID NUMBER

Party identifier
Query Text

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


SELECT LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      TITLE
,      PREFIX
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      RAW_PHONE_NUMBER
,      FAX_COUNTRY_CODE
,      FAX_AREA_CODE
,      FAX_NUMBER
,      RAW_FAX_NUMBER
,      EMAIL_ADDRESS
,      URL
,      BANK_OR_BRANCH_ID
FROM APPS.AR_CBA_BANK_BRANCH_CONTACTS_V;

Dependencies

[top of page]

APPS.AR_CBA_BANK_BRANCH_CONTACTS_V references the following:

SchemaAPPS
SynonymCE_CONTACT_ASSIGNMENTS
SynonymHZ_CONTACT_POINTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS

APPS.AR_CBA_BANK_BRANCH_CONTACTS_V is not referenced by any database object