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: IBE.IBE_LEAD_IMPORT_LOG

Object Details

Object Name:	IBE_LEAD_IMPORT_LOG
Object Type:	TABLE
Owner:	IBE
FND Design Data:	IBE.IBE_LEAD_IMPORT_LOG
Subobject Name:
Status:	VALID

This table contains the log information for Leads that are imported.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_LEAD_IMPORT_LOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	Log Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number For Locking
CREATED_BY	NUMBER		Yes	Standard WHO Column.
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column.
BEGIN_DATE	DATE		Yes	Start Date of Import
END_DATE	DATE		Yes	End Date of Import
LEAD_TYPE	VARCHAR2	(12)	Yes	Lead Type ORDER or QUOTE
STATUS	NUMBER		Yes	Import Status: 0 -- Not Active, 1 -- Active - Success, 2 -- Active - Success with Error, -1 -- Active - Error
IMPORT_MODE	VARCHAR2	(15)	Yes	Import Mode: COMPLETE Or INCREMENTAL
ELAPSED_TIME	NUMBER			Time taken for importing Leads
NUM_IMPORTED	NUMBER			Number of Leads Imported.
NUM_FAILED	NUMBER			Number of Leads failed to Import.
NUM_SUCCESS	NUMBER			Number of Successfully imported Leads.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.

Query Text

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


SELECT LOG_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BEGIN_DATE
,      END_DATE
,      LEAD_TYPE
,      STATUS
,      IMPORT_MODE
,      ELAPSED_TIME
,      NUM_IMPORTED
,      NUM_FAILED
,      NUM_SUCCESS
,      SECURITY_GROUP_ID
FROM IBE.IBE_LEAD_IMPORT_LOG;

Dependencies

[top of page]

IBE.IBE_LEAD_IMPORT_LOG does not reference any database object

IBE.IBE_LEAD_IMPORT_LOG is referenced by following:

APPS: IBE_LEAD_IMPORT_LOG