Query to get all active level-1 WBS

[Former Member]

Hi,

I need to get all active level-1 WBS. do we have any std code/program?

i have query but that doesn't get me what i want. can somebody help me with this thx!

this is my query

but doesn't get me correct WBS.

i have below requirement. one WBS should satisfy all below condition to qualify as ACT WBS.

Thx!

Prema

[raymond_giuseppi]

Use some subquery: In a WHERE NOT EXISTS clause select invalid records, records for your status values list where INACT = space