Find All Checked Out Objects Using SQL
Share
Read Time:6 Sec
Use the SQL statement below to find all the objects that are checked out:
select * from ol900/f9861 where sistce=3
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.
More Stories
Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but...
Needle: Package Manifest Browser
Here is a common discussion between a CNC Admin and a JDE Development Manager (if you are lucky enough to...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Needle – Overview of Specifications (SPEC) in Oracle JDE EnterpriseOne
I'm starting a new category of posts called "Needles". It is going to have Oracle Support Documents that I have...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where...
Average Rating