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: IEO.IEO_LNA_SOURCES

Object Details

Object Name:	IEO_LNA_SOURCES
Object Type:	TABLE
Owner:	IEO
Subobject Name:
Status:	VALID

Instead of capturing the same data repeatedly in the IEU_LNA_RECORDS table, the sources represent a producer of logs or alerts. The sources are updated much less frequently, and are simply associated with the records being emitted to save table space, and speed of emitting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_ID	NUMBER	(10)	Yes	Uniquely identifies a source (emitter) of LNA records.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
FACILITY_GUID	VARCHAR2	(32)	Yes	Globally unique identifier of the emitter.
FACILITY_NAME_MSG_NAME	VARCHAR2	(30)		MSG_ID that can be translated to show emitter name.
FACILITY_RESOURCE_GUID	VARCHAR2	(32)	Yes	Resource in which FACILITY_RESOURCE_MSG_ID can be found.
FACILITY_INSTANCE	VARCHAR2	(512)	Yes	Specific instance of an emitter.
FACILITY_INSTANCE_UID	VARCHAR2	(256)	Yes	Uniquely identifies an instance of an emitter.
IP_ADDRESS	VARCHAR2	(16)	Yes	IP address obtained by emitter by system call.
HOSTNAME	VARCHAR2	(256)	Yes	Hostname obtained by emitter by system call.
OS_USER_NAME	VARCHAR2	(256)	Yes	User name obtained by emitter by calling OS.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			Standard column used by HTML utilities.
LOG_LEVEL	NUMBER		Yes	Log level
MSG_EXPIRATION	NUMBER	(4)		Message expiration

Query Text

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


SELECT SOURCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FACILITY_GUID
,      FACILITY_NAME_MSG_NAME
,      FACILITY_RESOURCE_GUID
,      FACILITY_INSTANCE
,      FACILITY_INSTANCE_UID
,      IP_ADDRESS
,      HOSTNAME
,      OS_USER_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      LOG_LEVEL
,      MSG_EXPIRATION
FROM IEO.IEO_LNA_SOURCES;

Dependencies

[top of page]

IEO.IEO_LNA_SOURCES does not reference any database object

IEO.IEO_LNA_SOURCES is referenced by following:

APPS: IEO_LNA_SOURCES; IEO_LNA_SOURCES_TRG1