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

Object Details

Object Name:	CE_BU_PAY_EXTERNAL_ACCTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
EXTERNAL_ACCOUNT_ID	NUMBER	(9)
ACCOUNT_NAME	VARCHAR2	(150)
ACCOUNT_NUMBER	VARCHAR2	(150)
BANK_NAME	VARCHAR2	(150)
BRANCH_NAME	VARCHAR2	(150)
LOCATION	VARCHAR2	(150)
CURRENCY_CODE	VARCHAR2	(150)
BANK_NUMBER	VARCHAR2	(150)
BRANCH_NUMBER	VARCHAR2	(150)
BANK_ACCOUNT_TYPE	VARCHAR2	(150)
SECONDARY_ACCOUNT_REFERENCE	VARCHAR2	(150)
COMM_AGREEMENT_IDENTIFIER	VARCHAR2	(150)
ACCOUNT_SUFFIX	VARCHAR2	(150)
DESCRIPTION	VARCHAR2	(150)
DESCRIPTION_CODE1	VARCHAR2	(150)
DESCRIPTION_CODE2	VARCHAR2	(150)
EFT_REQUESTER_IDENTIFIER	VARCHAR2	(150)
BANK_NAME_KANA	VARCHAR2	(60)
BANK_START_DATE	DATE
BANK_END_DATE	DATE
BRANCH_NAME_KANA	VARCHAR2	(90)
BRANCH_START_DATE	DATE
BRANCH_END_DATE	DATE
ACCOUNT_START_DATE	DATE
ACCOUNT_END_DATE	DATE
COUNTRY	VARCHAR2	(80)
COUNTRY_CODE	VARCHAR2	(2)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT EXTERNAL_ACCOUNT_ID
,      ACCOUNT_NAME
,      ACCOUNT_NUMBER
,      BANK_NAME
,      BRANCH_NAME
,      LOCATION
,      CURRENCY_CODE
,      BANK_NUMBER
,      BRANCH_NUMBER
,      BANK_ACCOUNT_TYPE
,      SECONDARY_ACCOUNT_REFERENCE
,      COMM_AGREEMENT_IDENTIFIER
,      ACCOUNT_SUFFIX
,      DESCRIPTION
,      DESCRIPTION_CODE1
,      DESCRIPTION_CODE2
,      EFT_REQUESTER_IDENTIFIER
,      BANK_NAME_KANA
,      BANK_START_DATE
,      BANK_END_DATE
,      BRANCH_NAME_KANA
,      BRANCH_START_DATE
,      BRANCH_END_DATE
,      ACCOUNT_START_DATE
,      ACCOUNT_END_DATE
,      COUNTRY
,      COUNTRY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.CE_BU_PAY_EXTERNAL_ACCTS_V;

Dependencies

[top of page]

APPS.CE_BU_PAY_EXTERNAL_ACCTS_V references the following:

APPS: FND_TERRITORIES_VL; HR_API - show dependent code; HR_LOOKUPS; PAY_EXTERNAL_ACCOUNTS; PAY_JP_BANKS; PAY_JP_BANK_BRANCHES

APPS.CE_BU_PAY_EXTERNAL_ACCTS_V is not referenced by any database object