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: BIM.BIM_I_LEAD_FACTS_STG

Object Details

Object Name:	BIM_I_LEAD_FACTS_STG
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Staging table for lead facts

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
LEAD_ID	NUMBER		Sales Lead ID
LEAD_LINE_ID	NUMBER		Sales Lead Line ID
LEAD_CREATION_DATE	DATE		Lead Creation Date
LEAD_TOUCHED_DATE	DATE		Lead Touched Date
LEAD_CONVERTED_DATE	DATE		Lead Converted Date
LEAD_DEAD_DATE	DATE		Lead Dead Date
LEAD_CLOSED_DATE	DATE		Lead Closed Date
TRANSACTION_CREATE_DATE	DATE		Transaction Create Date
GROUP_ID	NUMBER		Sales Group ID
RESOURCE_ID	NUMBER		Sales Rep Resource ID
LEAD_RANK_ID	NUMBER		Lead Rank ID
LEAD_SOURCE	VARCHAR2	(30)	Lead Source
LEAD_STATUS	VARCHAR2	(30)	Lead Status
LEAD_COUNTRY	VARCHAR2	(30)	Lead Country
SOURCE_CODE_ID	NUMBER		Source Code ID
INTEREST_TYPE_ID	NUMBER		Interest type ID
PRIMARY_INTEREST_CODE_ID	NUMBER		Primary Interest Code ID
SECONDARY_INTEREST_CODE_ID	NUMBER		Secondary Interest Code ID
ITEM_ID	NUMBER		Item ID
ORGANIZATION_ID	NUMBER		Organization ID
PRODUCT_CATEGORY_ID	NUMBER		Product Category ID
QUALIFIED_FLAG	VARCHAR2	(1)	Qualified Flag
ACCEPT_FLAG	VARCHAR2	(1)	Accept Flag
CHANNEL_CODE	VARCHAR2	(30)	Channel Code
CLOSE_REASON	VARCHAR2	(30)	Close Reason
CUST_CATEGORY	VARCHAR2	(30)	Customer Category
CUSTOMER_FLAG	VARCHAR2	(1)	Customer Flag
CUSTOMER_ID	NUMBER		Customer ID
SOURCE_PRIMARY_REFERENCE	VARCHAR2	(240)	Source Primary Reference
SOURCE_SECONDARY_REFERENCE	VARCHAR2	(240)	Source Secondary Reference
LEAD_AMOUNT	NUMBER		Lead Amount
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
FROM_CURRENCY	VARCHAR2	(15)	From Currency
CONVERSION_RATE	NUMBER	(24)	Conversion Rate
STATUS_OPEN_FLAG	VARCHAR2	(1)	Status Open Flag
LEAD_RANK_SCORE	NUMBER		Lead Rank Score
EXPIRATION_DATE	DATE		Expiration Date
LEAD_NAME	VARCHAR2	(2000)	Lead Description

Query Text

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


SELECT LEAD_ID
,      LEAD_LINE_ID
,      LEAD_CREATION_DATE
,      LEAD_TOUCHED_DATE
,      LEAD_CONVERTED_DATE
,      LEAD_DEAD_DATE
,      LEAD_CLOSED_DATE
,      TRANSACTION_CREATE_DATE
,      GROUP_ID
,      RESOURCE_ID
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_STATUS
,      LEAD_COUNTRY
,      SOURCE_CODE_ID
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      PRODUCT_CATEGORY_ID
,      QUALIFIED_FLAG
,      ACCEPT_FLAG
,      CHANNEL_CODE
,      CLOSE_REASON
,      CUST_CATEGORY
,      CUSTOMER_FLAG
,      CUSTOMER_ID
,      SOURCE_PRIMARY_REFERENCE
,      SOURCE_SECONDARY_REFERENCE
,      LEAD_AMOUNT
,      CURRENCY_CODE
,      FROM_CURRENCY
,      CONVERSION_RATE
,      STATUS_OPEN_FLAG
,      LEAD_RANK_SCORE
,      EXPIRATION_DATE
,      LEAD_NAME
FROM BIM.BIM_I_LEAD_FACTS_STG;

Dependencies

[top of page]

BIM.BIM_I_LEAD_FACTS_STG does not reference any database object

BIM.BIM_I_LEAD_FACTS_STG is referenced by following:

APPS: BIM_I_LEAD_FACTS_STG