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_SUMV_SLS_CHNL_PERF

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Qunatitative measures related to reporting on sales performance for sales channels
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BSCP.CREATION_DATE
, BSCP.CREATED_BY
, BSCP.LAST_UPDATE_DATE
, BSCP.LAST_UPDATED_BY
, BSCP.LAST_UPDATE_LOGIN
, BSCP.REQUEST_ID
, BSCP.PROGRAM_APPLICATION_ID
, BSCP.PROGRAM_ID
, BSCP.PROGRAM_UPDATE_DATE
, BSCP.SALES_CHANNEL_ID
, BSCP.PERIOD_NAME
, BSCP.START_DATE
, BSCP.END_DATE
, BSCP.TERRITORY_ID
, BSCP.INTEREST_TYPE_ID
, BSCP.PRIMARY_INTEREST_CODE_ID
, BSCP.SECONDARY_INTEREST_CODE_ID
, BDS.CHANNEL_MEANING
, BSCP.INVOICED_AMOUNT
, BSCP.COGS_AMOUNT
, BSCP.MARGIN
, BSCP.NO_OF_WON_OPTY
, BSCP.NO_OF_CLOSED_OPTY
, BSCP.UNITS_SOLD
, BSCP.CUST_SATISFACTION_PCT
, BSCP.NO_OF_LEADS
, BSCP.NO_OF_ORDERS
FROM BIL_SLS_CHNL_PERF_SUMM BSCP
, BIL_DIMV_SLS_CHANNELS BDS
WHERE BSCP.SALES_CHANNEL_ID = BDS.CHANNEL_LOOKUP_CODE

Columns

Name
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
SALES_CHANNEL_ID
PERIOD_NAME
START_DATE
END_DATE
TERRITORY_ID
INTEREST_TYPE_ID
PRIMARY_INTEREST_CODE_ID
SECONDARY_INTEREST_CODE_ID
SALES_CHANNEL
INVOICED_AMOUNT
COGS_AMOUNT
MARGIN
NO_OF_WON_OPTY
NO_OF_CLOSED_OPTY
UNITS_SOLD
CUST_SATISFACTION_PCT
NO_OF_LEADS
NO_OF_ORDERS