Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Query for WIP Joined with Resources
Discussion created by
on Apr 23, 2010
on Apr 26, 2010 by senthi
Show 0 Likes
I am looking for a query for WIP data joined with resources. thx R
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Apr 26, 2010 12:58 AM
Hi, Please find the query as below. SELECT W.PROJECT_CODE,W.RESOURCE_CODE, SRM.FULL_NAME, W.TRANSDATE, W.CHARGE_CODE, W.TRANSCLASS, W.QUANTITY, W.SOURCEMODULE, W.NOTES, W.WIPCLASS, W.EMPLYHOMELOCATION, W.EMPLYHOMEDEPART, W.RESOURCE_CLASS, W.TRANSTYPE, W.TASK_ID, WV.STDCOST, WV.BILLRATE, WV.ACTUALCOST, WV.TOTALCOST, W.PROJECT_LOCATION, W.PROJECT_DEPARTMENT, W.DEPARTCODE FROM PPA_WIP W, PPA_WIP_VALUES WV, SRM_RESOURCES SRM WHERE W.TRANSNO = WV.TRANSNO AND W.RESOURCE_CODE=SRM.UNIQUE_NAME AND W.STATUS = 0 AND WV.CURRENCY_TYPE = 'HOME'
--AND SRM.UNIQUE_NAME='1246713'[left] Thanks[left] Senthil.[left]
Show 1 Like
Retrieving data ...
JSESSION ID for AWI Load Balancer question
CA Support Page - Accessing "My Cases" Issue
Pittsburgh Technical Conference 2019
Failover Cluster Monitoring.
Possibility to setup RADIUS(Remote Authentication Dial-In User Service) monitoring?