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


VIEW: APPS.CE_INTERNAL_BANK_ACCOUNTS_V

Object Details
Object Name: CE_INTERNAL_BANK_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_INTERNAL_BANK_ACCOUNTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_ID NUMBER (15) Yes
BANK_ACCOUNT_NAME VARCHAR2 (100) Yes
BANK_ACCOUNT_NUM VARCHAR2 (30)

CURRENCY_CODE VARCHAR2 (15)

MULTI_CURRENCY_FLAG VARCHAR2 (1)

ASSET_CODE_COMBINATION_ID NUMBER (15)

BANK_NAME VARCHAR2 (360) Yes
BANK_BRANCH_NAME VARCHAR2 (360) Yes
BANK_BRANCH_ID NUMBER (15) Yes
BANK_ACCOUNT_NUM_NAME VARCHAR2 (132)
INACTIVE_DATE DATE

CHECK_DIGITS VARCHAR2 (30)
Holds any check digits that result from bank account number validation in FBS
BRANCH_END_DATE DATE

End date
ACCOUNT_TYPE VARCHAR2 (80) Yes
Query Text

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


SELECT BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      CURRENCY_CODE
,      MULTI_CURRENCY_FLAG
,      ASSET_CODE_COMBINATION_ID
,      BANK_NAME
,      BANK_BRANCH_NAME
,      BANK_BRANCH_ID
,      BANK_ACCOUNT_NUM_NAME
,      INACTIVE_DATE
,      CHECK_DIGITS
,      BRANCH_END_DATE
,      ACCOUNT_TYPE
FROM APPS.CE_INTERNAL_BANK_ACCOUNTS_V;

Dependencies

[top of page]

APPS.CE_INTERNAL_BANK_ACCOUNTS_V references the following:

SchemaAPPS
ViewCE_BANK_ACCOUNTS_V
ViewCE_BANK_BRANCHES_V
ViewCE_LOOKUPS
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
PL/SQL PackageXTR_USER_ACCESS - show dependent code
APPS.CE_INTERNAL_BANK_ACCOUNTS_V is referenced by following:

SchemaAPPS
Package BodyCE_BNK_STMT_RECON_RPT_PKG - show dependent code
Package BodyIBY_FD_USER_API_PUB - show dependent code