SQL query for Work Definition Details Unassigned Items

Summary:

Hi!, I'm looking for a SQL query for Work Definition Details which identify Unassigned Items. I try with material disable date, effective date, inventory item status code, etc. But I can't identify Unnassigned Items .

Thanx for your help!

Content (please ensure you mask any confidential information):

Supply Chain Execution --> Work Definition --> Manage Work Definitions -- >

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications 24A

Code Snippet (add any code snippets that support your topic, if applicable):

With this query I can Perfectly identify assigned items on Work Definition:

select  

 wd.work_definition_id