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]

TABLE: AP.AP_BANK_BRANCHES

Object Details

Object Name:	AP_BANK_BRANCHES
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_BANK_BRANCHES
Subobject Name:
Status:	VALID

AP_BANK_BRANCHES contains information about the bank branches you define when you set up your banks. You need one row for each bank branch you use. One bank branch may have multiple bank accounts.
This table corresponds to the Bank Branch region of the Banks window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_BANK_BRANCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BANK_BRANCH_ID
AP_BANK_BRANCHES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BANK_NAME BANK_BRANCH_NAME
AP_BANK_BRANCHES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLEARING_HOUSE_ID
AP_BANK_BRANCHES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EDI_ID_NUMBER
AP_BANK_BRANCHES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_NUM BANK_NUMBER COUNTRY

Columns

Name	Datatype	Length	Mandatory	Comments
BANK_BRANCH_ID	NUMBER	(15)	Yes	Bank branch identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
BANK_NAME	VARCHAR2	(60)	Yes	Bank name
BANK_BRANCH_NAME	VARCHAR2	(60)	Yes	Bank branch name
DESCRIPTION	VARCHAR2	(240)		Description
ADDRESS_LINE1	VARCHAR2	(35)		First address line
ADDRESS_LINE2	VARCHAR2	(35)		Second address line
ADDRESS_LINE3	VARCHAR2	(35)		Third address line
CITY	VARCHAR2	(25)		City
STATE	VARCHAR2	(25)		State or province
ZIP	VARCHAR2	(20)		Zip code
PROVINCE	VARCHAR2	(25)		No longer used
COUNTRY	VARCHAR2	(25)		Country
AREA_CODE	VARCHAR2	(10)		Area code
PHONE	VARCHAR2	(15)		Phone number
CONTACT_FIRST_NAME	VARCHAR2	(15)		First name of branch contact person
CONTACT_MIDDLE_NAME	VARCHAR2	(15)		Middle name of branch contact person
CONTACT_LAST_NAME	VARCHAR2	(20)		Last name of branch contact person
CONTACT_PREFIX	VARCHAR2	(5)		Prefix of branch contact person (Ms., Mr., Mrs., Miss, etc.)
CONTACT_TITLE	VARCHAR2	(30)		Title of branch contact person
BANK_NUM	VARCHAR2	(25)		Branch number
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INSTITUTION_TYPE	VARCHAR2	(25)	Yes	Not used by Oracle Payables applications
CLEARING_HOUSE_ID	NUMBER			Not used by Oracle Payables applications
TRANSMISSION_PROGRAM_ID	NUMBER			Not used by Oracle Payables applications
PRINTING_PROGRAM_ID	NUMBER			Not used by Oracle Payables applications
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ADDRESS_STYLE	VARCHAR2	(30)		Used as context field for FAF desc flex. Do not populate. Join with FND_TERRITORIES where COUNTRY=TERRITORY_CODE
BANK_NUMBER	VARCHAR2	(30)		Bank number. Added for Flexible Bank Structure functionality. Holds the number used by some countries to identify bank
ADDRESS_LINE4	VARCHAR2	(35)		Fourth address line. Used for flexible address formatting
COUNTY	VARCHAR2	(25)		Added for Flexible Address Format functionality
EFT_USER_NUMBER	VARCHAR2	(30)		The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization
EFT_SWIFT_CODE	VARCHAR2	(12)		EFT swift code
END_DATE	DATE			End date
EDI_ID_NUMBER	VARCHAR2	(30)		EDI trading partner number for the Bank Branch
BANK_BRANCH_TYPE	VARCHAR2	(25)		Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT and OTHER
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
BANK_NAME_ALT	VARCHAR2	(320)		Alternate bank name
BANK_BRANCH_NAME_ALT	VARCHAR2	(320)		Alternate bank branch name
ADDRESS_LINES_ALT	VARCHAR2	(560)		Alternate address lines
ACTIVE_DATE	DATE			Active date
TP_HEADER_ID	NUMBER	(15)		Trading partner header identifier
ECE_TP_LOCATION_CODE	VARCHAR2	(60)		Trading partner location code
PAYROLL_BANK_ACCOUNT_ID	NUMBER	(9)		Bank account identifier for payroll bank accounts
RFC_IDENTIFIER	VARCHAR2	(15)		Regional Finance Center Identifier used only to identify a branch of the United States Treasury bank.
BANK_ADMIN_EMAIL	VARCHAR2	(255)		E-mail address for XML messages administrator at the bank

Query Text

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


SELECT BANK_BRANCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      BANK_NAME
,      BANK_BRANCH_NAME
,      DESCRIPTION
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      AREA_CODE
,      PHONE
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      BANK_NUM
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      INSTITUTION_TYPE
,      CLEARING_HOUSE_ID
,      TRANSMISSION_PROGRAM_ID
,      PRINTING_PROGRAM_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADDRESS_STYLE
,      BANK_NUMBER
,      ADDRESS_LINE4
,      COUNTY
,      EFT_USER_NUMBER
,      EFT_SWIFT_CODE
,      END_DATE
,      EDI_ID_NUMBER
,      BANK_BRANCH_TYPE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      BANK_NAME_ALT
,      BANK_BRANCH_NAME_ALT
,      ADDRESS_LINES_ALT
,      ACTIVE_DATE
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      PAYROLL_BANK_ACCOUNT_ID
,      RFC_IDENTIFIER
,      BANK_ADMIN_EMAIL
FROM AP.AP_BANK_BRANCHES;

Dependencies

[top of page]

AP.AP_BANK_BRANCHES does not reference any database object

AP.AP_BANK_BRANCHES is referenced by following:

AP: AP_BANK_BRANCHES#