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

VIEW: FTE.FTE_MESSAGE_CONTACT#

Object Details
Object Name: FTE_MESSAGE_CONTACT#
Object Type: VIEW
Owner: FTE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTACT_ID NUMBER
Yes
PARTNER_ID NUMBER

NAME1 VARCHAR2 (50)
NAME2 VARCHAR2 (50)
NAME3 VARCHAR2 (50)
NAME4 VARCHAR2 (50)
NAME5 VARCHAR2 (50)
NAME6 VARCHAR2 (50)
NAME7 VARCHAR2 (50)
NAME8 VARCHAR2 (50)
NAME9 VARCHAR2 (50)
CONTACT_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (100)
EMAIL VARCHAR2 (50)
FAX1 VARCHAR2 (30)
FAX2 VARCHAR2 (30)
FAX3 VARCHAR2 (30)
FAX4 VARCHAR2 (30)
FAX5 VARCHAR2 (30)
FAX6 VARCHAR2 (30)
FAX7 VARCHAR2 (30)
FAX8 VARCHAR2 (30)
FAX9 VARCHAR2 (30)
TELEPHONE1 VARCHAR2 (30)
TELEPHONE2 VARCHAR2 (30)
TELEPHONE3 VARCHAR2 (30)
TELEPHONE4 VARCHAR2 (30)
TELEPHONE5 VARCHAR2 (30)
TELEPHONE6 VARCHAR2 (30)
TELEPHONE7 VARCHAR2 (30)
TELEPHONE8 VARCHAR2 (30)
TELEPHONE9 VARCHAR2 (30)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

TRANSACTION_ID NUMBER

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# references the following:

SchemaFTE
TableFTE_MESSAGE_CONTACT
FTE.FTE_MESSAGE_CONTACT# is referenced by following:

SchemaAPPS
SynonymFTE_MESSAGE_CONTACT