Promoted EnterpriseOne (E1) Projects

Read Time:45 Sec

So, to continue with the SQL theme from our E1 Development Manager, here is one that retrieves info about the projects that have been promoted since a given date. It gives the Project Name, Project Description, Object Name, Object Description, Object Type and the person’s userid that is on the object in PY.

SELECT PMOMWPRJID PROJ_NAME, PMOMWDESC PROJ_DESC, 
 POOMWOBJID OBJECT_NAME,IFNULL(C.SIMD,VRJD) OBJECT_DESC, 
 POOMWOT OBJECT_TYPE, 
 (SELECT E.SIUSER FROM OL811/F9861 E 
 WHERE E.SIOBNM = C.SIOBNM AND E.SIPATHCD = 'PY811') DEVELOPER 
FROM SY811/F98220, 
 ((SY811/F98222 
 LEFT OUTER JOIN OL811/F9860 C ON POOMWOBJID = C.SIOBNM) 
 LEFT OUTER JOIN COPD811/F983051 ON POOMWOBJID = 
 CONCAT(CONCAT(RTRIM(VRPID),'|'),VRVERS) ) 
WHERE PMOMWPS in ('38') AND PMOMWPRJID = POOMWPRJID AND 
 POOMWOT NOT IN ('UO', 'SE_TASK', 'SE_REL') AND 
 PMUPMJ > 107250 
ORDER BY PMOMWPRJID, POOMWOBJID

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com