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: OSM.AS_LS_ERRS

Object Details

Object Name:	AS_LS_ERRS
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_LS_ERRS
Subobject Name:
Status:	VALID

For Lead Sharing use

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_LS_ERRS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ERROR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ERROR_ID	NUMBER		Yes	Lead Share Error ID
DIR_FLAG	VARCHAR2	(30)	Yes	Incoming or outgoing Lead
ERROR_STATUS	VARCHAR2	(1)		Has the error been checked by the Admin person for the site? What is the status
ERROR_TYPE_ID	NUMBER			Connection error or database error
ERROR_NUM	NUMBER			Oracle error number
ERROR_CODE	VARCHAR2	(200)		Oracle error code
ERROR_TEXT	VARCHAR2	(4000)		Text of Oracle error
TRANSACTION_ID	NUMBER			Lead Share Transaction ID
LEAD_ID	NUMBER			Lead number to be shared
PARTNER_ID	NUMBER			Unique partner ID
ERROR_CRE_DATE	DATE			Data/Time column

Query Text

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


SELECT ERROR_ID
,      DIR_FLAG
,      ERROR_STATUS
,      ERROR_TYPE_ID
,      ERROR_NUM
,      ERROR_CODE
,      ERROR_TEXT
,      TRANSACTION_ID
,      LEAD_ID
,      PARTNER_ID
,      ERROR_CRE_DATE
FROM OSM.AS_LS_ERRS;

Dependencies

[top of page]

OSM.AS_LS_ERRS does not reference any database object

OSM.AS_LS_ERRS is referenced by following:

OSM: AS_LS_ERRS#