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

TABLE: FTE.FTE_MESSAGE_ADDRESS

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


Stores Addresses listed in tracking messages


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_MESSAGE_ADDRESS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes PK
ADDR_LINE1 VARCHAR2 (50)
Address Line
ADDR_LINE2 VARCHAR2 (50)
Address Line
ADDR_LINE3 VARCHAR2 (50)
Address Line
ADDR_LINE4 VARCHAR2 (50)
Address Line
ADDR_LINE5 VARCHAR2 (50)
Address Line
ADDR_LINE6 VARCHAR2 (50)
Address Line
ADDR_LINE7 VARCHAR2 (50)
Address Line
ADDR_LINE8 VARCHAR2 (50)
Address Line
ADDR_LINE9 VARCHAR2 (50)
Address Line
ADDR_TYPE VARCHAR2 (30)
Address Type
ADDR_CITY VARCHAR2 (50)
City
ADDR_COUNTY VARCHAR2 (50)
County
ADDR_COUNTRY VARCHAR2 (50)
Country
ADDR_DESCRIPTION VARCHAR2 (1000)
Description
ADDR_POSTAL_CODE VARCHAR2 (10)
Postal or ZIP code
ADDR_REGION VARCHAR2 (50)
Region
ADDR_STATE VARCHAR2 (50)
State or Province
ADDR_TAX_JURISDICTION VARCHAR2 (50)
Tax Jurisdiction
ADDR_URL VARCHAR2 (60)
URL
FAX1 VARCHAR2 (30)
Fax Number
FAX2 VARCHAR2 (30)
Fax Number
FAX3 VARCHAR2 (30)
Fax Number
FAX4 VARCHAR2 (30)
Fax Number
FAX5 VARCHAR2 (30)
Fax Number
FAX6 VARCHAR2 (30)
Fax Number
FAX7 VARCHAR2 (30)
Fax Number
FAX8 VARCHAR2 (30)
Fax Number
FAX9 VARCHAR2 (30)
Fax Number
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 to Transaction ID in headers table
ADDRESS_TO_TABLE VARCHAR2 (30)
Table this Address belongs to
ADDRESS_TO_ID NUMBER
Yes Primary key on foreign table record this address belongs to
Query Text

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


SELECT ID
,      ADDR_LINE1
,      ADDR_LINE2
,      ADDR_LINE3
,      ADDR_LINE4
,      ADDR_LINE5
,      ADDR_LINE6
,      ADDR_LINE7
,      ADDR_LINE8
,      ADDR_LINE9
,      ADDR_TYPE
,      ADDR_CITY
,      ADDR_COUNTY
,      ADDR_COUNTRY
,      ADDR_DESCRIPTION
,      ADDR_POSTAL_CODE
,      ADDR_REGION
,      ADDR_STATE
,      ADDR_TAX_JURISDICTION
,      ADDR_URL
,      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
,      ADDRESS_TO_TABLE
,      ADDRESS_TO_ID
FROM FTE.FTE_MESSAGE_ADDRESS;

Dependencies

[top of page]

FTE.FTE_MESSAGE_ADDRESS does not reference any database object

FTE.FTE_MESSAGE_ADDRESS is referenced by following:

SchemaFTE
ViewFTE_MESSAGE_ADDRESS#