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

VIEW: APPS.CE_BANKS_MERGE_V

Object Details
Object Name: CE_BANKS_MERGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_BANKS_MERGE_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_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
ADDRESS_LINE1 VARCHAR2 (240)
Bank address line 1
ADDRESS_LINE2 VARCHAR2 (240)
Bank address line 2
ADDRESS_LINE3 VARCHAR2 (240)
Bank address line 3
ADDRESS_LINE4 VARCHAR2 (240)
Bank address line 4
CITY VARCHAR2 (60)
Bank address city
STATE VARCHAR2 (60)
Bank address state
PROVINCE VARCHAR2 (60)
Bank address province
ZIP VARCHAR2 (60)
Bank address postal code
COUNTRY VARCHAR2 (60)
Bank address country
BANK_INSTITUTION_TYPE VARCHAR2 (2000)
Bank institution type (BANK or CLEARINGHOUSE)
DESCRIPTION VARCHAR2 (30) Yes
PK_ID NUMBER (15) Yes
Query Text

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


SELECT ROW_ID
,      BANK_PARTY_ID
,      BANK_NAME
,      BANK_NAME_ALT
,      SHORT_BANK_NAME
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      BANK_INSTITUTION_TYPE
,      DESCRIPTION
,      PK_ID
FROM APPS.CE_BANKS_MERGE_V;

Dependencies

[top of page]

APPS.CE_BANKS_MERGE_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PARTY_USG_ASSIGNMENTS

APPS.CE_BANKS_MERGE_V is not referenced by any database object