View: CE_AS_FC_SALES_FCST_V

Product:	CE - Cash Management
Description:	Forecasting source - Oracle Sales
Implementation/DBA Data:	APPS.CE_AS_FC_SALES_FCST_V

View Text

SELECT NVL(LL.TOTAL_AMOUNT
, 0)
, NVL(LL.TOTAL_AMOUNT
, 0)
, LH.CURRENCY_CODE
, LH.DECISION_DATE
, LH.WIN_PROBABILITY
, LH.CHANNEL_CODE
, LH.STATUS
, LH.SALES_STAGE_ID
, LL.ORG_ID
, LH.LEAD_NUMBER
, LL.LEAD_LINE_ID
FROM AS_LEAD_LINES_ALL LL
, AS_LEADS_ALL LH
WHERE LH.STATUS IN ('UPSIDE'
, 'WON'
, 'FORECASTED')
AND LL.LEAD_ID = LH.LEAD_ID
AND (LL.ORG_ID = LH.ORG_ID OR LL.ORG_ID IS NULL)
AND NOT EXISTS (SELECT NULL
FROM AS_QUOTES_ALL
WHERE QUOTE_STATUS = 'ORDERED'
AND LEAD_ID = LH.LEAD_ID)

Columns