eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: FTE.FTE_MESSAGE_ADDRESS#

Object Details

Object Name:	FTE_MESSAGE_ADDRESS#
Object Type:	VIEW
Owner:	FTE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

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

FTE: FTE_MESSAGE_ADDRESS

FTE.FTE_MESSAGE_ADDRESS# is referenced by following:

APPS: FTE_MESSAGE_ADDRESS