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


VIEW: APPS.CE_BANKS_V

Object Details
Object Name: CE_BANKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_BANKS_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
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
START_DATE DATE
Yes Bank start date
END_DATE DATE

Bank end date
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 (30) Yes Bank institution type (BANK or CLEARINGHOUSE)
DESCRIPTION VARCHAR2 (2000)
PK_ID NUMBER (15) Yes
SITE_ADDRESS_LINE1 VARCHAR2 (240)
SITE_ADDRESS_LINE2 VARCHAR2 (240)
SITE_ADDRESS_LINE3 VARCHAR2 (240)
SITE_ADDRESS_LINE4 VARCHAR2 (240)
SITE_CITY VARCHAR2 (60)
SITE_STATE VARCHAR2 (60)
SITE_COUNTY VARCHAR2 (60)
SITE_ZIP VARCHAR2 (60)
SITE_COUNTRY VARCHAR2 (60)
SITE_PROVINCE VARCHAR2 (60)
SITE_LOCATION_ID NUMBER (15)
TAX_PAYER_ID VARCHAR2 (20)
Query Text

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


SELECT ROW_ID
,      HOME_COUNTRY
,      BANK_PARTY_ID
,      BANK_NAME
,      BANK_NAME_ALT
,      SHORT_BANK_NAME
,      BANK_NUMBER
,      START_DATE
,      END_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      BANK_INSTITUTION_TYPE
,      DESCRIPTION
,      PK_ID
,      SITE_ADDRESS_LINE1
,      SITE_ADDRESS_LINE2
,      SITE_ADDRESS_LINE3
,      SITE_ADDRESS_LINE4
,      SITE_CITY
,      SITE_STATE
,      SITE_COUNTY
,      SITE_ZIP
,      SITE_COUNTRY
,      SITE_PROVINCE
,      SITE_LOCATION_ID
,      TAX_PAYER_ID
FROM APPS.CE_BANKS_V;

Dependencies

[top of page]

APPS.CE_BANKS_V references the following:

SchemaAPPS
SynonymHZ_CODE_ASSIGNMENTS
SynonymHZ_LOCATIONS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
APPS.CE_BANKS_V is referenced by following:

SchemaAPPS
Package BodyCE_VALIDATE_BANKINFO - show dependent code
PL/SQL PackageFUN_NET_ARAP_PKG - show dependent code
Package BodyFUN_NET_ARAP_PKG - show dependent code
Package BodyIBY_DISBURSEMENT_SETUP_PUB - show dependent code
ViewIBY_EXT_BANKS_V
PL/SQL PackageIBY_VALIDATIONSETS_PUB - show dependent code