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.

[Home] [Help]

View: BIC_OPTY_SUMMARY_V

Product:	BIC - Customer Intelligence (obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASL.LEAD_ID
, ASL.CUSTOMER_ID
, ASL.CREATION_DATE
, ASL.STATUS
, ASL.ORG_ID
, ASL.CHANNEL_CODE
, ASL.LEAD_SOURCE_CODE
, ASL.WIN_PROBABILITY
, ASL.INITIATING_CONTACT_ID
, ASL.SOURCE_PROMOTION_ID
, ASL.TOTAL_AMOUNT
, ASL.DESCRIPTION FROM AS_LEADS_ALL ASL

Columns

Name
LEAD_ID
CUSTOMER_ID
CREATION_DATE
STATUS
ORG_ID
CHANNEL_CODE
LEAD_SOURCE_CODE
WIN_PROBABILITY
INITIATING_CONTACT_ID
SOURCE_PROMOTION_ID
TOTAL_AMOUNT
DESCRIPTION