RS_FCAST_SR_VW

(SQL View)
 Index Back

Sales Forecast View

Input view for Sales Forecast ACE report.

SELECT A.FORECAST_ID , A.TIMEFRAME_PERIOD , A.FORECAST_CATEGORY FROM PS_RSF_FCAST A , PS_RSF_FCAST_USER B , PS_RSF_FCAST_DTL C , PS_RSF_ACC_MGR_VW D , PS_RT_DFLT_VW G , PS_INSTALLATION H , PS_RSF_OPR_DEF_VW E , PS_RS_FCAST_INST J WHERE E.OPRID = J.OPRID AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PS_RT_DFLT_VW G_ED WHERE G.FROM_CUR = G_ED.FROM_CUR AND G.TO_CUR = G_ED.TO_CUR AND G.RT_TYPE = G_ED.RT_TYPE AND G_ED.EFFDT <= %CurrentDateIn) AND A.FORECAST_ID = B.FORECAST_ID AND A.TIMEFRAME_PERIOD = B.TIMEFRAME_PERIOD AND A.FORECAST_CATEGORY = B.FORECAST_CATEGORY AND B.FORECAST_ID = C.FORECAST_ID AND B.TIMEFRAME_PERIOD = C.TIMEFRAME_PERIOD AND B.FORECAST_CATEGORY = C.FORECAST_CATEGORY AND B.PERSON_ID = C.PERSON_ID AND C.PERSON_ID_ADJUSTBY = D.PERSON_ID AND H.DEF_CUR_RT_TYPE = G.RT_TYPE AND G.FROM_CUR = C.FROM_CUR AND G.TO_CUR = J.TO_CUR AND D.PERSON_ID_MANAGER = E.PERSON_ID AND A.TIMEFRAME_PERIOD = J.TIMEFRAME_PERIOD AND A.FORECAST_ID = J.FORECAST_ID AND A.FORECAST_CATEGORY = J.FORECAST_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FORECAST_ID Character(15) VARCHAR2(15) NOT NULL Forecast Name

Prompt Table: RSF_FCAST_ID

2 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

Prompt Table: %EDITTABLE

3 FORECAST_CATEGORY Character(1) VARCHAR2(1) NOT NULL Forecast Category
R=Revenue Forecast
S=Shadow Forecast