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.CEBV_BANK_BRANCHES

Object Details

Object Name:	CEBV_BANK_BRANCHES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CEBV_BANK_BRANCHES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BANK_BRANCH_ID	NUMBER	(15)	Yes
BANK_NAME	VARCHAR2	(360)	Yes
ALTERNATE_BANK_NAME	VARCHAR2	(320)
BANK_NUMBER	VARCHAR2	(30)
BANK_BRANCH_NAME	VARCHAR2	(360)	Yes
ALTERNATE_BANK_BRANCH_NAME	VARCHAR2	(320)
BANK_BRANCH_NUMBER	VARCHAR2	(30)
BANK_BRANCH_TYPE	VARCHAR2	(30)
INSTITUTION_TYPE	VARCHAR2	(30)	Yes
DESCRIPTION	VARCHAR2	(2000)
START_EFFECTIVE_DATE	DATE		Yes
END_EFFECTIVE_DATE	DATE
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(240)
ALTERNATE_ADDRESS_LINES	VARCHAR2	(0)
CITY	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
ZIP_CODE	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
AREA_CODE	VARCHAR2	(0)
PHONE	VARCHAR2	(0)
CONTACT_FIRST_NAME	VARCHAR2	(0)
CONTACT_MIDDLE_NAME	VARCHAR2	(0)
CONTACT_LAST_NAME	VARCHAR2	(0)
CONTACT_PREFIX	VARCHAR2	(0)
CONTACT_TITLE	VARCHAR2	(0)
EFT_USER_NUMBER	VARCHAR2	(30)
EFT_SWIFT_CODE	VARCHAR2	(30)
EDI_ID_NUMBER	VARCHAR2	(30)
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT BANK_BRANCH_ID
,      BANK_NAME
,      ALTERNATE_BANK_NAME
,      BANK_NUMBER
,      BANK_BRANCH_NAME
,      ALTERNATE_BANK_BRANCH_NAME
,      BANK_BRANCH_NUMBER
,      BANK_BRANCH_TYPE
,      INSTITUTION_TYPE
,      DESCRIPTION
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      ALTERNATE_ADDRESS_LINES
,      CITY
,      COUNTY
,      STATE
,      ZIP_CODE
,      COUNTRY
,      AREA_CODE
,      PHONE
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      EFT_USER_NUMBER
,      EFT_SWIFT_CODE
,      EDI_ID_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.CEBV_BANK_BRANCHES;

Dependencies

[top of page]

APPS.CEBV_BANK_BRANCHES references the following:

APPS: CE_BANK_BRANCHES_V

APPS.CEBV_BANK_BRANCHES is not referenced by any database object