[Home] [Help] [Dependency Information]
Object Name: | FTE_MESSAGE_ADDRESS# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
ADDR_LINE1 | VARCHAR2 | (50) | ||
ADDR_LINE2 | VARCHAR2 | (50) | ||
ADDR_LINE3 | VARCHAR2 | (50) | ||
ADDR_LINE4 | VARCHAR2 | (50) | ||
ADDR_LINE5 | VARCHAR2 | (50) | ||
ADDR_LINE6 | VARCHAR2 | (50) | ||
ADDR_LINE7 | VARCHAR2 | (50) | ||
ADDR_LINE8 | VARCHAR2 | (50) | ||
ADDR_LINE9 | VARCHAR2 | (50) | ||
ADDR_TYPE | VARCHAR2 | (30) | ||
ADDR_CITY | VARCHAR2 | (50) | ||
ADDR_COUNTY | VARCHAR2 | (50) | ||
ADDR_COUNTRY | VARCHAR2 | (50) | ||
ADDR_DESCRIPTION | VARCHAR2 | (1000) | ||
ADDR_POSTAL_CODE | VARCHAR2 | (10) | ||
ADDR_REGION | VARCHAR2 | (50) | ||
ADDR_STATE | VARCHAR2 | (50) | ||
ADDR_TAX_JURISDICTION | VARCHAR2 | (50) | ||
ADDR_URL | VARCHAR2 | (60) | ||
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 | |||
ADDRESS_TO_TABLE | VARCHAR2 | (30) | ||
ADDRESS_TO_ID | NUMBER | Yes |
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#;
|
|
|