Maximo Open Forum

Hi All,  I'm looking for a query that I can run against the Maximo job plans table to find any JPs that have planned labor associated. 
No luck so far.  Any assistance would be greatly appreciated!

Thanks much!

Glen,

The simplest way to find that data is to use the EXISTS() function in SQL. Something like this:

exists(select 1 from joblabor where jobplan.jobplanid = joblabor.jobplanid)

... should return any Job Plan that has at least one Planned Labor record from the Job Plans application.

Hope this helps,

Alex