eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AR.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	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:

APPS: CE_CONTACT_ASSIGNMENTS; HZ_CONTACT_POINTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.AR_CBA_BANK_BRANCH_CONTACTS_V is not referenced by any database object