[Home] [Help]
| Product: | ASF - Sales Online |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AIF.FORECAST_ID
, AIF.FORECAST_CATEGORY_ID
, AIF.SALES_GROUP_ID
, AIF.SALESFORCE_ID
, AIF.PERIOD_NAME
, AIF.EMPLOYEE_PERSON_ID
, AIF.CURRENCY_CODE
, AIF.WEIGHTED_PIPELINE_AMOUNT
, AIF.WEIGHTED_PIPELINE_AMOUNT_FLAG
, AIF.PIPELINE_AMOUNT
, AIF.PIPELINE_AMOUNT_FLAG
, AIF.WON_PIPELINE_AMOUNT
, AIF.WON_PIPELINE_AMOUNT_FLAG
, AIF.SUBMISSION_DATE
, AIF.FORECAST_AMOUNT
, AIF.FORECAST_AMOUNT_FLAG
, AIF.WORST_FORECAST_AMOUNT
, AIF.WORST_FORECAST_AMOUNT_FLAG
, AIF.BEST_FORECAST_AMOUNT
, AIF.BEST_FORECAST_AMOUNT_FLAG
, SUM(DECODE(FWS.WORKSHEET_TYPE
, 'OPPORTUNITY'
, DECODE(FWS.STATUS_CODE
, 'SUBMITTED'
, 1
, 0)
, 0)) OPP_COUNT
, SUM(DECODE(FWS.WORKSHEET_TYPE
, 'PRODUCT_CATEGORY'
, DECODE(FWS.STATUS_CODE
, 'SUBMITTED'
, 1
, 0)
, 0)) PROD_COUNT
FROM AS_INTERNAL_FORECASTS AIF
, AS_FORECAST_WORKSHEETS FWS
WHERE AIF.FORECAST_ID = FWS.FORECAST_ID (+) GROUP BY AIF.FORECAST_ID
, AIF.FORECAST_AMOUNT
, AIF.SUBMISSION_DATE
, AIF.FORECAST_AMOUNT_FLAG
, AIF.BEST_FORECAST_AMOUNT
, AIF.BEST_FORECAST_AMOUNT_FLAG
, AIF.WORST_FORECAST_AMOUNT
, AIF.WORST_FORECAST_AMOUNT_FLAG
, AIF.FORECAST_CATEGORY_ID
, AIF.SALES_GROUP_ID
, AIF.SALESFORCE_ID
, AIF.PERIOD_NAME
, AIF.EMPLOYEE_PERSON_ID
, AIF.WEIGHTED_PIPELINE_AMOUNT
, AIF.WEIGHTED_PIPELINE_AMOUNT_FLAG
, AIF.PIPELINE_AMOUNT
, AIF.PIPELINE_AMOUNT_FLAG
, AIF.WON_PIPELINE_AMOUNT
, AIF.CURRENCY_CODE
, AIF.WON_PIPELINE_AMOUNT_FLAG