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

Object Details

Object Name:	IBY_EXT_BANK_BRANCHES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBY.IBY_EXT_BANK_BRANCHES_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
BRANCH_PARTY_ID	NUMBER	(15)	Yes
HOME_COUNTRY	VARCHAR2	(60)
BANK_BRANCH_NAME	VARCHAR2	(360)	Yes
BANK_BRANCH_NAME_ALT	VARCHAR2	(320)
BRANCH_NUMBER	VARCHAR2	(30)
START_DATE	DATE		Yes
END_DATE	DATE
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(240)
CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
ZIP	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
BANK_BRANCH_TYPE	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(2000)
EFT_SWIFT_CODE	VARCHAR2	(30)
EFT_USER_NUMBER	VARCHAR2	(30)
BANK_PARTY_ID	NUMBER	(15)	Yes
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
OPERATION_FLAG	CHAR	(1)

Query Text

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


SELECT BRANCH_PARTY_ID
,      HOME_COUNTRY
,      BANK_BRANCH_NAME
,      BANK_BRANCH_NAME_ALT
,      BRANCH_NUMBER
,      START_DATE
,      END_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      BANK_BRANCH_TYPE
,      DESCRIPTION
,      EFT_SWIFT_CODE
,      EFT_USER_NUMBER
,      BANK_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OPERATION_FLAG
FROM APPS.IBY_EXT_BANK_BRANCHES_V;

Dependencies

[top of page]

APPS.IBY_EXT_BANK_BRANCHES_V references the following:

APPS: CE_BANK_BRANCHES_V

APPS.IBY_EXT_BANK_BRANCHES_V is not referenced by any database object