[Home] [Help]
[Dependency Information]
VIEW: APPS.CE_BANK_BRANCHES_V
Object Details
Object Name: | CE_BANK_BRANCHES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_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 |
Comments |
ROW_ID |
ROWID |
(10) |
|
Database row identifier |
BANK_HOME_COUNTRY |
VARCHAR2 |
(2) |
|
Bank home country |
BANK_PARTY_ID |
NUMBER |
(15) |
Yes |
TCA party identifier for bank |
BANK_NAME |
VARCHAR2 |
(360) |
Yes |
Bank name |
BANK_NAME_ALT |
VARCHAR2 |
(320) |
|
Alternate bank name |
SHORT_BANK_NAME |
VARCHAR2 |
(240) |
|
Short bank name |
BANK_NUMBER |
VARCHAR2 |
(30) |
|
Bank number |
BRANCH_PARTY_ID |
NUMBER |
(15) |
Yes |
TCA party identifier for bank branch |
BANK_BRANCH_NAME |
VARCHAR2 |
(360) |
Yes |
Bank branch name |
BANK_BRANCH_NAME_ALT |
VARCHAR2 |
(320) |
|
Alternate bank branch name |
BRANCH_NUMBER |
VARCHAR2 |
(30) |
|
Bank branch number |
START_DATE |
DATE |
|
Yes |
Bank branch start date |
END_DATE |
DATE |
|
|
Bank branch end date |
ADDRESS_LINE1 |
VARCHAR2 |
(240) |
|
Bank branch address line 1 |
ADDRESS_LINE2 |
VARCHAR2 |
(240) |
|
Bank branch address line 2 |
ADDRESS_LINE3 |
VARCHAR2 |
(240) |
|
Bank branch address line 3 |
ADDRESS_LINE4 |
VARCHAR2 |
(240) |
|
Bank branch address line 4 |
CITY |
VARCHAR2 |
(60) |
|
Bank branch city |
STATE |
VARCHAR2 |
(60) |
|
Bank branch state |
PROVINCE |
VARCHAR2 |
(60) |
|
Bank branch province |
ZIP |
VARCHAR2 |
(60) |
|
Bank branch postal code |
COUNTRY |
VARCHAR2 |
(60) |
|
Bank branch country |
BANK_INSTITUTION_TYPE |
VARCHAR2 |
(30) |
Yes |
Bank institution type (BANK or CLEARINGHOUSE) |
BANK_BRANCH_TYPE |
VARCHAR2 |
(30) |
|
Bank branch type |
DESCRIPTION |
VARCHAR2 |
(2000) |
|
Bank branch description |
EFT_SWIFT_CODE |
VARCHAR2 |
(30) |
|
SWIFT Code (BIC) |
EFT_USER_NUMBER |
VARCHAR2 |
(30) |
|
EFT User Number |
EDI_ID_NUMBER |
VARCHAR2 |
(30) |
|
EDI Identification Number |
PK_ID |
NUMBER |
(15) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, BANK_HOME_COUNTRY
, BANK_PARTY_ID
, BANK_NAME
, BANK_NAME_ALT
, SHORT_BANK_NAME
, BANK_NUMBER
, BRANCH_PARTY_ID
, 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_INSTITUTION_TYPE
, BANK_BRANCH_TYPE
, DESCRIPTION
, EFT_SWIFT_CODE
, EFT_USER_NUMBER
, EDI_ID_NUMBER
, PK_ID
FROM APPS.CE_BANK_BRANCHES_V;
Dependencies
[top of page]
APPS.CE_BANK_BRANCHES_V references the following:
-
APPS
-
HZ_CODE_ASSIGNMENTS
-
HZ_CONTACT_POINTS
-
HZ_ORGANIZATION_PROFILES
-
HZ_PARTIES
-
HZ_RELATIONSHIPS
APPS.CE_BANK_BRANCHES_V is referenced by following:
-
APPS
-
AP_BANK_CHARGE_PKG
- show dependent code
-
AP_CHECKS_V
-
AP_PAY_SINGLE_INVOICE_PKG
- show dependent code
-
AP_SLA_PAYMENTS_TRANSACTION_V
-
AP_TRANSMISSION_CODES_V
-
ARFV_CASH_RECEIPTS
-
ARP_BR_REMIT_BATCHES
- show dependent code
-
ARP_EXT_BANK_PKG
- show dependent code
-
ARP_EXT_BANK_PKG
- show dependent code
-
ARP_PROCESS_BR_BATCHES
- show dependent code
-
ARP_PROCESS_BR_BATCHES
- show dependent code
-
ARP_PROCESS_BR_REMIT
- show dependent code
-
ARP_PROCESS_BR_REMIT
- show dependent code
-
ARP_PROCESS_CREDIT_UTIL
- show dependent code
-
ARP_PROCESS_DET_PKG
- show dependent code
-
ARP_PROGRAM_BR_REMIT
- show dependent code
-
ARP_PROGRAM_GENERATE_BR
- show dependent code
-
ARP_PROGRAM_GENERATE_BR
- show dependent code
-
ARP_RW_BATCHES_PKG
- show dependent code
-
ARP_RW_BATCHES_PKG
- show dependent code
-
ARP_TRX_DEFAULTS_3
- show dependent code
-
ARP_TRX_DEFAULTS_3
- show dependent code
-
ARP_TRX_VAL
- show dependent code
-
ARP_TRX_VALIDATE
- show dependent code
-
ARRX_BRS
- show dependent code
-
ARRX_C_BRS
- show dependent code
-
AR_ARBRATBR_XMLP_PKG
- show dependent code
-
AR_ARXAPRCL_XMLP_PKG
- show dependent code
-
AR_ARXSOC2_XMLP_PKG
- show dependent code
-
AR_ARXSOC_XMLP_PKG
- show dependent code
-
AR_AUTOMATIC_RECEIPTS_FORMAT_V
-
AR_BILLS_MAIN
- show dependent code
-
AR_BOE_REMIT_RECEIPTS_CBR_V
-
AR_BOE_REMIT_RECEIPTS_CBUNR_V
-
AR_BOE_REMIT_RECEIPTS_NONCBR_V
-
AR_BOE_REMIT_RECEIPTS_V
-
AR_BR_REMIT_IMPORT_API_PUB
- show dependent code
-
AR_BR_REMIT_IMPORT_API_PUB
- show dependent code
-
AR_CASH_RECEIPTS_V
-
AR_DEPOSIT_API_PUB
- show dependent code
-
AR_INTERIM_CASH_RECEIPTS_V
-
AR_INVOICE_UTILS
- show dependent code
-
AR_PURGE
- show dependent code
-
AR_REMITTED_RECEIPTS_FORMAT_V
-
AR_RX_OTHER_APPLICATIONS_V
-
CEBV_BANK_BRANCHES
-
CEFV_BANK_BRANCHES
-
CE_185_TRANSACTIONS_V
-
CE_200_REVERSAL_V
-
CE_260_CF_REVERSAL_V
-
CE_260_CF_TRANSACTIONS_V
-
CE_260_TRANSACTIONS_V
-
CE_801_EFT_TRANSACTIONS_V
-
CE_801_TRANSACTIONS_V
-
CE_999_REVERSAL_V
-
CE_999_TRANSACTIONS_V
-
CE_AUTO_BANK_IMPORT
- show dependent code
-
CE_AVAIL_STATEMENTS_V
-
CE_BANK_ACCT_BALANCE_REPORT
- show dependent code
-
CE_BANK_STATEMENT_LOADER
- show dependent code
-
CE_BANK_TRX_CODES_V
-
CE_BASIG_WF
- show dependent code
-
CE_BAT_API
- show dependent code
-
CE_BNK_STMT_IMP_RPT_PKG
- show dependent code
-
CE_CEJEEXER_XMLP_PKG
- show dependent code
-
CE_CEPURGE_XMLP_PKG
- show dependent code
-
CE_CEXAVBCH_XMLP_PKG
- show dependent code
-
CE_CEXAVTRX_XMLP_PKG
- show dependent code
-
CE_CEXCLEAR_XMLP_PKG
- show dependent code
-
CE_CEXCSHTR_XMLP_PKG
- show dependent code
-
CE_CEXINERR_XMLP_PKG
- show dependent code
-
CE_CEXRECRE_XMLP_PKG
- show dependent code
-
CE_CEXSTMRR_XMLP_PKG
- show dependent code
-
CE_CEXSTMSR_XMLP_PKG
- show dependent code
-
CE_CEXTRXCD_XMLP_PKG
- show dependent code
-
CE_CEZBAERR_XMLP_PKG
- show dependent code
-
CE_CP_BANK_ACCOUNTS_V
-
CE_CP_WS_BA_DISC_V
-
CE_CP_WS_BA_V
-
CE_CP_WS_LE_V
-
CE_CP_XTR_BANK_ACCOUNTS_V
-
CE_INTERNAL_BANK_ACCOUNTS_V
-
CE_INTERNAL_BANK_ACCTS_GT_V
-
CE_INTRA_STMT_HDRS_LINES_V
-
CE_JE_MAPPINGS_V
-
CE_P_BA_SIGNATORY_HIST_V
-
CE_STATEMENT_HEADERS_V
-
CE_TRANSACTION_CODES_V
-
CE_XLA_EXT_HEADERS_V
-
CE_XML_BS_LOADER
- show dependent code
-
CE_XML_HDRS_INF_PKG
- show dependent code
-
CLN_RN_UTILS
- show dependent code
-
ECE_RULES_PKG
- show dependent code
-
ECE_TRADING_PARTNERS_PUB
- show dependent code
-
ECX_TP_API
- show dependent code
-
ECX_TP_HEADERS_V
-
ECX_TP_SYNCH
- show dependent code
-
EC_TRADING_PARTNER_PVT
- show dependent code
-
FV_CCR_UTIL_PVT
- show dependent code
-
IBY_DISBURSEMENT_SETUP_PUB
- show dependent code
-
IBY_DISBURSE_SUBMIT_PUB_PKG
- show dependent code
-
IBY_EXT_BANKACCT_PUB
- show dependent code
-
IBY_EXT_BANK_BRANCHES_V
-
IBY_EXT_FD_PRBA_1_0_V
-
IBY_PAYEE_ALL_BANKACCT_V
-
IBY_PAYEE_ASSIGNED_BANKACCT_V
-
IBY_PAYGROUP_PUB
- show dependent code
-
IBY_VALIDATIONSETS_CALLS_PUB
- show dependent code
-
IBY_VALIDATIONSETS_PUB
- show dependent code
-
IBY_VALIDATIONSETS_PUB
- show dependent code
-
JAI_ETCS_PKG
- show dependent code
-
JL_BR_AP_COLLECTION_DOCS_V
-
JL_BR_AP_INT_COLLECT_EXT_V
-
JL_BR_AP_VALIDATE_COLLECTION
- show dependent code
-
JL_CO_GL_NIT_MANAGEMENT
- show dependent code
-
JMF_GTA_ARTRX_PROC
- show dependent code
-
JMF_GTA_REPORTS_PKG
- show dependent code
-
OKL_AP_TRX_LINE_UV
-
OKL_AR_TRX_LINE_UV
-
OKL_BPD_RCPT_MTHDS_UV
-
ZX_AR_POPULATE_PKG
- show dependent code
-
ZX_JA_EXTRACT_PKG
- show dependent code