Product: | BIL - Sales Intelligence |
---|---|
Description: | Qunatitative measures related to reporting on sales performance for sales channels |
Implementation/DBA Data: | Not implemented in this database |
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