[Home] [Help] [Dependency Information]
Object Name: | FTE_MESSAGE_ADDRESS |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_MESSAGE_ADDRESS |
Subobject Name: | |
Status: | VALID |
Stores Addresses listed in tracking messages
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_MESSAGE_ADDRESS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
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 |
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;
FTE.FTE_MESSAGE_ADDRESS does not reference any database object
FTE.FTE_MESSAGE_ADDRESS is referenced by following:
|
|
|