DBA Data[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: ViewCE.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:

SchemaAPPS
SynonymHZ_CODE_ASSIGNMENTS
SynonymHZ_CONTACT_POINTS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
APPS.CE_BANK_BRANCHES_V is referenced by following:

SchemaAPPS
Package BodyAP_BANK_CHARGE_PKG - show dependent code
ViewAP_CHECKS_V
Package BodyAP_PAY_SINGLE_INVOICE_PKG - show dependent code
ViewAP_RECURRING_PAYMENTS_V
ViewAP_SLA_PAYMENTS_TRANSACTION_V
ViewAP_TRANSMISSION_CODES_V
ViewARFV_CASH_RECEIPTS
Package BodyARI_DB_UTILITIES - show dependent code
Package BodyARI_UTILITIES - show dependent code
Package BodyARP_BR_REMIT_BATCHES - show dependent code
Package BodyARP_EXT_BANK_PKG - show dependent code
PL/SQL PackageARP_EXT_BANK_PKG - show dependent code
Package BodyARP_PROCESS_BR_BATCHES - show dependent code
PL/SQL PackageARP_PROCESS_BR_BATCHES - show dependent code
PL/SQL PackageARP_PROCESS_BR_REMIT - show dependent code
Package BodyARP_PROCESS_BR_REMIT - show dependent code
Package BodyARP_PROCESS_CREDIT_UTIL - show dependent code
Package BodyARP_PROCESS_DET_PKG - show dependent code
Package BodyARP_PROGRAM_BR_REMIT - show dependent code
PL/SQL PackageARP_PROGRAM_GENERATE_BR - show dependent code
Package BodyARP_PROGRAM_GENERATE_BR - show dependent code
Package BodyARP_RW_BATCHES_PKG - show dependent code
PL/SQL PackageARP_RW_BATCHES_PKG - show dependent code
Package BodyARP_TRX_DEFAULTS_3 - show dependent code
PL/SQL PackageARP_TRX_DEFAULTS_3 - show dependent code
Package BodyARP_TRX_VAL - show dependent code
Package BodyARP_TRX_VALIDATE - show dependent code
Package BodyARRX_BRS - show dependent code
Package BodyARRX_C_BRS - show dependent code
Package BodyAR_ARBRATBR_XMLP_PKG - show dependent code
Package BodyAR_ARXAPRCL_XMLP_PKG - show dependent code
Package BodyAR_ARXSOC2_XMLP_PKG - show dependent code
Package BodyAR_ARXSOC_XMLP_PKG - show dependent code
ViewAR_AUTOMATIC_RECEIPTS_FORMAT_V
PL/SQL PackageAR_BILLS_MAIN - show dependent code
ViewAR_BOE_REMIT_RECEIPTS_CBR_V
ViewAR_BOE_REMIT_RECEIPTS_CBUNR_V
ViewAR_BOE_REMIT_RECEIPTS_NONCBR_V
ViewAR_BOE_REMIT_RECEIPTS_V
Package BodyAR_BR_REMIT_IMPORT_API_PUB - show dependent code
PL/SQL PackageAR_BR_REMIT_IMPORT_API_PUB - show dependent code
ViewAR_CASH_RECEIPTS_V
Package BodyAR_DEPOSIT_API_PUB - show dependent code
Package BodyAR_GTA_ARTRX_PROC - show dependent code
Package BodyAR_GTA_REPORTS_PKG - show dependent code
ViewAR_INTERIM_CASH_RECEIPTS_V
Package BodyAR_INVOICE_UTILS - show dependent code
Package BodyAR_IREC_PAYMENTS - show dependent code
Package BodyAR_PURGE - show dependent code
ViewAR_REMITTED_RECEIPTS_FORMAT_V
ViewAR_RX_OTHER_APPLICATIONS_V
ViewCEBV_BANK_BRANCHES
ViewCEFV_BANK_BRANCHES
ViewCE_185_TRANSACTIONS_V
ViewCE_200_REVERSAL_V
ViewCE_260_CF_REVERSAL_V
ViewCE_260_CF_TRANSACTIONS_V
ViewCE_260_TRANSACTIONS_V
ViewCE_801_EFT_TRANSACTIONS_V
ViewCE_801_TRANSACTIONS_V
ViewCE_999_REVERSAL_V
ViewCE_999_TRANSACTIONS_V
Package BodyCE_AUTO_BANK_IMPORT - show dependent code
ViewCE_AVAIL_STATEMENTS_V
Package BodyCE_BANK_ACCT_BALANCE_REPORT - show dependent code
Package BodyCE_BANK_PUB - show dependent code
Package BodyCE_BANK_STATEMENT_LOADER - show dependent code
ViewCE_BANK_TRX_CODES_V
Package BodyCE_BASIG_WF - show dependent code
Package BodyCE_BAT_API - show dependent code
Package BodyCE_BNK_STMT_IMP_RPT_PKG - show dependent code
Package BodyCE_CEJEEXER_XMLP_PKG - show dependent code
Package BodyCE_CEPURGE_XMLP_PKG - show dependent code
Package BodyCE_CEXAVBCH_XMLP_PKG - show dependent code
Package BodyCE_CEXAVTRX_XMLP_PKG - show dependent code
Package BodyCE_CEXCLEAR_XMLP_PKG - show dependent code
Package BodyCE_CEXCSHTR_XMLP_PKG - show dependent code
Package BodyCE_CEXINERR_XMLP_PKG - show dependent code
Package BodyCE_CEXRECRE_XMLP_PKG - show dependent code
Package BodyCE_CEXSTMRR_XMLP_PKG - show dependent code
Package BodyCE_CEXSTMSR_XMLP_PKG - show dependent code
Package BodyCE_CEXTRXCD_XMLP_PKG - show dependent code
Package BodyCE_CEZBAERR_XMLP_PKG - show dependent code
ViewCE_CP_BANK_ACCOUNTS_V
ViewCE_CP_WS_BA_DISC_V
ViewCE_CP_WS_BA_V
ViewCE_CP_WS_LE_V
ViewCE_CP_XTR_BANK_ACCOUNTS_V
ViewCE_INTERNAL_BANK_ACCOUNTS_V
ViewCE_INTERNAL_BANK_ACCTS_GT_V
ViewCE_INTRA_STMT_HDRS_LINES_V
ViewCE_JE_MAPPINGS_V
PL/SQL PackageCE_PURGE - show dependent code
Package BodyCE_PURGE - show dependent code
ViewCE_P_BA_SIGNATORY_HIST_V
ViewCE_STATEMENT_HEADERS_V
ViewCE_TRANSACTION_CODES_V
ViewCE_XLA_EXT_HEADERS_V
Package BodyCE_XML_BS_LOADER - show dependent code
Package BodyCE_XML_HDRS_INF_PKG - show dependent code
Package BodyCLN_RN_UTILS - show dependent code
Package BodyECE_RULES_PKG - show dependent code
Package BodyECE_TRADING_PARTNERS_PUB - show dependent code
Package BodyECX_TP_API - show dependent code
ViewECX_TP_HEADERS_V
Package BodyECX_TP_SYNCH - show dependent code
Package BodyEC_TRADING_PARTNER_PVT - show dependent code
Package BodyFV_CCR_UTIL_PVT - show dependent code
Package BodyIBY_DISBURSEMENT_SETUP_PUB - show dependent code
PL/SQL PackageIBY_DISBURSE_SUBMIT_PUB_PKG - show dependent code
Package BodyIBY_EXT_BANKACCT_PUB - show dependent code
ViewIBY_EXT_BANK_BRANCHES_V
ViewIBY_EXT_FD_PRBA_1_0_V
ViewIBY_FNDCPT_PAYER_ASSGN_BA_V
Package BodyIBY_FNDCPT_VLD_PUB - show dependent code
ViewIBY_PAYEE_ALL_BANKACCT_V
ViewIBY_PAYEE_ASSIGNED_BANKACCT_V
PL/SQL PackageIBY_PAYGROUP_PUB - show dependent code
Package BodyIBY_PAYGROUP_PUB - show dependent code
Package BodyIBY_VALIDATIONSETS_CALLS_PUB - show dependent code
Package BodyIBY_VALIDATIONSETS_PUB - show dependent code
PL/SQL PackageIBY_VALIDATIONSETS_PUB - show dependent code
ViewIBY_XML_FD_11IPMT_1_0_V
Package BodyJAI_ETCS_PKG - show dependent code
ViewJL_BR_AP_COLLECTION_DOCS_V
ViewJL_BR_AP_INT_COLLECT_EXT_V
Package BodyJL_BR_AP_VALIDATE_COLLECTION - show dependent code
Package BodyJL_CO_GL_NIT_MANAGEMENT - show dependent code
ViewOKL_AP_TRX_LINE_UV
ViewOKL_AR_TRX_LINE_UV
ViewOKL_BPD_RCPT_MTHDS_UV
Package BodyPOS_EXCELASN_PVT - show dependent code
Package BodyZX_AR_POPULATE_PKG - show dependent code
Package BodyZX_JA_EXTRACT_PKG - show dependent code