|
SELECT DISTINCT(B.OPRID ) , A.DP_CONFIGVIEW , A.DP_CONFIGLEVEL , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION , E.DP_ITEMCODE , E.DP_LOCATION , E.DP_UD01 , E.DP_UD02 , E.DP_UD03 , E.DP_UD04 , E.DP_UD05 , E.DP_UD06 , E.DP_UD07 , E.DP_UD08 , E.DP_UD09 , E.DP_UD10 , E.DP_UD11 , E.DP_UD12 , E.DP_UD13 , E.DP_UD14 , E.DP_UD15 , E.DP_UD16 , E.DP_UD17 , E.DP_UD18 , E.DP_UD19 , E.DP_UD20 , E.DP_UD21 , E.DP_UD22 , E.DP_UD23 , E.DP_UD24 , E.DP_UD25 , E.DP_UD26 , E.DP_UD27 , E.DP_UD28 , E.DP_UD29 , E.DP_UD30 , E.DP_UD31 , E.DP_UD32 , E.DP_UD33 , E.DP_UD34 , E.DP_UD35 , E.DP_UD36 , E.DP_UD37 , E.DP_UD38 , E.DP_UD39 , E.DP_UD40 , E.DP_UD41 , E.DP_UD42 , E.DP_UD43 , E.DP_UD44 , E.DP_UD45 , E.DP_UD46 , E.DP_UD47 , E.DP_UD48 , E.DP_UD49 , E.DP_UD50 , E.DP_USESSEASONPROF , E.DP_DETSEASPROFILE , E.DP_SEASONALITYPROF , E.DP_HISTDEMANDPDS , E.DP_EFFDEMANDPDS , E.DP_FCMETHOD , E.DP_CALCULATIONTYPE , E.DP_PRORATE , E.DP_BASEUOM , E.DP_WEIGHT , E.DP_WEIGHTUOM , E.DP_VOLUME , E.DP_VOLUMEUOM , E.DP_NEXTLEVELUOM , E.DP_NEXTLEVELCONV , E.DP_STANDARDCOST , E.DP_STANDARDPRICE , E.DP_AVGPRICE , E.UTILIZ_CD , E.UTILIZ_GROUP , E.DP_FORECASTANALYST , E.DP_STATFOREDEV , E.DP_PRORATEDFOREDEV , E.DP_ADJFOREDEV , E.DP_MEAN_ERROR , E.DP_MEANABSERROR , E.DP_PERIODCREATED , E.DP_YEARCREATED , E.DP_LASTRESETYR , E.DP_LASTRESETPD , E.DP_CURRENTMODELYR , E.DP_CURRENTMODELPD , E.DP_FC_EFFYR , E.DP_FC_EFFPD , E.DP_MA_PERIODS , E.DP_TEMPLATEITEM , E.DP_SUSPENDEDITEM , E.DP_EVALPERIODS , E.DP_UPDATETOINVPOL , E.DP_AUDITREVIEWDONE , E.DP_DESCRIPTION , E.DP_LIFEPROFILE , E.DP_ERRORRATIO , E.DP_TRACKSIGNAL00 , E.DP_TRACKSIGNAL01 , E.DP_TRACKSIGNAL02 , E.DP_TRACKSIGNAL03 , E.DP_TRACKSIGNAL04 , E.DP_TRACKSIGNAL05 , E.DP_ROUNDDECIMALS , E.DP_WEIGHTPROFILE , E.DP_SUMMGROUP , E.DP_MA_FINALLEVEL , E.DP_MA_ALPHA , E.DP_WMA_FINALLEVEL , E.DP_WMA_ALPHA , E.DP_LR_FTEST , E.DP_LR_INTERCEPT , E.DP_LR_SLOPE , E.DP_LR_ELASTICITY , E.DP_LR_TTEST1 , E.DP_LR_TTEST2 , E.DP_SES_FINALLEVEL , E.DP_SES_ALPHA , E.DP_AES_BETA , E.DP_DESB_ALPHA , E.DP_DESH_FINALLEVEL , E.DP_DESH_ALPHA , E.DP_DESH_GAMMA , E.DP_DESH_FINALTREND , E.DP_TESB_ALPHA , E.DP_CROSTON_ALPHA , E.DP_HW_FINALLEVEL , E.DP_HW_ALPHA , E.DP_HW_BETA , E.DP_HW_GAMMA , E.DP_HW_FINALTREND , E.DP_X11_IRREGAVSTAT , E.DP_BOX_ACF_BOUNDRY , E.DP_BOX_AR_PARAM , E.DP_BOX_AR_SEAS_PAR , E.DP_BOX_CONST_PARAM , E.DP_BOX_MA_PARAM , E.DP_BOX_MA_SEAS_PAR , E.DP_BOX_NONSEAS_D , E.DP_BOX_NONSEAS_P , E.DP_BOX_NONSEAS_PDE , E.DP_BOX_NONSEAS_PIN , E.DP_BOX_NONSEAS_Q , E.DP_BOX_NONSEAS_QDE , E.DP_BOX_NONSEAS_QIN , E.DP_BOX_NUM_LAGS , E.DP_BOX_SEAS_D , E.DP_BOX_SEAS_LEN , E.DP_BOX_SEAS_P , E.DP_BOX_SEAS_PINIT , E.DP_BOX_SEAS_PDECAY , E.DP_BOX_SEAS_Q , E.DP_BOX_SEAS_QINIT , E.DP_BOX_SEAS_QDECAY , E.DP_AIC , E.DP_BIC , E.DP_CHI_SQR , E.DP_COCHRANE , E.DP_DW , E.DP_LJUNG_BOX , E.DP_ME , E.DP_MAE , E.DP_MAPE , E.DP_MSE , E.DP_NORMALITY , E.DP_RSQUARE , E.DP_ADJ_RSQUARE , E.DP_RMSE , E.DP_SDE , E.DP_SSE , E.DP_SSR , E.DP_X11_TTEST , E.DP_THEIL , E.DP_STDDEV , E.DP_INHIBITED , E.DP_LIFEPROFILEITEM , E.DP_ROLLBACKPERIODS , E.DP_SEASONALITYTYPE , E.DP_ACCURACY_STAT , E.DP_BOX_TRANS_METH , E.DP_LASTEVALPDS , E.DP_DEMANDAVERAGE , E.DP_ALPHA_DEFAULT , E.DP_BETA_DEFAULT , E.DP_GAMMA_DEFAULT , E.DP_SLOPE_DEFAULT , E.DP_INTERCEPT_DEF FROM PS_DP_ROLEFCITM A , PSOPRDEFN B , PSROLEUSER C , PS_DP_VIEW1USER_VW D , PS_DP_FCITEMS E WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_CONFIGVIEW = D.DP_CONFIGVIEW AND A.DP_CONFIGVIEW = E.DP_CONFIGVIEW AND A.DP_CONFIGLEVEL = E.DP_CONFIGLEVEL AND A.DP_FORECASTITEM = E.DP_FORECASTITEM AND B.OPRID = D.OPRID AND A.DP_TEMPLATEITEM <> 'Y'
|
OPRID