[Home] [Help] [Dependency Information]
Object Name: | CE_UPG_CONT_POINT_REC |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_UPG_CONT_POINT_REC |
Subobject Name: | |
Status: | VALID |
This table stores contact points information for bank EDI, email, bank branch EFT, contact phone and fax
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_UPG_CONT_POINT_REC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CE_UPGRADE_ID
BANK_ENTITY_TYPE CONTACT_POINT_TYPE PHONE_LINE_TYPE |
CE_UPG_CONT_POINT_REC_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPGRADE_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CE_UPGRADE_ID | NUMBER | (15) | Yes | CE upgrade identifier |
UPGRADE_STATUS | VARCHAR2 | (30) | Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID | |
BANK_ENTITY_TYPE | VARCHAR2 | (30) | Yes | Bank entity type. Possible values are BANK, BRANCH, and ACCOUNT |
CONTACT_POINT_TYPE | VARCHAR2 | (30) | Yes | Contact point type |
PHONE_LINE_TYPE | VARCHAR2 | (30) | Lookup code for the type of phone line | |
OWNER_TABLE_NAME | VARCHAR2 | (30) | Table that stores the owner of the contact point | |
OWNER_TABLE_ID | NUMBER | (15) | Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Created by module | |
EDI_ID_NUMBER | VARCHAR2 | (30) | EDI trading partner number | |
EDI_TP_HEADER_ID | NUMBER | (15) | EDI trading partner header identifier | |
EDI_ECE_TP_LOCATION_CODE | VARCHAR2 | (60) | EDI trading partner location code | |
EFT_TRANSMISSION_PROGRAM_ID | NUMBER | (15) | Trasmission program identifier | |
EFT_PRINTING_PROGRAM_ID | NUMBER | (15) | Printing program identifier | |
EFT_SWIFT_CODE | VARCHAR2 | (30) | EFT swift code | |
PHONE_AREA_CODE | VARCHAR2 | (10) | The area code within a country code | |
PHONE_NUMBER | VARCHAR2 | (40) | Phone number | |
ORG_PRIMARY_PHONE_FLAG | VARCHAR2 | (1) | Organization primary phone line flag (Y or N) | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address of the contact point | |
CONTACT_POINT_ID | NUMBER | (15) | TCA contact point 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 | |
EFT_USER_NUM | VARCHAR2 | (30) | Eft user number |
Cut, paste (and edit) the following text to query this object:
SELECT CE_UPGRADE_ID
, UPGRADE_STATUS
, BANK_ENTITY_TYPE
, CONTACT_POINT_TYPE
, PHONE_LINE_TYPE
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, CREATED_BY_MODULE
, EDI_ID_NUMBER
, EDI_TP_HEADER_ID
, EDI_ECE_TP_LOCATION_CODE
, EFT_TRANSMISSION_PROGRAM_ID
, EFT_PRINTING_PROGRAM_ID
, EFT_SWIFT_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, ORG_PRIMARY_PHONE_FLAG
, EMAIL_ADDRESS
, CONTACT_POINT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, EFT_USER_NUM
FROM CE.CE_UPG_CONT_POINT_REC;
CE.CE_UPG_CONT_POINT_REC does not reference any database object
CE.CE_UPG_CONT_POINT_REC is referenced by following:
|
|
|