|
SELECT DISTINCT(B.OPRID) , A.DP_CONFIGVIEW , A.DP_CONFIGLEVEL , A.DP_FORECASTITEM , A.DP_FCITEMCAPTION , A.DP_TEMPLATEITEM , A.DP_LIFEPROFILEITEM , E.DP_CALCULATIONTYPE , E.DP_AUDITREVIEWDONE , E.DP_STATFOREDEV , E.DP_DEMANDAVERAGE , E.DP_ERRORRATIO , E.DP_STANDARDCOST , E.UTILIZ_CD , E.UTILIZ_GROUP , E.DP_LASTRESETYR , E.DP_LASTRESETPD , E.DP_HISTDEMANDPDS , E.DP_SUSPENDEDITEM , E.DP_EFFDEMANDPDS , E.DP_FC_EFFYR , E.DP_FC_EFFPD , E.DP_FCMETHOD , E.DP_CONTROLGROUP , E.DP_TRACKSIGNAL00 , E.DP_TRACKSIGNAL01 , E.DP_TRACKSIGNAL02 , E.DP_TRACKSIGNAL03 , E.DP_TRACKSIGNAL04 , E.DP_TRACKSIGNAL05 , E.DP_SEASONALITYTYPE , E.DP_SEASONALITYPROF , E.DP_WEIGHTPROFILE , E.DP_LIFEPROFILE , E.DP_DESCRIPTION , 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_COLLABREVDONE , E.DP_ADJFOREDEV , E.DP_AVGPRICE , E.DP_BASEUOM , E.DP_CURRENTMODELPD , E.DP_CURRENTMODELYR , E.DP_DETSEASPROFILE , E.DP_EVALPERIODS , E.DP_FORECASTANALYST , E.DP_MA_PERIODS , E.DP_ME , E.DP_NEXTFCITEM , E.DP_NEXTLEVEL , E.DP_NEXTLEVELCONV , E.DP_NEXTLEVELUOM , E.DP_PERIODCREATED , E.DP_PRORATE , E.DP_PRORATEDFOREDEV , E.DP_STANDARDPRICE , E.DP_UPDATETOINVPOL , E.DP_USESSEASONPROF , E.DP_VOLUME , E.DP_VOLUMEUOM , E.DP_WEIGHT , E.DP_WEIGHTUOM , E.DP_YEARCREATED 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
|
OPRID