[Home] [Help]
| Product: | BIL - Sales Intelligence (Obsolete) |
|---|---|
| Description: | Quantitative measures related to reporting on product sales cycle and won/lost opportunites |
| Implementation/DBA Data: | Not implemented in this database |
SELECT BPSW.CREATION_DATE
, BPSW.CREATED_BY
, BPSW.LAST_UPDATE_DATE
, BPSW.LAST_UPDATED_BY
, BPSW.LAST_UPDATE_LOGIN
, BPSW.REQUEST_ID
, BPSW.PROGRAM_APPLICATION_ID
, BPSW.PROGRAM_ID
, BPSW.PROGRAM_UPDATE_DATE
, BPSW.PERIOD_NAME
, BPSW.START_DATE
, BPSW.END_DATE
, BPSW.TERRITORY_ID
, BDTR.NAME
, BPSW.INTEREST_TYPE_ID
, BPSW.PRIMARY_INTEREST_CODE_ID
, BPSW.SECONDARY_INTEREST_CODE_ID
, BPSW.SALESREP_ID
, BDS.FULL_NAME
, BDS.JOB_FK
, BPSW.SALES_GROUP_ID
, BPSW.SALES_CHANNEL_ID
, BDSC.CHANNEL_MEANING
, BDT.INTEREST_TYPE
, PBDC.INTEREST_CODE
, SBDC.INTEREST_CODE
, BPSW.INVOICED_AMOUNT
, BPSW.COGS_AMOUNT
, BPSW.MARGIN
, BPSW.EXPECTED_REVENUE
, BPSW.SALES_CYCLE
, BPSW.UNITS_SOLD
, BPSW.NO_OF_WON_OPTY
, BPSW.NO_OF_LOSSES
, BPSW.NO_OF_CLOSED_OPTY
FROM BIL_PROD_SCT_WL_SUMM BPSW
, BIL_DIMV_INTEREST_TYPES BDT
, BIL_DIMV_INTEREST_CODES PBDC
, BIL_DIMV_INTEREST_CODES SBDC
, BIL_DIMV_SALESFORCE BDS
, BIL_DIMV_TERRITORIES BDTR
, BIL_DIMV_SLS_CHANNELS BDSC
WHERE BPSW.INTEREST_TYPE_ID = BDT.INTEREST_TYPE_PK AND BPSW.PRIMARY_INTEREST_CODE_ID = PBDC.INTEREST_CODE_PK AND BPSW.SECONDARY_INTEREST_CODE_ID = SBDC.INTEREST_CODE_PK
AND BPSW.SALESREP_ID = BDS.SALESFORCE_PK
AND BPSW.TERRITORY_ID = BDTR.TERRITORY_PK
AND BDSC.CHANNEL_LOOKUP_CODE = BPSW.SALES_CHANNEL_ID WITH READ ONLY