AnsweredAssumed Answered

Need to get YTD Actuals for a Program

Question asked by armsct48 on Mar 30, 2010
Latest reply on Apr 1, 2010 by sundar
All,  I need get YTD actuals from a specific Program, not  Project,  and my  sql query  is not returing any data/rows.   I'm on 7.5.3 and Oracle. Any suggestions?  SELECT W.PROJECT_CODE,W.RESOURCE_CODE,W.TRANSDATE,W.CHARGE_CODE,W.TRANSCLASS,W.QUANTITY,W.WIPCLASS,WV.TOTALCOST
FROM    
SRM_PROJECTS S,PPA_WIP W,PPA_WIP_VALUES WV    
WHERE S.UNIQUE_NAME = W.PROJECT_CODE
AND W.TRANSNO = WV.TRANSNO      
AND W.STATUS=0    
AND W.TRANSDATE >='01-JAN-2010'
AND W.PROJECT_CODE = 'XXXXXXXX'
AND WV.CURRENCY_TYPE = 'HOME'
AND IS_PROGRAM = 1      

Outcomes