eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_AS_FC_SALES_FCST_V

Source

View Text - Preformatted


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', 'FORECAST') 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)

View Text - HTML Formatted

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'
, 'FORECAST')
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)