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: BIL_FCTV_SALES_LEADS

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Quantitative measures related to sales leads
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASL.SALES_LEAD_ID
, ASLL.SALES_LEAD_LINE_ID
, ASL.CUSTOMER_ID
, ASL.ADDRESS_ID
, ACC.SALESFORCE_ID
, ACC.SALES_GROUP_ID
, ASL.ASSIGN_TO_PERSON_ID
, ASL.CHANNEL_CODE
, ASLL.INTEREST_TYPE_ID
, ASLL.PRIMARY_INTEREST_CODE_ID
, ASLL.SECONDARY_INTEREST_CODE_ID
, ASLL.INVENTORY_ITEM_ID
, ATA.TERRITORY_ID
, ASL.CREATION_DATE
, ASL.STATUS_CODE
FROM AS_SALES_LEADS ASL
, AS_SALES_LEAD_LINES ASLL
, AS_ACCESSES_ALL ACC
, AS_TERRITORY_ACCESSES ATA
WHERE ASL.SALES_LEAD_ID = ASLL.SALES_LEAD_ID
AND ASLL.SALES_LEAD_ID = ACC.SALES_LEAD_ID
AND ACC.ACCESS_ID = ATA.ACCESS_ID WITH READ ONLY

Columns

Name
SALES_LEAD_ID
SALES_LEAD_LINE_ID
CUSTOMER_FK
ADDRESS_FK
SALESFORCE_FK
SALES_GROUP_FK
ASSIGN_TO_PERSON_FK
CHANNEL_FK
INTEREST_TYPE_FK
PRIMARY_INTEREST_CODE_FK
SECONDARY_INTEREST_CODE_FK
INVENTORY_ITEM_FK
TERRITORY_FK
CREATION_DATE
STATUS_CODE