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

VIEW: APPS.CEFV_BANK_BRANCHES

Object Details
Object Name: CEFV_BANK_BRANCHES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CEFV_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 branch unique identifier.
BANK_NAME VARCHAR2 (360) Yes Bank name.
ALTERNATE_BANK_NAME VARCHAR2 (320)
Alternate bank name.
BANK_NUMBER VARCHAR2 (30)
Bank number.
BANK_BRANCH_NAME VARCHAR2 (360) Yes Bank branch name.
ALTERNATE_BANK_BRANCH_NAME VARCHAR2 (320)
Alternate bank branch name.
BANK_BRANCH_NUMBER VARCHAR2 (30)
Bank branch number.
BANK_BRANCH_TYPE VARCHAR2 (30)
Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT and OTHER.
DESCRIPTION VARCHAR2 (2000)
Description.
START_EFFECTIVE_DATE DATE
Yes From effective date.
END_EFFECTIVE_DATE DATE

To effective date.
ADDRESS_LINE1 VARCHAR2 (240)
First address line.
ADDRESS_LINE2 VARCHAR2 (240)
Second address line.
ADDRESS_LINE3 VARCHAR2 (240)
Third address line.
ADDRESS_LINE4 VARCHAR2 (240)
Fourth address line.
ALTERNATE_ADDRESS_LINES VARCHAR2 (0)
Alternate address lines.
CITY VARCHAR2 (60)
City.
COUNTY VARCHAR2 (60)
County.
STATE VARCHAR2 (60)
State.
ZIP_CODE VARCHAR2 (60)
Postal code.
COUNTRY VARCHAR2 (60)
Country.
AREA_CODE VARCHAR2 (0)
Area Code.
PHONE VARCHAR2 (0)
Telephone number.
CONTACT_FIRST_NAME VARCHAR2 (0)
First name of branch contact person.
CONTACT_MIDDLE_NAME VARCHAR2 (0)
Middle name of branch contact person.
CONTACT_LAST_NAME VARCHAR2 (0)
Last name of branch contact person.
CONTACT_PREFIX VARCHAR2 (0)
Title prefix of branch contact person.
CONTACT_TITLE VARCHAR2 (0)
Title of branch contact person.
EFT_USER_NUMBER VARCHAR2 (30)
Electronic Funds Transfer (EFT) User Number.
EFT_SWIFT_CODE VARCHAR2 (30)
Electronic Funds Transfer (EFT) swift code.
EDI_ID_NUMBER VARCHAR2 (30)
EDI trading partner number for the Bank Branch.
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).
_LA:INSTITUTION_TYPE CHAR (64)
Institution type. Possible values are Bank or Clearing House.
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
,      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
,      _LA:INSTITUTION_TYPE
FROM APPS.CEFV_BANK_BRANCHES;

Dependencies

[top of page]

APPS.CEFV_BANK_BRANCHES references the following:

SchemaAPPS
ViewCE_BANK_BRANCHES_V

APPS.CEFV_BANK_BRANCHES is not referenced by any database object