Product: | BIL - Sales Intelligence |
---|---|
Description: | Quantitative measures related to reporting on oportunity performance |
Implementation/DBA Data: | Not implemented in this database |
SELECT BOP.CREATION_DATE
, BOP.CREATED_BY
, BOP.LAST_UPDATE_DATE
, BOP.LAST_UPDATED_BY
, BOP.LAST_UPDATE_LOGIN
, BOP.REQUEST_ID
, BOP.PROGRAM_APPLICATION_ID
, BOP.PROGRAM_ID
, BOP.PROGRAM_UPDATE_DATE
, BOP.LEAD_ID
, BOP.PERIOD_NAME
, BOP.START_DATE
, BOP.END_DATE
, BOP.TERRITORY_ID
, BOP.INTEREST_TYPE_ID
, BOP.PRIMARY_INTEREST_CODE_ID
, BOP.SECONDARY_INTEREST_CODE_ID
, BOP.SALES_CHANNEL_ID
, BOP.SALESREP_ID
, BOP.SALES_GROUP_ID
, BOP.ADDRESS_ID
, BOP.CUSTOMER_ID
, BDC.CUSTOMER_NAME
, BDO.DESCRIPTION
, BOP.INVOICED_AMOUNT
, BOP.OPTY_AMOUNT
, BOP.WIN_PROBABILITY
, BOP.CUST_SATISFACTION_PCT
FROM BIL_OPTY_PERF_SUMM BOP
, BIL_DIMV_CUSTOMERS BDC
, BIL_DIMV_OPTY BDO
WHERE BOP.CUSTOMER_ID = BDC.CUSTOMER_ID
AND BDO.LEAD_ID = BOP.LEAD_ID WITH READ ONLY