Technical people have to let off a big amount of time writing the documentations, and for that they do need to have the list of all objects in the project. At times its a hassle when you have more than 20 objects in an OMW Project.
Here’s a simple SQL to retrieve the list of all objects, versions and its scope in an OMW Project.
SELECT ProjectID, ProjDesc, ObjectType, Objects, NVL(ObjectDesc,TRIM(VrJD)) AS OBJDesc, ObjScope, CreatedDate, LastModified FROM (SELECT trim(pmomwprjid) AS ProjectID, trim(pmomwdesc) AS ProjDesc, trim(poomwobjid) AS Objects, poomwot AS ObjectType, trim(simd) AS ObjectDesc, poomwcrtdt AS CreatedDate, CASE WHEN poomwcrtdt=0 THEN 'MOD' WHEN poomwcrtdt>0 THEN 'NEW' END AS ObjScope, poupmt AS LastModified FROM SYS.F98220, SYS.F98222, OBJ.F9860 WHERE pmomwprjid=poomwprjid AND poomwobjid = siobnm(+) AND pmomwprjid ='MYTESTPROJECT' ) LEFT JOIN PY.F983051 ON (trim(Objects) = (trim(vrpid) || '|' || trim(vrvers))) ORDER BY Objects;
All that you have to change is the Project ID (MYTESTPROJECT), with your omw project id, and run it.
Following is the output in Oracle SQL Developer