Check Checkin/out status of Objects

Objects Checked out
select sipathcd as “Path Code”, simkey as “Machine”, SIOBNM, siuser as “User ID” from OBJ7334.F9861 where SISTCE != ’1′ order by siuser, siobnm;
Versions Checked out
select VRENHV, VRUSER as “User”, VRPID as “Object”, VRVERS as “Version”, VRMKEY as “Machine” from DV7334.F983051 where VRCHKOUTSTS=’Y’ order by vruser, vrpid, vrvers;
Objects created but never Checked-in
Select POOMWUSER, POOMWOBJID, POOMWMKLEY, POPATHCD from SYS7334.F98222 where POOMWOT !=’UBEVER’ and POOMWOST=01 and POOMWCHS=’1′ order by POOMWUSER, POOMWOBJID, POPATHCD;
Versions created but never Checked-in
Select POOMWUSER, POOMWOBJID, POOMWMKEY, POPATHCD from SYS7334.F98222 where POOMWOST=01 and POOMWCHS=’1′ and POOMWOT=’UBEVER’ order by POOMWUSER, POOMWOBJID, POPATHCD;