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_OPPWS_HISTY_V

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

View Text

SELECT OW.LAST_UPDATE_DATE
, ASF.SOURCE_FIRST_NAME
, ASF.SOURCE_LAST_NAME
, ASF.SOURCE_NUMBER
, OW.FORECAST_WORKSHEET_ID
, OW.OPP_WORKSHEET_LINE_ID
, OW.DECISION_DATE
, OW.SALES_STAGE_ID
, STAGE.NAME
, OW.WIN_PROBABILITY
, OW.STATUS
, STATUS.MEANING
, OW.CURRENCY_CODE
, OW.WEIGHTED_AMOUNT_FLAG
, OW.WEIGHTED_AMOUNT
, OW.AMOUNT_FLAG
, OW.AMOUNT
, OW.WORST_FORECAST_AMOUNT_FLAG
, OW.WORST_FORECAST_AMOUNT
, OW.FORECAST_AMOUNT_FLAG
, OW.FORECAST_AMOUNT
, OW.BEST_FORECAST_AMOUNT_FLAG
, OW.BEST_FORECAST_AMOUNT
, OW.CUSTOMER_ID
, HZP.PARTY_NAME
, HZP.PARTY_ID
, OW.LEAD_ID
, LEAD.DESCRIPTION
, OW.SALES_GROUP_ID
, OW.PERIOD_NAME
, OW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, OW.CREDIT_TYPE_ID
, CT.NAME
, OW.SALESFORCE_ID
FROM AS_LEADS_ALL LEAD
, HZ_PARTIES HZP
, AS_OPP_WORKSHEET_LINES OW
, AS_STATUSES_VL STATUS
, AS_SALES_STAGES_ALL_VL STAGE
, AS_FC_SALESFORCE_V ASF
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE OW.STATUS_CODE = 'SUBMITTED'
AND OW.STATUS = STATUS.STATUS_CODE
AND OW.SALES_STAGE_ID = STAGE.SALES_STAGE_ID(+)
AND OW.SALESFORCE_ID = ASF.SALESFORCE_ID
AND OW.SALES_GROUP_ID = ASF.SALES_GROUP_ID
AND OW.CUSTOMER_ID = HZP.PARTY_ID
AND OW.LEAD_ID = LEAD.LEAD_ID
AND OW.FORECAST_CATEGORY_ID = FC.FORECAST_CATEGORY_ID
AND OW.CREDIT_TYPE_ID = CT.SALES_CREDIT_TYPE_ID UNION SELECT OW.LAST_UPDATE_DATE
, PA.FIRST_NAME
, PA.LAST_NAME
, PA.EMPLOYEE_NUMBER
, OW.FORECAST_WORKSHEET_ID
, OW.OPP_WORKSHEET_LINE_ID
, OW.DECISION_DATE
, OW.SALES_STAGE_ID
, STAGE.NAME
, OW.WIN_PROBABILITY
, OW.STATUS
, STATUS.MEANING
, OW.CURRENCY_CODE
, OW.WEIGHTED_AMOUNT_FLAG
, OW.WEIGHTED_AMOUNT
, OW.AMOUNT_FLAG
, OW.AMOUNT
, OW.WORST_FORECAST_AMOUNT_FLAG
, OW.WORST_FORECAST_AMOUNT
, OW.FORECAST_AMOUNT_FLAG
, OW.FORECAST_AMOUNT
, OW.BEST_FORECAST_AMOUNT_FLAG
, OW.BEST_FORECAST_AMOUNT
, OW.CUSTOMER_ID
, HZP.PARTY_NAME
, HZP.PARTY_ID
, OW.LEAD_ID
, LEAD.DESCRIPTION
, OW.SALES_GROUP_ID
, OW.PERIOD_NAME
, OW.FORECAST_CATEGORY_ID
, FC.FORECAST_CATEGORY_NAME
, OW.CREDIT_TYPE_ID
, CT.NAME
, OW.SALESFORCE_ID
FROM AS_LEADS_ALL LEAD
, HZ_PARTIES HZP
, AS_OPP_WORKSHEET_LINES OW
, AS_STATUSES_VL STATUS
, AS_SALES_STAGES_ALL_VL STAGE
, PER_PEOPLE_X PA
, AS_FC_SALES_GROUPS_V ASG
, AS_FORECAST_CATEGORIES FC
, ASO_I_SALES_CREDIT_TYPES_V CT
WHERE OW.STATUS_CODE = 'SUBMITTED'
AND OW.STATUS = STATUS.STATUS_CODE
AND OW.SALES_STAGE_ID = STAGE.SALES_STAGE_ID(+)
AND OW.SALESFORCE_ID IS NULL
AND OW.SALES_GROUP_ID = ASG.SALES_GROUP_ID
AND ASG.MANAGER_PERSON_ID = PA.PERSON_ID
AND OW.CUSTOMER_ID = HZP.PARTY_ID
AND OW.LEAD_ID = LEAD.LEAD_ID
AND OW.FORECAST_CATEGORY_ID = FC.FORECAST_CATEGORY_ID
AND OW.CREDIT_TYPE_ID = CT.SALES_CREDIT_TYPE_ID

Columns

Name
LAST_UPDATE_DATE
SOURCE_FIRST_NAME
SOURCE_LAST_NAME
SOURCE_NUMBER
FORECAST_WORKSHEET_ID
OPP_WORKSHEET_LINE_ID
DECISION_DATE
SALES_STAGE_ID
STAGE_NAME
WIN_PROBABILITY
STATUS
STATUS_MEANING
CURRENCY_CODE
WEIGHTED_AMOUNT_FLAG
WEIGHTED_AMOUNT
AMOUNT_FLAG
AMOUNT
WORST_FORECAST_AMOUNT_FLAG
WORST_FORECAST_AMOUNT
FORECAST_AMOUNT_FLAG
FORECAST_AMOUNT
BEST_FORECAST_AMOUNT_FLAG
BEST_FORECAST_AMOUNT
CUSTOMER_ID
PARTY_NAME
PARTY_ID
LEAD_ID
LEAD_DESCRIPTION
SALES_GROUP_ID
PERIOD_NAME
FORECAST_CATEGORY_ID
FORECAST_CATEGORY_NAME
CREDIT_TYPE_ID
CREDIT_TYPE_NAME
SALESFORCE_ID