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

VIEW: APPS.CE_BANK_BRANCHES_MERGE_V

Object Details
Object Name: CE_BANK_BRANCHES_MERGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_BANK_BRANCHES_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
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
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
DESCRIPTION VARCHAR2 (2000)
Bank branch description
BANK_BRANCH_TYPE VARCHAR2 (30) Yes Bank branch type
PK_ID NUMBER (15) Yes
Query Text

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


SELECT ROW_ID
,      BRANCH_PARTY_ID
,      BANK_BRANCH_NAME
,      BANK_BRANCH_NAME_ALT
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      DESCRIPTION
,      BANK_BRANCH_TYPE
,      PK_ID
FROM APPS.CE_BANK_BRANCHES_MERGE_V;

Dependencies

[top of page]

APPS.CE_BANK_BRANCHES_MERGE_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PARTY_USG_ASSIGNMENTS

APPS.CE_BANK_BRANCHES_MERGE_V is not referenced by any database object