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 ...
Change Calendar customization
How to modify the fields displayed on the change calendar view for 31 days (month)?
Remove Type Field From Change Calendar ?
[COMMUNITY WEBCAST] - CA Rapid App Security - July 12, 2018 @ 11 a.m. ET
INDEFINITE MAINTENANCE UIM