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]

TABLE: GMA.SY_ADDR_MST

Object Details

Object Name:	SY_ADDR_MST
Object Type:	TABLE
Owner:	GMA
FND Design Data:	GMA.SY_ADDR_MST
Subobject Name:
Status:	VALID

OPM Address master. Table which stores addresses for all Oracle Process
Manufacturing applications entities.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ADDR_ID	NUMBER	(10)	Yes	Surrogate id uniquely identifying an address.
ADDR1	VARCHAR2	(70)		First line of the address.
ADDR2	VARCHAR2	(70)		Second line of the address.
ADDR3	VARCHAR2	(70)		Third line of the address.
ADDR4	VARCHAR2	(70)		Fourth line of the address.
STATE_CODE	VARCHAR2	(4)		State code of the address.
COUNTRY_CODE	VARCHAR2	(4)		Country code of the address.
POSTAL_CODE	VARCHAR2	(16)		Postal code of the address.
PSEUDO_KEY	VARCHAR2	(70)	Yes	Allows recreation of link to originating record in case of table corruption.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
COMMENTS	VARCHAR2	(40)		Comment Field - unused
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
ORA_ADDR4	VARCHAR2	(70)		Address Line used for Oracle Financials Integration
PROVINCE	VARCHAR2	(70)		Province code
COUNTY	VARCHAR2	(70)		County code
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column

Query Text

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


SELECT ADDR_ID
,      ADDR1
,      ADDR2
,      ADDR3
,      ADDR4
,      STATE_CODE
,      COUNTRY_CODE
,      POSTAL_CODE
,      PSEUDO_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      COMMENTS
,      DELETE_MARK
,      TRANS_CNT
,      ORA_ADDR4
,      PROVINCE
,      COUNTY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMA.SY_ADDR_MST;

Dependencies

[top of page]

GMA.SY_ADDR_MST does not reference any database object

GMA.SY_ADDR_MST is referenced by following:

APPS: SY_ADDR_MST