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: APPS.SY_ADDR_MST_VW1

Object Details

Object Name:	SY_ADDR_MST_VW1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMA.SY_ADDR_MST_VW1
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View of ADDR_ID + first two lines of the address

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADDR_ID	NUMBER	(10)	Yes	Surrogate id uniquely identifying an address.
ADDR_DISPLAY1	VARCHAR2	(70)		First line of the address.
ADDR_DISPLAY2	VARCHAR2	(70)		Second line of the address.

Query Text

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


SELECT ADDR_ID
,      ADDR_DISPLAY1
,      ADDR_DISPLAY2
FROM APPS.SY_ADDR_MST_VW1;

Dependencies

[top of page]

APPS.SY_ADDR_MST_VW1 references the following:

APPS: SY_ADDR_MST

APPS.SY_ADDR_MST_VW1 is not referenced by any database object