Promoted EnterpriseOne (E1) Projects
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
Tags: e1, enterpriseone, EnterpriseOne - General, EnterpriseOne - SQLs, omw, oracle, peoplesoft, sql
