eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CE.CE_UPGA_BANK_REC

Object Details

Object Name:	CE_UPGA_BANK_REC
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_UPGA_BANK_REC
Subobject Name:
Status:	VALID

This table is an audit table of CE_UPG_BANK_REC. This table stores
organization party information for banks, clearinghouses, bank
branches, and clearinghouse branches

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)		TCA party identifier
CE_UPGRADE_ID	NUMBER	(15)	Yes	CE upgrade identifier
PARENT_UPGRADE_ID	NUMBER	(15)		Parent CE upgrade identifier
BANK_ENTITY_TYPE	VARCHAR2	(30)	Yes	Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
UPGRADE_STATUS	VARCHAR2	(30)		Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID
PRIMARY_FLAG	VARCHAR2	(1)		Flag to indicate if this record is the primary record of the bank or bank branch group
SECONDARY_FLAG	VARCHAR2	(1)		Flag to indicate if this record is the secondary record of the bank or bank branch group
GROUP_ID	NUMBER	(15)		Bank or bank branch group identifier
BANK_OR_BRANCH_NUMBER	VARCHAR2	(60)		Bank number, bank branch number, clearinghouse number, or clearinghouse branch number
BANK_CODE	VARCHAR2	(30)		Bank code
BRANCH_CODE	VARCHAR2	(30)		Branch code
INSTITUTION_TYPE	VARCHAR2	(30)		Institution type
COUNTRY	VARCHAR2	(30)		Country
BRANCH_TYPE	VARCHAR2	(30)		Bank branch type
RFC_CODE	VARCHAR2	(30)		RFC identifier
CREATED_BY_MODULE	VARCHAR2	(150)		Created by module
ORGANIZATION_NAME	VARCHAR2	(360)		Organization name
ORGANIZATION_NAME_PHONETIC	VARCHAR2	(320)		Alternate organization name
KNOWN_AS	VARCHAR2	(240)		Bank or bank branch short name
JGZZ_FISCAL_CODE	VARCHAR2	(20)		Taxpayer identifier
MISSION_STATEMENT	VARCHAR2	(2000)		Description
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descripitive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descripitive flexfield segment column
START_DATE_ACTIVE	DATE			Start date
END_DATE_ACTIVE	DATE			End date
EFT_USER_NUM	VARCHAR2	(30)		EFT user number
CLEARING_HOUSE_ID	NUMBER	(15)		Clearinghouse identifier
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT PARTY_ID
,      CE_UPGRADE_ID
,      PARENT_UPGRADE_ID
,      BANK_ENTITY_TYPE
,      UPGRADE_STATUS
,      PRIMARY_FLAG
,      SECONDARY_FLAG
,      GROUP_ID
,      BANK_OR_BRANCH_NUMBER
,      BANK_CODE
,      BRANCH_CODE
,      INSTITUTION_TYPE
,      COUNTRY
,      BRANCH_TYPE
,      RFC_CODE
,      CREATED_BY_MODULE
,      ORGANIZATION_NAME
,      ORGANIZATION_NAME_PHONETIC
,      KNOWN_AS
,      JGZZ_FISCAL_CODE
,      MISSION_STATEMENT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      EFT_USER_NUM
,      CLEARING_HOUSE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CE.CE_UPGA_BANK_REC;

Dependencies

[top of page]

CE.CE_UPGA_BANK_REC does not reference any database object

CE.CE_UPGA_BANK_REC is referenced by following:

APPS: CE_UPGA_BANK_REC