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.

[Home] [Help]

View: ASF_FORECAST_PRDWS_HISTY_V

Product:	ASF - Sales Online
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PW.FST_SALES_CATEGORY_ID
, PW.INTEREST_TYPE_ID
, PW.LAST_UPDATE_DATE
, PW.PROD_WORKSHEET_LINE_ID
, PW.FORECAST_WORKSHEET_ID
, PW.LAST_UPDATED_BY
, PW.CURRENCY_CODE
, PW.WEIGHTED_PIPELINE_AMOUNT_FLAG
, PW.WEIGHTED_PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT
, PW.WORST_FORECAST_AMOUNT_FLAG
, PW.WORST_FORECAST_AMOUNT
, PW.FORECAST_AMOUNT_FLAG
, PW.FORECAST_AMOUNT
, PW.BEST_FORECAST_AMOUNT_FLAG
, PW.BEST_FORECAST_AMOUNT
, PW.PERIOD_NAME
, RES.SOURCE_NAME FULLNAME
, PW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, PW.CREDIT_TYPE_ID
, CT.NAME
, PW.SALESFORCE_ID
FROM AS_PROD_WORKSHEET_LINES PW
, JTF_RS_RESOURCE_EXTNS RES
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE PW.STATUS_CODE = 'SUBMITTED'
AND RES.RESOURCE_ID = PW.SALESFORCE_ID
AND PW.FORECAST_CATEGORY_ID=FC.FORECAST_CATEGORY_ID
AND PW.CREDIT_TYPE_ID=CT.SALES_CREDIT_TYPE_ID UNION ALL SELECT PW.FST_SALES_CATEGORY_ID
, PW.INTEREST_TYPE_ID
, PW.LAST_UPDATE_DATE
, PW.PROD_WORKSHEET_LINE_ID
, PW.FORECAST_WORKSHEET_ID
, PW.LAST_UPDATED_BY
, PW.CURRENCY_CODE
, PW.WEIGHTED_PIPELINE_AMOUNT_FLAG
, PW.WEIGHTED_PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT
, PW.PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT_FLAG
, PW.WON_PIPELINE_AMOUNT
, PW.WORST_FORECAST_AMOUNT_FLAG
, PW.WORST_FORECAST_AMOUNT
, PW.FORECAST_AMOUNT_FLAG
, PW.FORECAST_AMOUNT
, PW.BEST_FORECAST_AMOUNT_FLAG
, PW.BEST_FORECAST_AMOUNT
, PW.PERIOD_NAME
, GTL.GROUP_NAME FULLNAME
, PW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, PW.CREDIT_TYPE_ID
, CT.NAME
, PW.SALESFORCE_ID
FROM AS_PROD_WORKSHEET_LINES PW
, JTF_RS_GROUPS_TL GTL
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE PW.STATUS_CODE = 'SUBMITTED'
AND PW.SALESFORCE_ID IS NULL
AND GTL.GROUP_ID = PW.SALES_GROUP_ID
AND GTL.LANGUAGE = USERENV('LANG')
AND PW.FORECAST_CATEGORY_ID=FC.FORECAST_CATEGORY_ID
AND PW.CREDIT_TYPE_ID=CT.SALES_CREDIT_TYPE_ID

Columns

Name
FST_SALES_CATEGORY_ID
INTEREST_TYPE_ID
LAST_UPDATE_DATE
PROD_WORKSHEET_LINE_ID
FORECAST_WORKSHEET_ID
LAST_UPDATED_BY
CURRENCY_CODE
WEIGHTED_PIPELINE_AMOUNT_FLAG
WEIGHTED_PIPELINE_AMOUNT
PIPELINE_AMOUNT
PIPELINE_AMOUNT_FLAG
WON_PIPELINE_AMOUNT_FLAG
WON_PIPELINE_AMOUNT
WORST_FORECAST_AMOUNT_FLAG
WORST_FORECAST_AMOUNT
FORECAST_AMOUNT_FLAG
FORECAST_AMOUNT
BEST_FORECAST_AMOUNT_FLAG
BEST_FORECAST_AMOUNT
PERIOD_NAME
FULLNAME
FORECAST_CATEGORY_ID
FORECAST_CATEGORY_NAME
CREDIT_TYPE_ID
CREDIT_TYPE_NAME
SALESFORCE_ID