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

TABLE: CE.CE_UPG_PERSON_REC

Object Details
Object Name: CE_UPG_PERSON_REC
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_UPG_PERSON_REC
Subobject Name:
Status: VALID


This table stores person party information for bank branch contact or bank account contact


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_UPG_PERSON_REC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCE_UPGRADE_ID
ColumnBANK_ENTITY_TYPE
Columns
Name Datatype Length Mandatory Comments
BANK_ENTITY_TYPE VARCHAR2 (30) Yes Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT
CE_UPGRADE_ID NUMBER (15) Yes CE upgrade identifier
PERSON_PARTY_ID NUMBER (15)
TCA person party identifier
PERSON_FIRST_NAME VARCHAR2 (150)
First name of the person
PERSON_MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
PERSON_LAST_NAME VARCHAR2 (150)
Last name of the person
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Salutary introduction, such as Mr.
CREATED_BY_MODULE VARCHAR2 (150)
Created by module
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 BANK_ENTITY_TYPE
,      CE_UPGRADE_ID
,      PERSON_PARTY_ID
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_PRE_NAME_ADJUNCT
,      CREATED_BY_MODULE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CE.CE_UPG_PERSON_REC;

Dependencies

[top of page]

CE.CE_UPG_PERSON_REC does not reference any database object

CE.CE_UPG_PERSON_REC is referenced by following:

SchemaAPPS
SynonymCE_UPG_PERSON_REC