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

TABLE: FTE.FTE_MESSAGE_CONTACT

Object Details
Object Name: FTE_MESSAGE_CONTACT
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_MESSAGE_CONTACT
Subobject Name:
Status: VALID


This stores the contact portion of the showshipstatus message


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_MESSAGE_CONTACT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTACT_ID
FTE_MESSAGE_CONTACT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
CONTACT_ID NUMBER
Yes Primary Key
PARTNER_ID NUMBER

FK to Partners
NAME1 VARCHAR2 (50)
Name
NAME2 VARCHAR2 (50)
Name
NAME3 VARCHAR2 (50)
Name
NAME4 VARCHAR2 (50)
Name
NAME5 VARCHAR2 (50)
name
NAME6 VARCHAR2 (50)
Name
NAME7 VARCHAR2 (50)
Name
NAME8 VARCHAR2 (50)
Name
NAME9 VARCHAR2 (50)
Name
CONTACT_TYPE VARCHAR2 (30)
Contact Type
DESCRIPTION VARCHAR2 (100)
Description
EMAIL VARCHAR2 (50)
Email Address
FAX1 VARCHAR2 (30)
Fax
FAX2 VARCHAR2 (30)
Fax
FAX3 VARCHAR2 (30)
Fax
FAX4 VARCHAR2 (30)
Fax
FAX5 VARCHAR2 (30)
Fax
FAX6 VARCHAR2 (30)
Fax
FAX7 VARCHAR2 (30)
Fax
FAX8 VARCHAR2 (30)
Fax
FAX9 VARCHAR2 (30)
Fax
TELEPHONE1 VARCHAR2 (30)
Telephone
TELEPHONE2 VARCHAR2 (30)
Telephone
TELEPHONE3 VARCHAR2 (30)
Telephone
TELEPHONE4 VARCHAR2 (30)
Telephone
TELEPHONE5 VARCHAR2 (30)
Telephone
TELEPHONE6 VARCHAR2 (30)
Telephone
TELEPHONE7 VARCHAR2 (30)
Telephone
TELEPHONE8 VARCHAR2 (30)
Telephone
TELEPHONE9 VARCHAR2 (30)
Telephone
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

FK reference to Transaction id in headers Table
Query Text

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


SELECT CONTACT_ID
,      PARTNER_ID
,      NAME1
,      NAME2
,      NAME3
,      NAME4
,      NAME5
,      NAME6
,      NAME7
,      NAME8
,      NAME9
,      CONTACT_TYPE
,      DESCRIPTION
,      EMAIL
,      FAX1
,      FAX2
,      FAX3
,      FAX4
,      FAX5
,      FAX6
,      FAX7
,      FAX8
,      FAX9
,      TELEPHONE1
,      TELEPHONE2
,      TELEPHONE3
,      TELEPHONE4
,      TELEPHONE5
,      TELEPHONE6
,      TELEPHONE7
,      TELEPHONE8
,      TELEPHONE9
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANSACTION_ID
FROM FTE.FTE_MESSAGE_CONTACT;

Dependencies

[top of page]

FTE.FTE_MESSAGE_CONTACT does not reference any database object

FTE.FTE_MESSAGE_CONTACT is referenced by following:

SchemaAPPS
SynonymFTE_MESSAGE_CONTACT